JSON_PARSE
Parses escaped JSON text. If used in a formula field, it will return a JSON object; if used inside a text field it will return unescaped JSON text.
Categories: Data Parsing/Conversion
Syntax
JSON_PARSE(text)
Examples
Example 1
Input
1
{
2
"my_action": {
3
"json": "{\"payload\":{\"key\":\"value\",\"array_example\":[\"foo\",\"bar\"],\"object_example\":{\"key\":\"value\"}}}"
4
}
5
}
Formula
JSON_PARSE(my_action.json)
Output
1
{
2
"payload": {
3
"array_example": [
4
"foo",
5
"bar"
6
],
7
"key": "value",
8
"object_example": {
9
"key": "value"
10
}
11
}
12
}
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.