Hello! I have a question regarding a request I’m making to an API via webhooks. Everything is working correctly, and I’m given the response I expect - Hooray!
The response Zapier gives me is a beautiful, magnificent array of objects in exactly the format I need. as follows:
An array of objects - Columns and values. This is exactly what I need, and when inspecting this response I see that it is being given to me exactly how I need it.
But for some maddening reason, when I go to use this array in a code step, Zapier garbles it all up into two non-descript strings, which breaks everything.
Has anyone come across this before? What can I do to either retain the response from the API or re-build it?
Sadly it’s not as simple as using String.split(‘,’) in this case because column 2 has a tonne of unescaped commas, that I basically can’t handle as they follow no pattern.
Best answer by andywingraveView original