PARSE_JSON
Description
Parses the specified string in JSON format and extracts a value according to the specified path
Syntax
PARSE_JSON (json, path)
Cannot be used in the condition of a FIND action.
Parameters
Attribute of the Plain Text type or string constant or calculation producing text identifying the string in JSON format to parse and the path in JSONPath format (see https://github.com/json-path/JsonPath#getting-started) identifying a value to be extracted from JSON. Returns extracted value as a string
Returns
Text: the value at the JSONPath, as a string.
Example
Customer.City = PARSE_JSON (Customer.Response, '$.address.city')
If Customer.Response holds {"address": {"city": "Sydney"}}, this sets City to Sydney.