2021.2

l Table name: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
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.
JSON file options
After selecting a JSON file, specify if and how the JSON file must be split into multiple records.
This is done by selecting an object or array as parent element. Its direct child elements -
objects and arrays, not key-value pairs - can be seen as individual source records. If the root is
selected, there will be only one source record.
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803.
XML file options
Select what level of XML elements defines a record.
Page 797