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:
