2019.1

l
When the OL Connect "Retrieve Items" on page624 task is set to output Records in
JSON, it outputs a JSON Record Data List (see "Types of JSON in Workflow" below).
l The OL Connect Send "Get Data" on page566 task can output its results to a JSON file.
In scripts written in any JSON-aware language (including JavaScript), JSON is obviously
supported.
Certain methods in the "Data Repository API" on page165 accept or return JSON data.
Types of JSON in Workflow
Workflow tasks that support JSON accept or output one or two of the following types of JSON:
l
a regular JSON string, containing a JSON object or an array of JSON objects
representing records. If a value in a record object is a string, it is considered to be a field
value. If a value in a record object is a JSON object, it is considered to be a nested table
with detail records. For examples, see "JSON string samples" on page601.
l
a JSON Record Data List (see the REST API Cookbook). A JSON Record Data List is a
proprietary JSON object type. It includes a schema entry with information about the types
of all fields at the beginning of the record, and the data set with values after the schema.
This structure allows for easy handling of REST API return values through scripting in
Workflow or in the Designer; see "JSON Record Data List example" on page87.
JSON string examples
The following JSON string samples show various techniques to incorporate data in a JSON
string.
A simple JSON structure holding the first and last name of a person:
{
"first": "Peter",
"last": "Parker"
}
A JSON string with references to local variables and a Job Info variable (see "About
variables" on page655):
{
"first":"%{first}",
"last":"%{last}",
Page 85