Documentation

JSON Object Lookup

Lookup and extract data from a JSON value using a path

You can use this action to navigate and extract values from an input of type [JSON] (https://www.json.org/json-en.html).

The action is a wrapper of jsonpath-plus. You can check out the whole supported syntax here through examples.

Some examples:

{
  "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
    }
  }
}
JSON PathResult
$.store.bicycle.color"red"
$.store.book[*].author[ "Nigel Rees", "Herman Melville", "J. R. R. Tolkien" ]
$.store.book[0].author"Nigel Rees"
$.store..price[ 8.95, 8.99, 22.99, 19.95 ]
$..book[-1:]{ "category": "fiction", "author": "J. R. R. Tolkien", "title": "The Lord of the Rings", "isbn": "0-395-19395-8", "price": 22.99 }
$.store.book[-1:][category,author][ "fiction", "J. R. R. Tolkien" ]

Inputs

NameTypeDescription
JSON ObjectObjectThe JSON input to lookup against
JSON PathStringThe path to use for the lookup

Outputs

NameTypeDescription
Result ValueBooleanWhether a value was found in the provided path
SuccessObjectResult of the JSON lookup