JSONPATH
Evaluates objects using JSONPath expressions. Supports escaped and non-escaped JSON. JSONPath expressions support wildcards, filters, and slices. See JSONPath or the Online Evaluator for more information. Please note: Tines uses JSONPath version 0.9.9, which may not support all features available in modern online JSONPath evaluators. More examples of how to use JSONPATH can be seen in our Story Library
Categories: Objects
Syntax
JSONPATH(object, path)
Examples
Example 1
Input
1
{
2
"my_action": {
3
"json": {
4
"phoneNumbers": [
5
{
6
"name": "John",
7
"type": "iPhone",
8
"country": "Australia"
9
},
10
{
11
"name": "Joe",
12
"type": "Android",
13
"country": "Australia"
14
},
15
{
16
"name": "Jess",
17
"type": "home",
18
"country": "Ireland"
19
}
20
]
21
}
22
}
23
}
Formula
JSONPATH(my_action.json, "$.phoneNumbers[*].type")
Output
1
[
2
"iPhone",
3
"Android",
4
"home"
5
]
Sample actions
Select an action to inspect
You can also click "Copy actions" and paste them in your Tines story to see how they work.