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!

I used the webhook by Zapier and got the following data

 

I wanted to put the data in columns using google sheet / create spreadsheet row(s) but Zapier is not finding the line items because of the weird format as shown below: 

 

I guess I need to format it properly using Format by Zapier but I have not clue how to do this. I tried to remove the h] but it didn’t work. 

Hi @Ramy 
What app is sending the webhook?

Perhaps the settings need to be adjusted in the originating app to avoid the nested line items.

Hi @Troy Tessalone !

I got the data from this end point https://api2.timedoctor.com/api/1.0/activity/worklog 

As shown below; I tried different settings of Send as Json and Unflatten but either it doesn’t work or its the same

 

@Ramy 

You may have to use a Code step to handle the JSON formatting with nested line items:

Terms & Conditions