JSON Layout

JSON (JavaScript Object Notation) is a lightweight data-interchange format. The JSON layout defines the procedure to read data from and write data to a JSON file. 

Steps to create a JSON Layout

1. Click Configure > LAYOUTS > JSON.
2. Click CREATE JSON Layout.
3. On the Create Layout screen, type the name and description of the new JSON layout in the Name and Description fields respectively.
   
   
   
   

4. Click Choose File of JSON File Path field to upload a sample JSON file.

5. Expand Advanced Properties to view the advanced properties of JSON layout.
   
   
   
   

6. Define the character-set encoding for your JSON layout. The available options are UTF-8, UTF-16, UTF-32, and ISO-8859-1.

7. Select the Interpret and convert data types check box if you want to convert the data from one file format to another.

8. Select the project in the Project field.

9. In Array Fields, provide the field value which you want to be an individual array. Click Add Row to define multiple field values. To remove the row, enter the row position value in the Remove Position field and click Remove Row.
   

   Adeptia Connect supports an array with a single JSON data. You need to follow the step 9 to define one or multiple arrays of such type.

10. Click Save to save the JSON layout.

Retaining the special characters in a JSON Layout

You can retain the special characters, for example, \n,\r, in a JSON data file by configuring the property abpm.connect.jsonschema.retainSpecialCharacters.

To set this property, follow the steps given below:

1. Go to Account > Settings.
2. Expand Server Nodes Settings, and select a node.
3. Click Edit and then expand the category Services > Schema Property.
4. In the property, abpm.connect.jsonschema.retainSpecialCharacters, enter the special characters (comma separated) that you want to retain, for example, \n,\r. 
5. Click Save.