Json path and Metadata issue

borrisbeck — Sat, 16 Nov 2024 06:00:04 GMT

I'm trying to create Json metadata file using the option under "Metadata>File Json" in talend. The file works perfectly if i choose "Xpath". But if I choose "JSON Path", I'm not able to retrieve the first 4 columns (user_id, user_name, friend_name, friend_id), I think there is something wrong with the way I specify the "Relative or absolute path expression". Can someone shed some light on it?

JSON Metadata

Json file

{"user": {
    "id": "9999912398",
    "name": "Kelly Clarkson",
    "friends": [
        {
            "name": "Tom Cruise",
            "id": "55555555555555",
            "likes": {"data": [
                {
                    "category": "Movie",
                    "name": "The Shawshank Redemption",
                    "id": "103636093053996",
                    "created_time": "2012-11-20T15:52:07+0000"
                },
                {
                    "category": "Community",
                    "name": "Positiveretribution",
                    "id": "471389562899413",
                    "created_time": "2012-12-16T21:13:26+0000"
                }
            ]}
        },
        {
            "name": "Tom Hanks",
            "id": "88888888888888",
            "likes": {"data": [
                {
                    "category": "Journalist",
                    "name": "Janelle Wang",
                    "id": "136009823148851",
                    "created_time": "2013-01-01T08:22:17+0000"
                },
                {
                    "category": "Tv show",
                    "name": "Now With Alex Wagner",
                    "id": "305948749433410",
                    "created_time": "2012-11-20T06:14:10+0000"
                }
            ]}
        }
    ]
}}

Thanks

Re: Json path and Metadata issue

vapukov — Thu, 25 Apr 2019 14:48:55 GMT

it is true - JSON PATH does not support parent operators

old, but still good article:

https://goessner.net/articles/JsonPath/

Re: Json path and Metadata issue

borrisbeck — Thu, 25 Apr 2019 15:15:37 GMT

Yeah, I read that article before posting and even used the examples in constructing the metadata, but i'm still failing to understand how to retrieve those columns.

Re: Json path and Metadata issue

vapukov — Thu, 25 Apr 2019 15:23:03 GMT

just use XPath, it work well

topic Re: Json path and Metadata issue in Talend Studio

Json path and Metadata issue

Re: Json path and Metadata issue

Re: Json path and Metadata issue

Re: Json path and Metadata issue