Converting an array of arrays to csv where each nested array is a csv row

Hi,
It’s my first post here, I’m glad to see so much resources on this community so far.

I am struggling with transforming a json response to a csv file. So far the research on community hasn’t helped me, I must still be doing something wrong.

I am trying to convert a web response in JSON format to a csv file.

If you look at the image, the [1] array is already the array from inside of an array that should be called rows but doesn’t get displayed here.

The issue is that I get multiple arrays inside of a single array. I tried many different operations, from Iterator I got multiple bundles with an array inside each of them. From each I need to extract all 8 key-value pairs, essentially from each of the nested arrays I need to create a csv row.

Unfortunately if I select an action after the Iterator, I get nothing useful:

Another question is if it can be done with the least operations possible as the operations are very limited even on premium tiers and my dataset will be much bigger then the one I’m using for development.

I attach the output of Iterator.

I will be grateful for any suggestions.
All the best

output.json (4.6 KB)

Hi @dumptj , Have you tried CSV creator (advanced) module ? If your data structure is fixed, you can just define columns and then put whole arrays as an input and convert whole request in a CSV in only 1 operation.