Describe the issue/error/question
I try to list the officers of UK companies from companies house data. Each company can have several Officers.
{
"officers":
[
{
"links":
{
"self":
"/company/SC606050/appointments/BhjxL7_xEYisSpsJxFnnuCg2-KI",
"officer":
{
"appointments":
"/officers/58W4ktOEXS81o39P1gR0gGB3Fmg/appointments"
}
},
"country_of_residence":
"Scotland",
"date_of_birth":
{
"year":
1972,
"month":
7
},
"nationality":
"British",
"officer_role":
"director",
"occupation":
"Director",
"appointed_on":
"2018-08-22",
"name":
"WIGHAM, Timothy Walter",
"address":
{
"country":
"Scotland",
"premises":
"26 Polmuir Road",
"locality":
"Aberdeen",
"postal_code":
"AB11 7SY"
}
},
{
"officer_role":
"director",
"nationality":
"Dutch",
"date_of_birth":
{
"year":
1974,
"month":
7
},
"links":
{
"officer":
{
"appointments":
"/officers/n2uRM6L3O_yLRz_BA8UoHDExLb0/appointments"
},
"self":
"/company/SC606050/appointments/CkElVaAlHahzh0gtBTjVbm08Qys"
},
"country_of_residence":
"Scotland",
"address":
{
"locality":
"Aberdeen",
"postal_code":
"AB11 7SY",
"premises":
"26 Polmuir Road",
"country":
"Scotland"
},
"name":
"WIGHAM DE BOER, Aafke",
"occupation":
"Director",
"appointed_on":
"2018-08-22"
}
]
},
I need to split the officers into separate items and afterwards the other attributes like address into separate fields.
I get the error âERROR: Couldnât find the field â [object Object]â in the input dataâ
What is the error message (if any)?
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
- n8n version: 0.198.2
- Database youâre using (default: SQLite):
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: desktop app mac