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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4dc89d05-f98e-4fce-ab4d-5d6669ebbe77.png)
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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/c6970254-dccd-4546-b3d1-6bf3e8735217.png)
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 andywingrave
View original