I have a webhook set up to pull lead data from salesforce and occasionally it will return multiple records combined into a single response. This is due to an API updating multiple records in salesforce at once.
If you look at the images below, I have three records worth of data nested into the one response. How can I separate these into individual responses?
Best answer by Troy TessaloneView original
Try using the Looping app for these arrays: https://zapier.com/apps/looping/help
@Troy Tessalone will this work if all the records show up in one response with multiples for each line item.
Eg, Type_of_Cuisine shows up as three lines with three different values. It’s not one line with three values that are separated.
When you go to map the values, the data is combined into an array per data point, which is different than how it displays broken out in the screenshots.
Give it a try and let us know how it goes.
The loop hit an error
Required field "Values to Loop" (loop_values) is missing.
There are three individual arrays in the response, each with duplicate data points. The values have been mapped appropriately (I think) however no values made it into the loop from the webhook response.
Any ideas on how to make this work?
You may have to try process of elimination in order to isolate the data point causing the issue OR try a different Looping type.
Text may not work since there’s no delimiter for most data points. It’s one response per line (except for 2 responses where you’re supposed to get multiples ie, Mon, Tues, Wed, etc)
I’ll give it a try though