Provide the ability to generate JSON output from process data.
The node will allow for authoring a JSON styled template, and will map the output based on field names written into the template.
Example Template:
{ "Vendor":@@Vendor Name@@,@@PO Field Descriptor@@:@@PO Number@@, "Amount":##Invoice Amount##,"Invoice Date":@@Document Date@@, "Approvers":[ @@MV Approver List@@ ], "Invoice Lines":[@@Line Items[0,1,3,4]@@] }
Use two @ symbols to represent a JSON string. Use two # symbols to represent a JSON number. Strings are wrapped in quotes. Numbers of left alone. This formatting applies to all field types.
Multi-value fields are written in their entirety in a comma delimited form. In the example above, @@MV Approver List@@ would be represented like:
“Steve”, “Brian”, “Dan”
This results in a valid JSON structure when injected into the JSON as defined:
"Approvers":[ "Steve","Brian","Dan" ]
Table fields are written in their entirety (all rows) for the table columns specified. All Table Field columns are written as strings. In the example above, @@Line Items[0,1,3,4]@@ will output an object for each row:
{“GL Code”:”100-299300-01”, “Quantity”:”20”,”Amount”:”124.67”}
This results in a valid JSON structure when injected into the JSON as defined:
"Invoice Lines":[ {“GL Code”:”100-299300-01”, “Quantity”:”20”,”Amount”:”124.67”}, {“GL Code”:”100-726352-01”, “Quantity”:”1”,”Amount”:”88.98”} {“GL Code”:”100-763521-01”, “Quantity”:”23”,”Amount”:”12.95”} ]