Test JSON Redaction via JSONPath

Expand quick JSONPath cheat sheet  
ExpressionMeaning
$.store.*All direct properties of store (not recursive).
$.store.bicycle.colorThe color of the bicycle in the store.
Result: red
$.store..price
$..price
The prices of all items in the store.
Result: [8.95, 8.99, 22.99, 19.95]
$.store.book[*]
$..book[*]
All books in the store.
$..book[*].titleThe titles of all books in the store.
Result:
[Sayings of the Century,
Moby Dick,
The Lord of the Rings]
$..book[0]The first book.
Result:
[{ "category":"reference", "author":"Nigel Rees", "title":"Sayings of the Century", "price":8.95 } ]
$..book[0].titleThe title of the first book.
Result: Sayings of the Century
$..book[0,1].title
$..book[:2].title
The titles of the first two books.
Result: [Sayings of the Century, Moby Dick]
$..book[-1:].title
$..book[(@.length-1)].title
The title of the last book.
Result: [The Lord of the Rings]
The result is a list, because [-n:] always returns lists.
$..book[?(@.author=='J.R.R. Tolkien')].titleThe titles of all books by J.R.R. Tolkien (exact match, case-sensitive).
Result: [The Lord of the Rings]
The result is a list, because filters always return lists.
$..book[?(@.isbn)]All books that have the isbn property.
$..book[?([email protected])]All books without the isbn property.
$..book[?(@.price < 10)]All books cheaper than 10.
$..book[?(@.price > $.expensive)]All expensive books.
$..book[?(@.author =~ /.*Tolkien/i)]All books whose author name ends with Tolkien (case-insensitive).
$..*All members of the JSON structure beneath the root (child objects, individual property values, array items), combined into an array.

Enter your JSON content here:
Enter your JSONPath Expressions here (1 per line):