JSONPath: Get root array object using filter of child value

Question

Im trying to get JSONPath expression to filter my JSON and get whole sport object using value of child array.

I have following JSON:

[{

        "name": "Soccer",
        "regions": [{
                "name": "Australia",
                "leagues": [{
                        "name": "Australia league",
                        "inplay": 5,
                    }
                ]
            }
        ]
    }, {

        "name": "Tennis",
        "regions": [{
                "name": "Germany",
                "leagues": [{
                        "name": "Germany league",
                        "inplay": 0,
                    }
                ]
            }
        ]
    }
]

I need to get whole sport object where "inplay == 0" using JsonPath expression.

Result should look like that:

 {

    "name": "Tennis",
    "regions": [{
            "name": "Germany",
            "leagues": [{
                    "name": "Germany league",
                    "inplay": 0,
                }
            ]
        }
    ]
}

Regions and Leagues count can be > 1 Therefore $[?(@.regions[0].leagues[0].inplay == 0)] is not suitable

Tried $[?(@.regions[*].leagues[*].inplay == 0)] but it doesnt work

wp78de · Accepted Answer · 2021-08-26 01:12:19Z

1

Since this is not directly supported (as of now) in JayWay JSONPath we leverage contains as a workaround:

$[?(@.regions..inplay contains '0')]

Note: It may look like contains would work similar to a 'like' operator or instr function but this is not the case here. If the inplay value contains a 0, e.g. 10 it would not pull the record (according to my tests;)

answered Aug 26, 2021 at 1:12

wp78de

19.1k7 gold badges49 silver badges78 bronze badges

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

Comments

lucas-nguyen-17 · Accepted Answer · 2021-08-24 13:33:55Z

0

This works for me

$[?(@.regions[0].leagues[0].inplay == 0)]

answered Aug 24, 2021 at 13:33

lucas-nguyen-17

5,9272 gold badges11 silver badges24 bronze badges

2 Comments

Anton Nordhagen Over a year ago

Thanks for answer. But regions and leagues can be more than 1. Tried $[?(@.regions[*].leagues[*].inplay == 0)] but it doesnt work

lucas-nguyen-17 Over a year ago

Yes, deep scan or wild card cannot be used in expression. I think you need to find another way, I run out of idea right now.

Collectives™ on Stack Overflow

JSONPath: Get root array object using filter of child value

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related