Analytics-Plus Help

Supported Formats for Importing JSON Files

Analytics Plus allows you to import data from JSON files. The following section details examples of the various JSON formats that can be imported into Analytics Plus. 

Supported JSON Formats

JSON object

This section explains the various types of JSON objects that can be imported into Analytics Plus.

Simple JSON object

The following is a illustration of a simple JSON object with conference details.

{
     "name": "2013 NSMH National Conference ",
     "start_time": "2013-02-14T17:30:00",
     "end_time": "2013-02-17T22:30:00",
     "timezone": "America/New_York",
     "location": "Hilton Orlando Resort, Lake Buena Vista",
     "id": "201214829989340"
}

Array inside object

The following example illustrates each employee details specified as object within the "employees" array.

{
       "employees":
         [
                { "Name":"John Smith" , "ID":"652" , "Department":"Graphics" , "Designation":"Designer" , "Reporting To":"Anna" },
                { "Name":"Charles Stone" , "ID":"653" , "Department":"Accounts" , "Designation":"Accountant" , "Reporting To":"Tricia Boyle" },              
                { "Name":"Jasmine Frank" , "ID":"654" , "Department":"Sales" , "Designation":"Sales Executive" , "Reporting To":"Dieter Klein" }
      ]
}

Objects inside object

The following example is a student's guardians list, with objects specified as key value within another object.

{
        "Student Name": "Emmy Wilson",
        "Grade": "IV",
        "Father":
        {
                "Name": "Steve Wilson",
                "Mobile Number": "212-555-1234",
                "E-mail ID": "steve@xyz.com"
        },
        "Mother":
        {
                "Name": "Loura Wilson",
                "Mobile Number": "212-555-1864",
                "E-mail ID": "loura.w@xyz.com"
        }
}

Object of nested objects

The following example details customer contact information, with multiple level nested objects.

{
    "Customers": {
        "Name": "Emmy Wilson",
        "Contact Detail": {
           "Address": [{
                    "Address for Contact":{
                        "Door No": "21",
                        "Street": "E Edenton Street",
                        "city": "Raleigh",
                        "state": "North Carolina",
                        "postal Code": 27601
                },
                   "Permanent Address":{
                       "Door No": "34",
                        "Street": "Walnut Street",
                         "city": "Cary",
                         "state": "North Carolina",
                         "postal Code": 27511
                }
            }],
            "Contact Number": [{
                "Mobile Number": "212-432-9244",
                "Landline": "646-555-4567"
            }]
        }
    }
}

Object and array inside object

The following is an illustration of an array of objects specified as key value within another object, with the details of the task list assigned to a member.

{
    "Name": "John Smith",
    "Designation": "Designer",
    "Contact Details": {
        "E-mail": "johns@zillum.com",
        "Extension": "6214",
        "Mobile": "415-173-5890",
        "Seat Location": "6F4C21S"
    },
    "Tasks": [
       {
            "Task": "Revamping Product Layout",
            "Status": "In progress",
            "Start Date": "10 Nov, 2013",
            "Due Date": "20 Nov, 2013"
        },
        {
            "Task": "Icons redesigning",
            "Status": "To be started",
            "Start Date":  "21 Nov, 2013",
            "Due Date": "27 Nov, 2013"
       }
    ]
}

Multi path JSON object

The following is an illustration of a multiple array of objects specified as values within an object. The example lists classes conducted in a music school.

{
    "School" : "Kinder World Music School",
    "Age": "Above 5",
    "Address": {
        "street Address": "21 2nd Street",
        "city": "New York",
        "state": "NY",
        "postal Code": 10021
   },
    "Classes": [
        {
            "Course": "Piano",
            "Day": "Monday and Thursday",
            "Start Time": "16:30",
            "End Time": "17:30"
        },
        {
            "Course": "Guitar",
            "Day": "Tuesday and Friday",
            "Start Time": "18:00",
            "End Time": "19:00"
        }
   ],
    "Tutor": [
        {
            "name": "Yann",
            "Venue": "NB 16"
        },
        {
            "name": "Roger",
            "Venue": "NB 23"
        }
   ]
}

Array of JSON objects

This section details the supported formats in which an array of JSON objects can be imported into Analytics Plus.

Array of simple JSON objects

The following is an illustration of multiple objects within an array. This example captures catalogues in a library.

[
    {
        "category": "children fiction",
        "author": "Agatha Kite",
        "title": "Good Night Stories",
        "price": 8.95
    },
  {
        "category": "fiction",
        "author": "David Ben",
        "title": "Sword of Ivan",
        "price": 12.99
   },
    {
       "category": "fashion",
        "author": "Ria Johnson",
        "title": "Color Magics",
       "price": 16.56
    }
]

Array of complex JSON objects

The following is an illustration of objects within array in multiple level. The example lists projects undertaken in a research institute.

[
{
    "Student": "Hiyoshi Nakamura",
    "Subject": "Business Communication",
    "Guide": "Amritha Agrawal",
    "Projects":
    {
        "Project": [
        {
            "ID": "1001",
            "Title": "Rhetoric and Business Communication"
        },
        {
            "ID": "1002",
            "Title": "Enrich your language to Persuade"
        },
        {
            "ID": "1003",
            "Title": "Email Etiquette"
        },
        {
            "ID": "1004",
            "Title": "Power of Diction"
        }
        ]
    }
},
{
    "Student": "Manish Patel",
    "Subject": "Energy Conversion",
    "Guide": "James Winston",
    "Projects":
    {
        "Project": [
        {
            "ID": "1005",
            "Title": "Solar energy for farms"
        },
        {
            "ID": "1006",
            "Title": "Bio-gas - Purification and Bottling"
        }
        ]
    }
}
]

Unsupported JSON Formats

The following are the JSON formats that are not supported by Analytics Plus during data import. 

Array or object containing simple values without keys

If the array or object contains simple values without keys (i.e. column names), then the file will not be imported.

Example [14,78,97,45]

Improper JSON Format

If the file contains multiple JSON objects that are separated by comma without enclosing those objects within a square bracket, only the first object will be imported.

Example          

 {
         "name": "2013 NSMH National Conference ",
         "start_time": "2013-02-14T17:30:00",
         "end_time": "2013-02-17T22:30:00",
         "timezone": "America/New_York",
         "location": "Hilton Orlando Resort, Lake Buena Vista",
         "id": "201214829989340"
      },
      {
         "name": "CMH model WHO conference 2012",
         "start_time": "2013-02-01T01:00:00",
         "end_time": "2013-02-02T01:00:00",
         "location": "CMH Lahore Medical College",
         "id": "236863469755789"
      }

 

Share this post : FacebookTwitter