Getting a value from a JSON object using JSONPath

Asked Sep 23 '20 at 13:12

Active Sep 23 '20 at 13:19

Viewed 41 times

I have the following JSON and I need to get the plain name value using JSONPath:

{
    "data": [
        {
            "code": "ABC",
            "metadata": 
                {
                    "id": "111",
                    "data": "2020"
                }

        },
        
        {
            "code": "123",
            "metadata": 
                {
                    "id": "222",
                    "data": "2018"
                }

        },
        
        {
            "code": "XYZ",
            "metadata": 
                {
                    "id": "555",
                    "data": "2018"
                }

        }
    ]
}

I want to get the value of a variable "code" via "id". Expression that I used is $.data[?(@.metadata.id == '222')].code to get the "code"="123". But it doesn't work. What am I doing wrong?

edited Sep 23 '20 at 13:19

asked Sep 23 '20 at 13:12

Romashko324

That should work. Could you please show your code? – Christian Baumann Sep 23 '20 at 13:24
@ChristianBaumann, the code is not available to me, I can only enter expressions. Are there any alternatives to this expression? – Romashko324 Sep 23 '20 at 13:51
The expression does work. – Jack Fleeting Sep 23 '20 at 15:44
Seems to be the same question as https://stackoverflow.com/q/63470519/878701 – gregsdennis Oct 06 '20 at 19:27
It may be more of an issue of expression support in the library you're using. Some libraries don't have support for detailed expressions like this. – gregsdennis Oct 06 '20 at 19:28

Getting a value from a JSON object using JSONPath

0 Answers0