JSONPATH

Evaluates objects using JSONPath expressions. JSONPath expressions support wildcards, filters, and slices. See JSONPath or the Online Evaluator for more information. More examples of how to use JSONPATH can be seen in our Story Library

Syntax 

JSONPATH(object, path)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"json": "{\"phoneNumbers\": [{\"name\": \"John\", \"type\": \"iPhone\", \"country\": \"Australia\"}, {\"name\": \"Joe\", \"type\": \"Android\", \"country\": \"Australia\"}, {\"name\": \"Jess\", \"type\": \"home\", \"country\": \"Ireland\"}]}"
4
}
5
}

Formula

JSONPATH(my_action, "$.phoneNumbers[*].type")

Output

"[\"iPhone\",\"Android\",\"home\"]"

Sample Actions 

Transform
My Action
Transform
JSONPATH
Transform
JSONPATH
Transform
JSONPATH

Select an action to inspect

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?