Hi folks,
I need to create multiple records from nested arrays in a web hook payload.
Initially will write them to a Google Sheet until we know it is valid and will write it to our CRM.
Trying to use Loop by Zapier which works great on a flat loop, but nested isn’t supported.
The data is for Products,
- broken out into editions (e. gold, silver, bronze)
- further divided into payment plans (monthly, yearly)
- further divided into price breaks ( 1-100@$20ea, over 100@$15ea)
I need to create product record for every price break.
Webhook data comes in similar to this:
product:
name: Widgets
editions:
1:
Name: Bronze
Plans:
1:
frequency: monthly
costs:
1:
quantity: 1-12
price: 20
2:
quantity:12-24
price: 15
2:
frequency: yearly
costs:
1:
quantity: 1-500
price: 10
2:
quantity: 500-1000
price: 5
2:
Name: Silver
Plans:
1:
frequency: monthly
costs:
1:
quantity: 1-12
price: 30
2:
quantity:12-24
price: 25
2:
frequency: yearly
costs:
1:
quantity: 1-500
price: 20
2:
quantity: 500-1000
price: 15
3:
Name: Gold
Plans:
1:
frequency: monthly
costs:
1:
quantity: 1-12
price: 40
2:
quantity:12-24
price: 35
2:
frequency: yearly
costs:
1:
quantity: 1-500
price: 30
2:
quantity: 500-1000
price: 25
