Return a field in my json input as output in a code node

Questions
1

I have a json input that looks something like this:

[
{
“headers”: {
//some data
},
“params”: {},
“query”: {},
“body”: {
// some data,
“employees”: [
{
“first_name”: “Osarumen”,
“last_name”: “Alohan”,
“position”: “Backend Engineer”
},
{
“first_name”: “Bill”,
“last_name”: “Gates”,
“position”: “CEO”
}
]
}
}
]

I want to output the array of ‘employees’ from the code node so I can loop over and add them to a database. I’m unable to find a solution that works from the docs and I keep getting errors. Please help

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

n8n version: 1.12.1
running n8n via: n8n cloud
operating system: windows

4

Hey @Osas,

Have you tried using the Split Out node on body.employees that will give you something like this.

image
image1272×438 50.5 KB

You can find a test workflow below for this.

5

Thanks a lot @Jon. This helped. However I noticed that when I attempt to use input from a node not immediately preceding the split out node I get an empty output

6

Hey @Osas,

Yeah if you are splitting out the data we expect it to be from the node before it, If you wanted to go further back you would need to use a code node and manually write out a bit of code to get the data from the previous node and split it out into items.