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.

Hey there Zapier folks!  I am trying to work out how to format some data from a GET request in Zapier, but am really struggling with trying to set up the pattern via REGEX or some other separator as currently the data is pretty much unusable.  Some example data of the GET is here:

<{"Header1":"Value1","Header2":"Value2","Header3":"Value3","Header4":"Value4","Header5":3250},{"Header1":"Value1","Header2":"Value2","Header3":"Value3","Header4":"Value4","Header5":0},{"Header1":"Value1","Header2":"Value2","Header3":"Value3","Header4":"Value4","Header5":1000}]

 

It really really tough to separate but maybe because I have little idea what I am doing.  Everything seems to come over in a single object named INVENTORY:

 

The values named HEADER should each be a unique “field” inside of Zapier, with the “values” changing based on the record.  In this example there are 3 separate records I am trying to bring in, but I cannot get them to separate into any sort of usable format.

I tried using LOTS of text filters to do things like remove brackets, remove quotes, separate using commas, brackets, etc.  I am just not understanding how to get it to “parse” or how to “define” the field names…  

 

When I look at this in a table form I would love for it to look like this so I can easily set it up in Zapier:

 

Hi @Sh0ck3d 

Which Header indicates the unique record ID? (e.g. Header5)

 

That will likely involve using a custom Code step.

Try asking ChatGPT for help configuring the Code.

Or if you need help, consider hiring a Certified Zapier Expert.

Hey Troy!  Thanks for the swift response!  

Sorry my example is honestly pretty trash, but the “unique value” field is in Header4.  Based on what I looked at you are right and the CODE entry would probably be much better than trying to do “everything” using the included Zapier steps.  

Hi @Sh0ck3d, 

For your specific use-case I would suggest to give quik.run a try. It's a versatile tool from where you can create custom code snippets, and seamlessly integrate with Zapier to incorporate your snippets directly into your Zap workflows.

 

Please refer to this blog to know more about QuikRun. If you'd like further assistance or have any questions, feel free to connect with me at nparashar150@gmail.com or naman@quik.run. I'd be more than happy to help you get this up and running as soon as possible.

Terms & Conditions