2020.2

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; key-value pairs are converted to data
fields. If a value in a record object is a JSON object, it is ignored.
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
Examples
A single record with two fields
{
"first": "Peter",
"last": "Parker"
}
Two records
[{
"first": "Peter",
"last": "Parker"
},
{"first": "Martin",
"last": "Moore"
}]
A single record with a detail table
{
"name":"Peter Parker",
"email":"parkerp@localhostcom",
"detail": [{"id":"inv123","ExtraData":"hello"},
{"id":"456","ExtraData":"world"}]
}
Page 479