2022.1

Whether source records are output as individual records depends on the trigger. Either:
l Select On element to create a new record in the output for each object or array in the
parent element.
l Select On change to create a new record each time the value in a certain key-value pair
changes. Only key-value pairs that exist at the root of a child element can be evaluated.
All data found in child elements of the selected parent element are extracted to fields at the root
of the Data Model. If a value consists of an object or array, the entire object or array is extracted
to one data field.
Field names are derived from keys, objects and arrays in the first record, but those aren't
necessarily the same in a subsequent record. If following records have a different structure, for
example if a record has more child elements compared to the first record, some data may not
get extracted.
Tip
JSON data can also be imported directly into the Data Model; see "Adding JSON sample
data" on page345.
XML file options
Select what level of XML elements defines a record.
The Trigger is what triggers the creation of a new record. It can be set to:
l On element: This defines a new record when a new element occurs on the selected XML
level.
l On change: This defines a new record when a specific field under the chosen XML level
has a new value. After selecting this option, you have to select the field that triggers the
creation of a new record.
Adding data from a database
1. Click File, select Add Data and then click From database data source. Browse to the
location of the file and select it.
The Designer can open databases from the following types of data sources:
Page 340