2019.2

Adding JSON data from a JSON file
JSON data can either be added to, or replace the Data Model in a template.
Importing JSON data into the Data Model makes it easier to test templates that are meant to be
merged with JSONdata in a Workflow configuration.
Tip
Workflow's OL Connect Create Content tasks can use JSON as their data source; see
Create Email Content, Create Print Content, and Create Web Content.)
To add data from a JSON file:
1.
Select File > Add Data > JSON sample data, from the menu. Alternatively, click the
JSON Sample Data toolbar button on the Data Model pane. This is only possible when
no data mapping configuration is open.
2. Either browse to the location of the file and select it, or paste or write the JSON directly in
the box below the file name.
You can add the following types of JSON data:
l
A JSON object or an array of JSON objects representing records. The data type
is derived from the data:
l Any value surrounded with quotes is converted to a field of type String.
l Any numeric value containing a period is converted to a field of type Float.
l Any numeric value that does not contain a period is converted to a field of type
Integer.
l A value "true" or "false" is converted to a field of type Boolean.
If a value in a record object is a JSON object, it is considered to be a nested table
with detail records.
l
Typed JSON. This JSON follows the structure of a JSON Record Data List (see the
REST API Cookbook). Field types are determined by the schema object in the
JSON.
3. Review the JSON; you may edit it if you like.
Page 799