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"
    }
  }
}
Was this helpful?