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 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

Format weird (nested) line items to proper line items

  • 15 September 2021
  • 3 replies
  • 104 views
R

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 [] but it didn’t work. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Userlevel 7
Badge +14

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.

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

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

 

Troy Tessalone
Userlevel 7
Badge +14

@Ramy 

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

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