Versions Compared

Version Old Version 32 New Version Current
Changes made by

Zoe Baldwin

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue


Excerpt
nameWholePage

JSON Action Properties

Use a 

Insert excerpt
_action_json
_action_json
nopaneltrue
 action to process JSON data, and convert it into specific data objects that can be used by PhixFlow for processing. The JSON Node extracts one or more records from the provided JSON object using the JSON path specified.

Worked Example

For full details on how to create JSON actions, including worked examples, see JSON Action Configuration.

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Basic Settings

Expect literal values or expressions encapsulated within ${} syntax, for example ${in.MyValue}. A worked example of the JSON Node is provided at the end of this page.

FieldDescriptionExample Value
NameName given to the JSON Node. This will be displayed on the actionflow canvas.MyJSONReader
Input Expression

This field is mandatory.

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.

// Consists of the pipe name and the name of a mapped attribute

in.body

Use Strict JSON parsing

Defines the parsing of the JSON, disabled will be lenient and enabled will be 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

Disabled.

Path

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 Node. For example, if the path returns the route 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

// JSON Path

$.main_page.title


Excerpt
nameJSONPathSyntax

Path Syntax

Expression Description

$ 

symbol refers to the root element.
@symbol refers to the current element.
. is the dot-child operator, which is used to denote a child element of the current element.
[ ] is used to select a child element of the current element (by name or index number).
*a wildcard, returning all elements regardless of their name.
^symbol is used to traverse up 1 element in the JSON hierarchy from child to parent. 


Input Connection Points

Can Accept a single

Insert excerpt
_driving_input_connection_point
_driving_input_connection_point
nopaneltrue
.

The grid contains a list of all input connection points and their type.

  • To add a new input connection point, in the section toolbar click 
    Insert excerpt
    _add
    _add
    nopaneltrue
     to open a new input connection point and set its properties; see Input Connection Points.
  • To edit an existing input connection point, double-click it in the list to open its properties.
  • To remove an input connection point, select one and in the section toolbar click 
    Insert excerpt
    _delete
    _delete
    nopaneltrue
    .

Output Connection Points

The grid contains a list of all output connection points.

  • To add a new output path, in the section toolbar click 
    Insert excerpt
    _add
    _add
    nopaneltrue
     to open a new output path and set the expression; see Output Connection Points.
  • To edit an existing output path, double-click it in the list to open its properties.
  • To remove an output path, select one and in the section toolbar click 
    Insert excerpt
    _delete
    _delete
    nopaneltrue
    . 

Output Attributes

Excerpt
nameOutputAttributes

JSON is converted

into data

into data objects that can be used by PhixFlow

, this information is accessed using the syntax,

. Elements returned by the Input Expression are available in this expression as: _result.

AttributeName.

elementName

In PhixFlow12.1+, you can reference the values of previously calculated output attributes by using the syntax, _out.attributeName, for example if you have a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
action connected to a 
Insert excerpt
_action_json
_action_json
nopaneltrue
action, the Output Attributes in the calculate action can be referenced.

Advanced

FieldDescription

Prioritise Throughput Over Ordering

Insert excerpt
Actionflow Properties
Actionflow Properties
namePrioritiseThroughputOverOrdering
nopaneltrue


Further Reading