JSON_PARSE

Parses escaped JSON text. If used in conjunction with Single Value Mode, it will return a JSON object, otherwise it will return unescaped JSON text.

Syntax 

JSON_PARSE(text)

Examples 

Example 1

Input

{
  "my_action": {
    "json": "{\"payload\":{\"key\":\"value\",\"array_example\":[\"foo\",\"bar\"],\"object_example\":{\"key\":\"value\"}}}"
  }
}

Formula

JSON_PARSE(my_action.json)

Output

{"payload":{"key":"value","array_example":["foo","bar"],"object_example":{"key":"value"}}}