I'm having a frustrating issue with a Zap that uses the "Webhooks by Zapier → Custom Request" action to pull data from an external API. The API returns a large JSON array (around 300 objects), each containing the same fields with different values.
However, instead of Zapier providing me with a single structured JSON response that I can easily parse, it's breaking the response down into hundreds of individual fields. So when I get to the next step ("Code by Zapier") to process this data, the input options are hundreds of individually flattened fields, like:
1.className
1.id
1.someOtherField
2.className
2.id
2.someOtherField
(and so forth, for hundreds of objects)
What I actually need is to access the response as a single structured JSON payload—exactly how it appears in Postman—so I can parse and handle the entire array at once.
and toggled the "unflatten" option, but none of these settings have changed Zapier's behavior. It still flattens the response into individual fields.
How can I get Zapier to stop flattening my JSON response and just provide the entire structured payload in one piece? Surely there must be a straightforward solution here, as manually selecting hundreds of fields isn't practical or sensible.
Any clear guidance would be greatly appreciated!