2022.1

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.
Examples
A single record with two fields
{
"first": "Peter",
"last": "Parker"
}
Two records
[{
"first": "Peter",
"last": "Parker"
},
{"first": "Martin",
"last": "Moore"
}]
Page 1033