Filtering JSON using JSONPath

Question

I'm using a JSON like this one

[
    [{
        "tool": "one",
        "products": [
            "Prod1",
            "Prod2",
            "Prod3",
            "Prod4",
            "Prod5",
            "Prod6"
        ],
        "count": 6
    }],
    [{
        "tool": "two",
        "products": [
            "Prod1",
            "Prod7",
            "Prod3",
            "Prod8",
            "Prod5",
            "Prod9"
        ],
        "count": 6
    }],
    {
        "tool": "three",
        "products": [
            "Prod10",
            "Prod70",
            "Prod30"
        ],
        "count": 3
    }
]

and I'd like to extract all the Prod* that are about the tool "one" so the list

"Prod1",
"Prod2",
"Prod3",
"Prod4",
"Prod5",
"Prod6"

and then the same about the tools "two" and "three".

I'm in troubles with the right filter to use to obtain the result.

Any suggestion will be appreciated and thank you in advance

Akshay G · Accepted Answer · 2022-07-28 06:56:34Z

1

$..[?(@.tool=="one")] should filter the node that you are interested. you can then access the products list using

$..[?(@.tool=="one")].products.*

Use https://jsonpathfinder.com/ to find the exact output path and then use https://jsonpath.com/ to try different jsonpath-expressions

edited Jul 28, 2022 at 6:56

answered Jul 28, 2022 at 6:50

Akshay G

2,3601 gold badge19 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Filtering JSON 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