How to extract nested elements in JSON response using JSON extractor

Question

I need to extract an element based on a condition inside a nested JSON response.

{
   "cabin":"eco",
   "seatNumber":"15A",
   "travelers":[
      {
         "id":"7789",
         "seatCharacteristicsCodes":[
            "CH",
            "W"
         ],
         "seatAvailabilityStatus":"available",
         "prices":[
            {
               "base":40,
               "total":40,
               "currencyCode":"AED",
               "totalTaxes":0
            }
         ]
      }
   ],
   "coordinates":{
      "x":1,
      "y":0
   }
}

I need to check the "seatAvailabilityStatus" as "available" or not (which is inside "travelers"), if it is available, I need to get the "seatNumber" and proceed with the flow.

I have seen some example and tried like the below, but I am able to capture only the values which are associated to "travelers" like "id" or "prices":

$.travelers[?(@.seatAvailabilityStatus=="available")].id

But in my case, if the seatAvailabilityStatus is available I need to get the "seatNumber". Can anyone help?

Screen shot of the JSON I included

Venkatesan Arjunan · Accepted Answer · 2022-08-04 06:41:55Z

1

You could try this way:

$..[?(@.travelers[?(@.seatAvailabilityStatus =='available')] empty false)].seatNumber

answered Aug 4, 2022 at 6:41

Venkatesan Arjunan

421 gold badge1 silver badge4 bronze badges

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

Comments

Dmitri T · Accepted Answer · 2022-08-04 07:36:35Z

0

You need to get 1 level up because JsonPath doesn't know anything about parents of the matched attribute

Suggested query:

$..[?(@.travelers[?(@.seatAvailabilityStatus =='available')])].seatNumber

Demo:

More information: How to Use the JSON Extractor For Testing

answered Aug 4, 2022 at 7:36

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

1 Comment

Akshay G Over a year ago

with this query even if the seatAvailabilityStatus in unavailable it will still output the same result. as mentioned by @Venkatesan you also need to compare the inner most filtered object with empty false

Collectives™ on Stack Overflow

How to extract nested elements in JSON response using JSON extractor

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related