2022.1

l Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
l Sort on: Select a field on which to sort the data, in ascending (A-Z) or
descending (Z-A) order. Note that sorting is always textual. Even if the
selected column has numbers, it will be sorted as a text.
3. Click Finish to open the database.
After adding data from a database, the Data Model pane at the right hand bottom shows the
data fields that occur in the data.
The Value column displays data from the first record in the data file. Use the First, Previous,
Next and Last buttons to browse through the records.
Adding JSON sample data
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 JSON sample data to the Data Model:
1. Select File > Add Data > JSON sample data, from the menu. Alternatively, click the
JSON Sample Data toolbar button on the Data Model pane.
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.
Tip
If a data field contains JSON data you could use that data as sample data: right-
Page 844