If there is no way to do it via the GUI, what is the easiest way to take this data from the previous node and iterate over it to then export it to google sheets? I’m not strong on javascript.
You will have to combine all these results into one single item. You will have to use the Function node to do it. You can refer to the code snippet mentioned in the documentation. I would also suggest you to take a look at the Data Structure documentation to understand the structure n8n uses.
maybe i am missing something, but using that same documented workflow i still get one output its just nested it all in data_objects, but there are still multiple arrays below in there to process exactly as before
Hey @RedPacketSec, is it possible to share the URL of the API? That would be helpful to prescribe the solution using the Function node. Feel free to DM me, in case you cannot share it publicly
#This is the format of the API output of MY API service
{
"meta": {
"limit": 1000,
"next": "/api/v1/xxxxxxxxxxxxx",
"offset": 0,
"previous": null,
"total_count": 75679
},
"objects": [
{
"a": "1",
"b": "2",
"v": "3",
}
{
"a": "1",
"b": "2",
"v": "3",
}
]
}
I need each nested objects to be processed and end up here
But this works now, thank you so much for helping me, you must get these simple problems all the time. Sorry for wasting your time due to my user error it seems!