Select a JSON attribute based on other elements within an array using JSONPath

Question

I have a sample JSON array:

{
"data": {
    "list": [
        {
            "id": 192,
            "name": "John Black",
            "username": "jblack",
            "email": "[email protected]",
            "extern_uid": "user distinguished name"
        },
        {
            "id": 63,
            "name": "Jane Doe",
            "username": "jadoe",
            "email": "[email protected]",
            "extern_uid": "user distinguished name"
        }
    ]
}}

I want to extract an attribute based on another attribute using JSONPath expression,

For example:

I want to search for the name "Jane Doe" and extract values from the Jane Doe array like id: 63 or any other value in the Jane Doe array. Is this possible in JSONPath? I am not an expert in JSONPath so I apologize if this may seem trivial for others

Thanks all

jlucktay · Accepted Answer · 2024-05-18 07:30:47Z

3

I have found a solution:

$.data.list[?(@.username == "jblack")].id

This will return:

"id": 192

edited May 18, 2024 at 7:30

jlucktay

4422 gold badges8 silver badges25 bronze badges

answered Feb 14, 2020 at 15:36

masterful

511 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select a JSON attribute based on other elements within an array using JSONPath

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related