JSON Object Lookup

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 Path	Result
`$.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

Name	Type	Description
JSON Object	Object	The JSON input to lookup against
JSON Path	String	The path to use for the lookup

Outputs

Name	Type	Description
Result Value	Boolean	Whether a value was found in the provided path
Success	Object	Result of the JSON lookup