The input expression provides the JSON data to be operated upon. Typically, this will be a simple expression pointing at an incoming attribute, such as, the body from a HTTP Node.

In PhixFlow version 11.1 onwards, this field is mandatory.

// Consists of the name of the connector and mapped attribute

in.body

Defines the parsing of the JSON. Disabled is lenient and enabled is strict.

Lenient parsing relaxes validation allowing the following to be present in the JSON data:

• Use of single quotes, for example: {'name': 'Some “quotes” in a string'}
• Unquoted field names, for example:  {name: “value”}
• Unescaped control characters, including literal new lines to appear within a string.
• Allow trailing commas {“name”: ”value”,}

// Leaving the default option

The JSON Path expression is evaluated against the data provided by the Input Expression and returns a list of JSON elements. It determines which elements are extracted from the JSON.

The path starts at the root element represented by $ and each element in the path is separated by a full stop. The ^ traverses up a node and a . traverses down the node.

Note that the path determines the number of nodes that are processed, which directly correlates to the number of records returned by the JSON action. For example, if the path returns the root element of the JSON, only one record will be returned. Whereas a path that returns children nodes will return one record for each child element.

$