About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Looping through items in an array.

  • 27 January 2024
  • 4 replies
  • 202 views
rmwarner
Userlevel 1

My data comes in via a webhook and is formatted as shown below. When I attempt to loop through the line items I am only getting the first line item. What step am I missing to be able to go through these line items? Specifically I am trying to add records to a Google Sheet and Airtable base, but I can handle those action steps just fine as long as I can get the results for all line items.

 

Again, what step am I missing to be able to go through these line items?

 

 

icon

Best answer by rmwarner 30 January 2024, 19:27

View original
Randy Warner

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @rmwarner 

Even though the field names say “Line Items”, the data is not actually structured as Line Items.

Each field is its own variable.

 

If you have control over how the data is being sent to the webhook, then that may be the best place to fix the issue with the structure of the data to be an array.

Since it’s likely there can be N line items, you may have to get the RAW webhook data payload, then use a Code step to create arrays, to then use in the Looping app.

 

Resource to reference.

 

If you need help, consider hiring a Certified Zapier Expert.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
rmwarner
Userlevel 1

Thanks @Troy Tessalone 

 

The good news is that I am the one who structures the payload being sent. The interesting thing is that when I look at what is actually being sent, the JSON does actually reflect that it is an array, so I’m not entirely sure where the disconnect is…


For what it’s worth, when I catch the same Webhook in Make.com, it does show up as an array, as I expect to…

Randy Warner
Troy Tessalone
Userlevel 7
Badge +14

@rmwarner

We would need to see screenshots with how the Zap webhook trigger step is configured and how the webhook is configured in the source app to have more context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
rmwarner
Userlevel 1

@Troy Tessalone - Figured it out! I was able to simply add a header from my source to help Zapier know how the data was formatted and we’re all good to go now. Thanks for your help.

Header

Content-Type: application/json

Randy Warner

Reply


Terms & Conditions