Importing nested JSON array using JSON JMESPath

Created on 13 April 2025, 12 days ago

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.

💬 Support request
Status

Active

Component

Code

Created by

🇦🇺Australia ajlow

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024