Supported Formats for Importing JSON Files

Zoho Analytics supports importing data from JSON files. This section lists examples for the different supported JSON formats, which can be imported into Zoho Analytics.

 Supported JSON Formats

 JSON object

 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 sample 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 sample is a student guardian list with object 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 sample is a customer contact details with nested objects with multiple level.

{
"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 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 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

 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

 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 separated by comma without enclosing those objects inside a square bracket, then the first object alone will be considered for import. Since the rest is not a proper JSON format.

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"
}