JsonPath to JSON is what XPATH is to XML, a simple way to extract parts of a given document. JsonPath is available in many programming languages such as Javascript, Python and PHP. Now also in Java!
Given:
{ "store": {
"book": [
{ "category": "reference",
"author": "Nigel Rees",
"title": "Sayings of the Century",
"price": 8.95
},
{ "category": "fiction",
"author": "Evelyn Waugh",
"title": "Sword of Honour",
"price": 12.99,
"isbn": "0-553-21311-3"
}
],
"bicycle": {
"color": "red",
"price": 19.95
}
}
}
Read
All authors:
List authors = JsonPath.read(json, "$.store.book[*].author");
Author of first book in store:
String author = JsonPath.read(json, "$.store.book[1].author");
All books with category = "reference"
List books = JsonPath.read(json, "$.store.book[?(@.category == 'reference')]");
List books = JsonPath.read(json, "$.store.book[?]", filter(where("category").is("reference")));
All books that cost more than 10 USD
List books = JsonPath.read(json, "$.store.book[?(@.price > 10)]");
List books = JsonPath.read(json, "$.store.book[?]", filter(where("price").gt(10)));
All books that have isbn
List books = JsonPath.read(json, "$.store.book[?(@.isbn)]");
List books = JsonPath.read(json, "$.store.book[?]", filter(where("isbn").exists(true)));
Chained filters
Filter filter = Filter.filter(Criteria.where("isbn").exists(true).and("category").in("fiction", "reference"))
List books = JsonPath.read(json, "$.store.book[?]", filter);
Custom filters
Filter myFilter = new Filter.FilterAdapter>(){
@Override
public boolean accept(Map map) {
return map.containsKey("isbn");
}
};
List books = JsonPath.read(json, "$.store.book[?]", myFilter);
All prices in the document
List prices = JsonPath.read(json, "$..price");
Compiled path
You can pre compile a path and use it multiple times
JsonPath path = JsonPath.compile("$.store.book[*]");
List books = path.read(json);
Assert
Asserts are made with Hamcrest matchers
JsonAssert.with(json).assertThat("$.store.bicycle.color", Matchers.equalTo("red"))
.assertThat("$.store.bicycle.price", Matchers.equalTo(19.95D));
Add some static imports and you get this
with(json).assertThat("$.store.bicycle.color", equalTo("red"))
.assertThat("$.store.bicycle.price", equalTo(19.95D));
The Hamcrest library contains a lot of different matchers and they can often be nested.
with(json).assertThat("$..author", hasItems("Nigel Rees", "Evelyn Waugh"))
.assertThat("$..author", is(collectionWithSize(equalTo(2))));
with(json).assertThat("$.store.book[?(@.category == 'x')]", emptyCollection());
If you don't find the matcher you need, roll your own.
Download
Json-path is available at Maven Central,add below dependency into pom.xml :