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:
[{new_merge_value_column}]
That should do the trick, and export all the data to the API in a single request. Let me know how that goes!