2022.1

JSON sample data dialog
The JSON sample data dialog lets you load JSON data into the Data Model (see "Loading
data" on page833).
By default, the JSON data is mapped to corresponding fields in the existing Data Model. Data
that does not correspond to any field is discarded.
You may use the Replace Data Model option to let the JSON data replace the existing Data
Model.
The dialog is opened via the menu: File > Add data > JSON sample data, or via the JSON
Sample Data toolbar button on the Data Model pane.
The options in this dialog are:
l File: The path and name of the JSON file to use. The file is assumed to be UTF-8
encoded.
l Browse: Opens an explorer window to browse folders and select a JSON file.
l The box below the file name allows to paste or enter JSON data. After opening a JSON
file the JSON data will appear in this box. You can review and edit the JSON.
For the types of JSON that are accepted, see below.
l Replace Data Model: Selecting the Replace Data Model option removes the existing
Data Model from the template and creates a new Data Model based on the keys found in
the JSON. When this option is not checked, the JSON data is mapped to any
corresponding fields in the existing Data Model, and data that does not correspond to any
field is discarded.
Note
If a data mapping configuration is open at the same time, the loaded JSON will
always replace the Data Model and no values will be imported.
l Finish: If the JSON is valid, you may click Finish to import the data into the Data Model
pane. Arrays of objects are converted to records (or detail tables); key-value pairs are
converted to data fields.
Page 1032