Check JSONPath
With this plugin, JSONPath queries can be executed on JSON files.
Settings
(1) Test data: The data to which the JSONPath expression (2) is applied. Note: Please note that the data must not exceed 1 MB (file size if taken from file).
(2) JSONPath term: The JSONPath expression applied to (1). The JSONPath syntax is not discussed in detail here . However, you can find many examples on the internet.
(3) Execute query: Click this button to run the test.
(4) Test result: Output of the test.
Example file
{ "store": { "book": [ { "category": "reference", "author": "Nigel Rees", "title": "Sayings of the Century", "price": 8.95 }, { "category": "fiction", "author": "Herman Melville", "title": "Moby Dick", "isbn": "0-553-21311-3", "price": 8.99 }, { "category": "fiction", "author": "J.R.R. Tolkien", "title": "The Lord of the Rings", "isbn": "0-395-19395-8", "price": 22.99 } ], "bicycle": { "color": "red", "price": 19.95 } }, "expensive": 10 }