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
 }