could not fetch json object using jsonpath

Question

I've a requirement to fetch value from json using jayway jsonpath.

Json structure looks like below

[
  {
    "type": "a",
    "values": [
      {
        "name": "a",
        "value": [1,2,3]
      },
      {
        "name": "b",
        "value": [3,4,5]
      },
      {
        "name": "c",
        "value": [6,7,8]
      }
    ]
  }
]

my requirement is in the values array if the name value is a and value array contains value 1, then I need to fetch value array where name is b.

I have written jsonPath expression like below

$..values[?(@.name == 'a')]

where it is returning only

{
  "name": "a",
  "value": [1,2,3]
}

could someone help me in writing jsonpath expression please , Thanks in advance.

expected output

[3,4,5]

tried with

$..[?(@.values[?(@.name== 'a' && @.value CONTAINS 1)])]

then it is matching every object present in root array.

JSON Path isn't going to do this for you because it doesn't have conditionals that operate iteratively. You need a programmed solution. — gregsdennis
– gregsdennis, Commented Jan 3, 2022 at 11:07

Akshay G · Accepted Answer · 2022-01-03 11:14:55Z

1

With Jayway JSONPATH you might get lucky with below jsonpath

$..[?(@.values[?(@.name=='a')].value[*] contains 1 )].values[?(@.name=='b')].value[*]

answered Jan 3, 2022 at 11:14

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

could not fetch json object 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