Hey @Manuel - Interesting, it seems like the API isn’t allowing us to export row-by-row and instead needs all the data in a single request.
To workaround this problem, please add an Insert Column step and a Merge Values step right before your Send to API step.
In the Insert Column step, we’re going to create a new column that replicates the body you’re sending in your API step minus the square brackets
[ ], like so:
In the Merge Values step, we’re going to create a comma-separated blob of the new
API Body column you created with the Insert Column step.
- Select API Body under “Merge all the values in the following columns”
- And separate each value by
, (with no space).
- Keep create a new row for each unique value in the following columns blank.
Once you do have a single cell that contains all the data you’re trying to export, update the body of your API Export step to just be:
That should do the trick, and export all the data to the API in a single request. Let me know how that goes!