JSONPath : How to filter nested array?

Question

I have a json like below:

[
    {
        "skuId": "1234",
        "plans": [
            {
                "plan": {
                    "planName": "plan1",
                    "planId": "abcd1231",
                }
            },
            {
                "plan": {
                    "planName": "plan2",
                    "planId": "loks3123",
                }
            }
        ]
    },
    {
        "skuId": "5341",
        "plans": [
            {
                "plan": {
                    "planName": "plan3",
                    "planId": "awer3234",
                }
            },
            {
                "plan": {
                    "planName": "plan4",
                    "planId": "gefd4231",
                }
            }
        ]
    },
    {
        "skuId": "7649",
        "plans": [
            {
                "plan": {
                    "planName": "plan5",
                    "planId": "kitv5397",
                }
            }
        ]
    }
]

Now i have a planId "loks3123", and i want to get the skuId where it belongs to. In this case planId "loks3123" belongs to skuId "1234". Is it possible using JsonPath to do that? If so, How to do that using JsonPath? If not, what should i do? Thanks！

Also I found this: github.com/json-path/JsonPath/issues/287

Jerry Jeremiah
– Jerry Jeremiah

2022-06-23 04:57:08 +00:00
Commented Jun 23, 2022 at 4:57 — Jerry Jeremiah
– Jerry Jeremiah, Commented Jun 23, 2022 at 4:57

Jerry Jeremiah · Accepted Answer · 2022-06-23 05:26:38Z

5

You need to find a node containing a plans attribute that contains a planId attribute that matches your text. Using the suggestion at the end of https://github.com/json-path/JsonPath/issues/287 you can get what you want with:

$..[?(@.plans[?(@.plan.planId == 'abcd1231')] empty false)].skuId

answered Jun 23, 2022 at 5:26

Jerry Jeremiah

9,6933 gold badges27 silver badges37 bronze badges

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

Comments

Akshay G · Accepted Answer · 2022-06-24 08:21:36Z

3

If you are using Jayway JsonPath you can use filter operator in

$..[?('loks3123' in @.plans[*].plan.planId)].skuId

Try here : https://jsonpath.herokuapp.com/

If you are using Newtonsoft.json

$..[?(@.plans[*].plan.planId == 'loks3123')].skuId

Try here : https://dotnetfiddle.net/6n4vAd

edited Jun 24, 2022 at 8:21

answered Jun 23, 2022 at 7:32

Akshay G

2,3601 gold badge19 silver badges35 bronze badges

5 Comments

peter Char Over a year ago

I'm using Newtonsoft.json, so this seems not work.

Akshay G Over a year ago

@peterChar if you are using newtonsoft the marked answer shouldn't work either.

Akshay G Over a year ago

@peterChar Check the fiddle using newtonsoft.json

Jerry Jeremiah Over a year ago

I do use Jayway JSONPath and your answer seems so much easier to understand than mine. I learned something today. Thanks very much!

peter Char Over a year ago

@Akshay G That works, Thank you! And sorry for my lately accept.

Prakash Niraula · Accepted Answer · 2022-06-23 06:00:32Z

0

Here is a simple implementation for your problem using javascript and in the solution 'data' is your json data

    let findstring="loks3123";
    for(var i=0;i<data.length;i++){
        let sku=data[i];
        for(var j=0;j<sku.plans.length;j++){
            let plans=sku.plans[j];
            if(plans.plan.planId==findstring){
                console.log("skuId:"+sku.skuId);
            }
        }
    }

edited Jun 23, 2022 at 6:00

answered Jun 23, 2022 at 4:15

Prakash Niraula

564 bronze badges

Collectives™ on Stack Overflow

JSONPath : How to filter nested array?

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related