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 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 |
Updated 10 months ago