JSON to CSV files unique

Questions
1

Hello,
I want to create a flow as follows: I retrieve the JSON files from an FTP server, download them, convert them to CSV, and then store them in another FTP server. However, I want to convert the files to CSV one by one, not like I do, where all the JSON files are converted into a single CSV file.
The nodes used are:
List FTP
Download FTP
Extract from JSON file
Split Out

I stopped here because if each file has 5 JSON objects, and I want each JSON object to be a row in the CSV file, it creates a single final file with 10 items.

Does anyone know how to fix this?

image
image1654×740 62.5 KB

2

Hey @Josep_Garcia

Replace your current flow after “List FTP” with a Loop Over Items:

When clicking ‘Execute workflow’ → List FTP → Loop Over Items → Download File FTP → Extract from File → Convert to File

Configure Loop Over Items:

  • Connect it right after “List FTP”
  • This will process each JSON file one at a time, completely finishing one before starting the next

Let me know if that works

1 Like