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.

Syntax 

JSON_PARSE(text)

Usage 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 

Event Transform
My Action
Event Transform
JSON_PARSE

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?