Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > File Gateway > Importing Data > New Table

JSON JavaScript Object Notation

Scroll Prev Top Next More

When importing JSON data into a new table, you will be presented with the following dialog to configure the available options:

 

Import_New_JSON

 

 

You can alter the field name, data type, and size by selecting the field from the list of Available Fields, typing in the new Field Name in the space provided, selecting the data type from the Field Type drop-down list, typing in the desired size in the Field Size box, and pressing the Apply Field Changes button. You can also choose which fields are imported by checking or un-checking the box next to the field name.

 

NOTE: You will need to follow the aforementioned steps for each field that you wish to configure.

 

ð First Row

Specifies the position of the first row of data

 

NOTE: When using source files that have column headers or other information as a preface to the data, you will need to adjust this position to correspond with the row position of the first row of data to import

 

If an unexpected format is detected, an "JSON To Data Packet" utility will be displayed. The valid node must be selected which contains the collection of rows.

 

Import_JSON_DataPacket