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 window, 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 from the drop-down list of Project.

  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 

    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.