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.

Hello everyone,

I'm currently working on a project where I'm using a Zapier webhook to make a GET request to the Lockimmo API. The data I'm receiving from the API is not being formatted correctly by Zapier, and I'm having trouble using it in my subsequent actions.

The data from the API is in JSON format, but it seems like Zapier is not parsing it in the way I expect. I'm trying to use this data to create or update items in monday.com or even google sheet, but the format of the data is not compatible.

Here's an example of the data I'm receiving from the API:

{items : { 1 : { my_data.name, my_data.foo },2 : { my_data.name, my_data.foo }}}
and as output I got all the name of my_data.name in one variable, same for others keys.

I must precise I have like 400 items in this list and have many keys around 30, but only 10 are needed.)

I need to be able to create for each item, a new row or a new item in monday.com

I also try to use the Formatter by zapier, but I end up with the same result.

Thanks ahead for your help.

Hi @kevinaz 

Good question.

To help give us full and proper context, please post detailed screenshots with how your Zap steps are configured along with the data outputs you are trying to use, thanks.

getting the data from my url ( get action) the data format is an array of objects.
This how the data looks like. Each number is an object from the array. so we have user 1 and then user 2. 
Trying to setting up that on googlesheet. For each user, I want a row. But when I try to link the userID field, I get all the userID in one cell in the first row.

@Troy Tessalone 

I hope this help to understand. Thanks ahead for your help!

@kevinaz 

Try using this Zap action: GSheets - Create Row(s)

 

I missed this action !! Thanks a lot @Troy Tessalone <3 !
I have another question, If I want to create the rows, but only when there is a new item compare to the existing table, how would you manage it ?
Many thanks again

@kevinaz 

You’d have to use these steps:

Action: Looping - Create Loop from Line Items

Action: GSheets - Lookup Row (with the Create Row checkbox enabled)

@Troy Tessalone 

Many thanks you rock !

Terms & Conditions