JsonPath AND Operator on Array

jsonpath
Mike Chinaloy picture Mike Chinaloy · Apr 17, 2015 · Viewed 24.4k times · Source

I have an array in JSON and I would like to apply two filters to it like so:

$._embedded.values[0]._embedded.data[?(@.var1='value1' && @.var2='value2')]

I need to select only those elements from the array that satisfies the AND operation. However, in practice this doesn't appear to work.

Is it possible to do this or must I perform a two step action to extract one set then filter again to get my final results?

Answer

kalle picture kalle · Apr 20, 2015

The Jayway implementation supports inlined AND and OR criteria. 

$..book[?(@.price==8.99 && @.category=='fiction')]  

[
   {
      "category" : "fiction",
      "author" : "Herman Melville",
      "title" : "Moby Dick",
      "isbn" : "0-553-21311-3",
      "price" : 8.99
   }
]

Try it out and compare different implementations here http://jsonpath.herokuapp.com/

Related questions

How to filter by string in JSONPath?

I have a JSON response from the Facebook API that looks like this: { "data": [ { "name": "Barack Obama", "category": "Politician", "id": "6815841748" }, { "name": "Barack Obama's Dead Fly", "category": "Public figure", "id": "92943557739" }] } I want to apply JSONPath to it to only return results …

Read More
Basic use of JSONPath in Java

I have JSON as a string and a JSONPath as a string. I'd like to query the JSON with the JSON path, getting the resulting JSON as a string. I gather that Jayway's json-path is the standard. The online API, …

Read More
count members with jsonpath?

Is it possible to count the number of members using JsonPath? Using spring mvc test I'm testing a controller that generates {"foo": "oof", "bar": "rab"} with standaloneSetup(new FooController(fooService)).build() .perform(get("/something").accept(MediaType.APPLICATION_JSON)).andExpect(status().…

Read More