This post was split from the topic: How to Parse JSON style key value pair arrays into Zapier Mappable Values
Thanks for posting this. I came across it looking for a solution to this issue, but mine is a bit more complex so the above doesn’t work exactly as expected.
My data comes comes in an array where each object can have a slightly different schema. To give an example, each object in the array might have a Description, so say a 3 item array will come through as Description like Item1,Item2,Item3 but say only Item1 and Item3 has a property called Rate, and that will come through as Rate1,Rate3
You can see how solutions that manipulate strings can come up short in this situation - the descriptions don’t line up to the corresponding rates and concatenating these into a string and parsing that will give unexpected results.
Ideally I’d just like to take the raw JSON output of the trigger (it’s Qwilr btw) and send it out as-is in another action, but I can’t see how to do this so I’m trying to reconstruct an array back into a format I can reliably parse.
What is the best solution to this problem?
Best answer by SamBView original