2022.1

Note
The information contained in all of the selected parent nodes will be copied for each
instance of that node. For example, if a client node contains multiple invoice nodes, the
information for the client node can be duplicated for each invoice.
The DataMapper only extracts elements for which at least one value or attribute value is
defined in the file.
JSON File Input Data settings
For a JSON file you can either use the object or array at the root and get one output record, or
select an object or array as parent element. Its direct child elements - objects and arrays, not
key-value pairs - can be output as individual records.
l Use root element: Selects the top-level array or object. There will only be one record.
l Use specific element: Select an array [] or object {} in the JSON data as Parent
element to define its child elements - objects and/or arrays - as source records. Any
elements outside the parent element and key-value pairs inside the parent will be
repeated in each source record.
Note
Only arrays and objects can be seen as a record. It is not possible to split the JSON
between key-value pairs.
Boundaries
Boundaries are the division between records: they define where one record ends and the next
record begins; for an explanation see "Record boundaries" on page252.
CSV, Excel or Database file boundaries
Since database data sources are structured the same way as CSV and Excel files, the options
for these file types are identical.
l Record limit: Defines how many records are displayed in the Data Viewer. This does not
affect output production; when generating output, this option is ignored. To disable the
Page 353