2019.1

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.
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.
Note
The JSON Sample Data is not stored with the template. In order to reuse the data you should create
a JSON file on disk and load it via the File option in this dialog.
Types of JSON data
You can add the following types of JSON data:
l
A JSON object or an array of JSON objects representing records. The data type is
derived from the data:
l Any value surrounded with quotes is converted to a field of type String.
l Any numeric value containing a period is converted to a field of type Float.
l Any numeric value that does not contain a period is converted to a field of type
Integer.
l A value "true" or "false" is converted to a field of type Boolean.
If a value in a record object is a JSON object, it is considered to be a nested table with
detail records.
l
Typed JSON. This JSON follows the structure of a JSON Record Data List (see the
REST API Cookbook). Field types are determined by the schema object in the JSON.
Page 886