Jsonpath: get the value of an element based on its sibling, when the sibiling element is an array containing a specific value

Question

With the following json:

{
  "elements": [
    {
      "ids": [
        {
          "id": "A"
        },
        {
          "id": "B"
        }
      ],
      "value": "one"
    },
    {
      "ids": [
        {
          "id": "C"
        },
        {
          "id": "D"
        }
      ],
      "value": "two"
    }
  ]
}

What would be the jsonpath to return the value one when asking for the id A?

As per https://stackoverflow.com/a/47576707 I can retrieve the ids element containing A:

$.elements.*.ids[?(@.id=='A')] or $..ids[?(@.id=='A')]

with result:

[
   {
      "id" : "A"
   }
]

but I would like to access the value of its sibling ("value": "one").

Thanks in advance!

score 1 · Answer 1 · answered Nov 23 '21 at 18:02

1

jsonpath:

$.elements[?(@.ids.*.id contains 'A')].value

result:

[
   "one"
]

answered Nov 23 '21 at 18:02

j.xavier.atero

506
2
10
25

score 1 · Accepted Answer · answered Nov 24 '21 at 06:19

1

You can also use the in filter operator.

$.elements[?('A' in @.ids.*.id)].value

answered Nov 24 '21 at 06:19

Akshay G

2,070
1
15
33

Jsonpath: get the value of an element based on its sibling, when the sibiling element is an array containing a specific value

2 Answers2