Multi Level Json

root — Wed, 18 Apr 2018 20:21:29 GMT

I have a JSON object with following structure (sample). As far as I can see, there are three levels...

Parent
- Child
  - Grand-Child

What will be the best way to consume this and maintain a parent-child-grand-child relationship in a table? I am not able to see good documentation on tExtractJSONFields/ tFileInputJson.

Any pointers appreciated.

{
    "categories": [{
        "id": "P1",
        "name": "P1",
        "path": "P1",
        "children": [{
            "id": "P1_C1",
            "name": "P1_C1",
            "path": "P1_C1",
            "children": [{
                "id": "P1_C1_xC1",
                "name": "P1_C1_xC1",
                "path": "P1_C1_xC1"
            }, {
                "id": "P1_C1_xC2",
                "name": "P1_C1_xC2",
                "path": "P1_C1_xC2"
            }]
        }]
	}]
}

Re: Multi Level Json

Anonymous — Tue, 24 Apr 2018 09:30:51 GMT

Hi
Using 'Xpath' model and set the xpath loop expression to:
/categories/children/children
You should be able to read parent-child-grand-child data.

Regards
Shong

topic Multi Level Json in Talend Studio

Multi Level Json

Re: Multi Level Json