Hey,
I need some help figuring something out. I tried searching the forums and although I found some usefull posts it was not completely applicable to my case, which made it difficult to apply it.
From a HTTP-request I am getting a peculiar JSON result
[
{
"headers": [
"header1",
"header2",
"header3",
"header4",
"header5",
"header6",
"header7",
"header8",
"header9"
],
"values": [
[
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
},
{
"data": "data",
"text": "text"
}
],
]
}
]
As you can see there are 2 (in my opinion) strange things:
- Headers are seperate
- All 9 fields are in seperate objects instead of 1
My question is would it be possible to
- Combine/merge all objects within the brackets ([]) together?
- Add the headers to those objects instead of the text label?
- Remove the data-fields?
I have already removed/changed quiet some things, but these last 3 i cannot seem to figure out
Information on your n8n setup
- n8n version: 0.193.5
- Database you’re using (default: SQLite): postgres
- Running n8n with the execution process [own(default), main]: own
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: docker