Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hi folks, 

I was able to set up a webhook action to grab bill information from the LegiScan API and when I look at the data out it looks great. I see a visual representation of the data like it’s in an array for each search result: 

What I would like to do is set up a loop that does something with each item in the array searchresult.

When I go to do any other action, what I have is separate line items for every piece of information:

I also can’t take advantage of the Code action to group this information together because I’d have to add each of those results (9 pieces of information and 100 results = 900 variables). I’m not sure where to go from here to put each search result into Airtable rows. 

Anyone else run into this? Any help greatly appreciated!

Hi @dev_ttse 

Try this trick:

 

Then you can use a Code step to parse and prep the data.

 

The Looping app can then be used to iterate the items: https://zapier.com/apps/looping/help

Thanks so much @Troy Tessalone this is indeed totally what I’m looking for, however, maybe I’m not implementing it correctly?

I set up the second zap and sent the data to the second zap through a webhook just like the guide recommended, sending as a “form” or as “json” worked but still ultimately returned the same individual variables as the first zap. I switched to the Catch Raw Hook option and that was closer to what I was looking for with the raw API response coming through.

Now I’m trying to parse the json with the Code action and when I parse the JSON Zapier again removes the array:

Any other tips on how to parse this out to line items? I really appreciate your help.

@dev_ttse 

You can’t just parse the raw JSON.

You need to add custom code to parse the raw JSON to create new arrays.

Terms & Conditions