JSON Functions provide a way to convert string json to list and objects.
Parse JSON To List
Assuming the input string is a valid JSON, this function converts the string to a list of records that can be looped upon.
Configuration:
Provide the input field or token that contains the string json.
Example:
The input string, `[{"name":"sfdcid", "value":"003PX000007wWl4YAE"}]", will be returned as list containing an object.
Parse JSON To Object
Assuming the input string is a valid JSON, this function converts the string to a an object containing key/value pairs.
Configuration:
Provide the input field or token that contains the string json.
Example:
The input string, `{"name":"sfdcid", "value":"003PX000007wWl4YAE"}", will be returned as an object.