I am currently using a loop to page the results of a HTTP Request node and work with 50 of them at a time. However, the workflow is not exactly how it was envisioned. To fix it, I’d have to go into the loop right after the Itemization node, do it to all results, and only after that add all of them to the same spreadsheet file and send it via FTP. Is there a way I can gather up all the results into the same spreadsheet file?
If you want to merge the executions runs there is a handy workflow here: https://n8n.io/workflows/1160 that provides an example on doing that. It may provide the answer for what you are trying to do.
@Jon what’s the best way to do this when not using a SplitInBatches node? In the example workflow you can count on the NoItemsLeft to get a single execution to the function node. In other circumstances how would you get just the last execution though?
Good question, It all depends on the workflow and the data you have and if you have anything that tells you that you are at the end. The import part of the workflow shared is the last function node though does the merging of execution data.
Looking at the example workflow provided it could be that something like the below would do the job.
