Plain JSON
A plain JSON follows the industry standard JSON format (as
specified in https://www.json.org) and has
one of the following structures depending on the actual export/import
scenario.
A plain JSON can only contain elements of the following 4 data
types: integer, string, boolean, and null.
One-level structure
A one-level plain JSON string must have only one level (cannot
be two or more) and must be an object (cannot be an array).
This format is supported by the following methods (For all
formats supported by a particular method, see Applicable methods):
|
Object |
Method |
|---|---|
| DataWindow | ImportRowFromJSON, ExportRowAsJson |
| RESTClient | RetrieveOne |
Here is an example of a one-level plain JSON string:
|
1 |
{ "column1":1, "column2":"name", "column3":true, "column4":null... } |
Two-level structure
A two-level plain JSON must have its top-level as an array and
the second-level as object(s) which represent a row of data.
|
1 |
[ SIMPLE-ROW1, SIMPLE-ROW2, SIMPLE-ROW3, SIMPLE-ROW4, SIMPLE-ROW5... ] |
This format is supported by the following methods (For all
formats supported by a particular method, see Applicable methods):
|
Object |
Method |
|---|---|
| DataWindow | ImportJson, ImportJsonByKey, ExportJson |
| JSONPackage | GetValueToDataWindow, SetValueByDataWindow |
| RESTClient | Retrieve, RetrieveOne, Submit |
Here is an example of a two-level plain JSON string:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[{"emp_id":1,"emp_fname":"Fran","emp_lname":"Whitney", & "street":"9 East Washington Street","city":"Cornwall"}, & {"emp_id":2,"emp_fname":"Matthew","emp_lname":"Cobb", & "street":"7 Pleasant Street","city":"Grimsby"}, & {"emp_id":3,"emp_fname":"Philip","emp_lname":"Chin", & "street":"539 Pond Street","city":"Oakville"}, & {"emp_id":4,"emp_fname":"Julie","emp_lname":"Jordan", & "street":"1244 Great Plain Avenue","city":"Woodbridge"}, & {"emp_id":5,"emp_fname":"Robert","emp_lname":"Breault", & "street":"358 Cherry Street","city":"Milton"}, & {"emp_id":6,"emp_fname":"Melissa","emp_lname":"Espinoza", & "street":"1121 Apple Tree Way","city":"Iroquois Falls"}, & {"emp_id":7,"emp_fname":"Jeannette","emp_lname":"Bertrand", & "street":"2090A Concord Street","city":"Waterloo"}, & {"emp_id":8,"emp_fname":"Marc","emp_lname":"Dill", & "street":"897 Hancock Street","city":"Milton"}, & {"emp_id":9,"emp_fname":"Jane","emp_lname":"Francis", & "street":"127 Hawthorne Drive","city":"Scarborough"}, & {"emp_id":10,"emp_fname":"Natasha","emp_lname":"Shishov", & "street":"151 Milk Street","city":"Grimsby"}, & {"emp_id":11,"emp_fname":"Kurt","emp_lname":"Driscoll", & "street":"1546 School Street","city":"Grimsby"}, & {"emp_id":12,"emp_fname":"Rodrigo","emp_lname":"Guevara", & "street":"72 East Main Street","city":"Fort Henry"}] |