zumzum
January 16, 2022, 10:10pm
1
Hello guys,
sorry for now, I dont use json so often,
so i have a json file, with one data entry that I want to split:
I tried a couple of JavaScript Codes in Function to split and grab only the value from first_name, but I don’t know how.
Of course this is only one example, I have several entries under data.
In the end I want to sort all first_names under the type Employee.
Maybe some of you guys have a hint for me. Thanks
[
{
"success": true,
"data": [
{
"type": "Employee",
"attributes": {
"id": {
"label": "ID",
"value": 111111,
"type": "integer",
"universal_id": "id"
},
"first_name": {
"label": "First name",
"value": "Max",
"type": "standard",
"universal_id": "first_name"
}
}
}
]
}
]
zumzum
January 16, 2022, 10:50pm
2
with
return items[0].json.data.map(item => {
return {
json: item
}
});
I have a column with type and a lot of entries with the same value ‘Employee’
and one column with attributes with a new string with includes all data after.
So a bit close but still lost.
But now I need the next level where I have column with name, id etc.
The Item List node along with the function item node below should do it:
const { attributes } = item
const keys = Object.keys(attributes)
for (key of keys) {
item[key] = attributes[key].value
}
delete item.attributes;
return item
Example workflow
zumzum
January 17, 2022, 9:20am
4
Thanks Ricardo,
I hope this example will also help me to understand more about javascript and n8n
Good example ,
1 Like