JSON Help

Description

JSON (JavaScript Object Notation) is a lightweight, text-based format used for data interchange. JSON is easy to read and write for humans and simple to parse and generate for machines. Its structure is composed of two elements: objects, containing key-value pairs, and arrays, holding lists of values. Keys in JSON objects are strings, and values can be strings, numbers, arrays, true or false, null, and other objects. This format is widely used in web applications for sending data between clients and servers, as well as in configuration files and data feeds.

Upload Settings for JSON

Click on Upload Settings button to start configuring the import settings for your JSON file.

RECORD

Use this option to tell the system where each row of data starts. Turn this on for the part of your JSON that repeats. For example, a list of items, users, or accounts.

FIELD

Use this option to tell the system which pieces of information to include in your results. Turn this on for any value you want to appear as a column. For example, IDs, names, or balances.

Example

Take the below JSON data as an example:

{
  "data": [
    {
      "Id": "1",
      "AccountNo": "101",
      "LastName": "Reeves",
      "FirstName": "Keanu",
      "Balance": "12",
      "CreditLimit": "1000.23",
      "AccountCreated": "17/01/1998",
      "Rating": "A"
    },
    {
      "Id": "2",
      "AccountNo": "102",
      "LastName": "Butler",
      "FirstName": "Gerard",
      "Balance": "123456",
      "CreditLimit": "1234567891",
      "AccountCreated": "06/08/2003",
      "Rating": "B"
    },
    {
      "Id": "3",
      "AccountNo": "103",
      "LastName": "Hewitt",
      "FirstName": "Jennifer",
      "Balance": "4294967295",
      "CreditLimit": "9876543211",
      "AccountCreated": "25/05/1985",
      "Rating": "B"
    }
  ]
}

            

The RECORD switch would be ON for the data array (each object inside is one record).

The FIELD switches would be ON for Id, AccountNo, LastName, and other properties you want as columns.

Once you have configured the settings, click Save Changes to apply them.