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.

Question

Zapier only outputs first json object, having troube useing looping

D

I have been given the assignment to connect our company's API to Zapier with custom connectors. This appears to be working although it only returns the first item of the JSON object (fig 1) which seems to be the norm for zapier. I added the option (fig 2) to output all data with 0.Name 0.Sequence 1.Name 1.Sequence. etc. form (fig 3), however neiither yield what we want. We have a use case that loops over all applications in our software and performs some actions with each application but zapier only does all the steps with the first one I tried to add looping and formatting but I'm just a bit to novel to really be able to apply it to our own API.

Does anyone know how I would be able to accomplish our goal of having one run loop over each application available?

 

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @DNAmon 

You may need to try using the Code step to make the API request so it returns all the results.

Or you can try using the Webhook app to make an API request.

 

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

First, set up your trigger and initial API call. Begin by setting up the initial trigger for your Zap, which could be a schedule, a webhook, or another app's event. Then, use a "Webhook" action to perform a GET request to your API to fetch the list of applications. Ensure this step successfully retrieves the full JSON array of applications.

Next, use "Looping by Zapier" to iterate over applications. Add a new action after your API call, select "Looping by Zapier" as the app, and choose the "Create Loop from Line Items" event. In the "Values to Loop" field, map the array of applications from your previous step. This might look something like {{Webhooks.response_body}} where response_body is the key containing your array of applications.

Then, perform actions for each application inside the loop. Add the actions you want to perform for each application within the loop. These actions will be repeated for each item in the array. Use the data from the looping step to map individual application fields, referencing them appropriately, such as {{Looping.Name}} and {{Looping.Sequence}}.

Reply


Terms & Conditions