Handling conditional JsonPath in nested JSONArray

Question

I'm trying to return the value of 'id', where value is "India" in nested JSON as shown below

{
  "iterations": [
    {
      "id": "122",
      "parameters": [
        {
          "name": "Country",
          "value": "US"
        }
      ]
    },
    {
      "id": "123",
      "parameters": [
        {
          "name": "Country",
          "value": "India"
        }
      ]
    }
  ]
}

I have already referenced similar question question asked JsonPath Conditionals Nested Two Arrays Deep

I tried

$.iterations[?(@.parameters[?(@.value=='India')])].id

$.iterations[?(@..[?(@.value == 'India')])].id

Every time the expression is returning all 2 parameter items. Any help would be much appreciated.

jei · Accepted Answer · 2025-07-29 13:34:58Z

-1

Can you try:

$.iterations[?(@.parameters[?(@.name == 'Country' && @.value == 'India')])].id

?

Inside this inner filter, @ refers to the current parameter object. This condition checks if the name property is "Country" AND the value property is "India" for that specific parameter object.

The outer filter [?(@.parameters[?(@.name == 'Country' && @.value == 'India')]) will evaluate to true for an iteration only if its parameters array contains at least one object that satisfies the inner condition (name == 'Country' && value == 'India')

answered Jul 29 at 13:34

jei

3641 gold badge2 silver badges12 bronze badges

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

2 Comments

IrshadAli Jul 29 at 14:11

I did try that, the result remains same [ "122", "123" ] I'm using https://jsonpath.fly.dev/ to validate the jayway jsonpath result.

jei Jul 29 at 15:00

Yes, me too. I was using jsonpath.com The two sites gives different results. Depends on the actual implementation, I suppose.

Collectives™ on Stack Overflow

Handling conditional JsonPath in nested JSONArray

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related