I have a json I need to import using feeds_ex with the following structure/example:
[
{
"id": 111,
"import_status": null,
"name": "ABC Test",
"content": "testing",
"created_at": "2024-12-04T21:42:22.000000Z",
"updated_at": "2024-12-04T22:03:19.000000Z",
"page_title": "ABC Test",
"commercial_activites": [
{
"id": 555,
"organisation_id": 111,
"published_status": "Published",
"published_at": "Thursday, 19 December 2024 11:58 UTC",
"name": "Activity 01",
"content": "123",
"created_at": "2024-12-19T23:44:49.000000Z",
"updated_at": "2025-01-07T05:09:09.000000Z",
},
{
"id": 556,
"organisation_id": 111,
"published_status": "Published",
"published_at": "Thursday, 19 December 2024 11:58 UTC",
"name": "Activity 02",
"content": "123",
"created_at": "2024-12-19T23:44:49.000000Z",
"updated_at": "2025-01-07T05:09:09.000000Z",
}
]
}
...
]
I am using a JSON JMESPath for the json import.
The issue is I need to imported the nested JSON array of objects "commercial_activities".
I used the context "[*].commercial_activities[*]", however the nested "commercial_activities" are not being picked up.
Would anyone know how to I can import the nested JSON array of objects?
Thank you for your assistance in this matter.
Active
Code