Combine Multiple JSON Outputs To A Single CSV File

Questions
1

I have three different JSON outputs inside of my workflow with different key values.

So lets say the 1st JSON output is the following
{
“Name”:“Test”,
“Number”:1234567890
}

2nd JSON Output:
[
{
“Address”:“123 Main St”,
“City”:“Kansas City”,
“State”:“MO”,
“Zip”:12345
},
“Address”:“123 Test St”,
“City”:“St Louis”,
“State”:“MO”,
“Zip”:54321
}
]

And 3rd JSON Output:
{
“FavoriteAnimal”:“Dog”,
“LastTrip”:“Hawaii”
}

The output I would like the CSV to be like the following.
Sample CSV Output

Information on your n8n setup

  • n8n version: 1.41.1
  • Database (default: SQLite): SQLite
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu Linux
2

Hi @CVMatt, thanks for reaching out and being a part of the community!

This question comes up again every so often. Take a look at these resources and try the recommended solutions. If you still need assistance, I or someone else in the community might be able to give you a more hands on answer.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.