Supported Formats for Importing JSON Files
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.
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.
{
"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"
}
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Supported Formats for Importing XML Files
Zoho Analytics supports importing data from XML files. This section lists examples for the different supported XML formats, which can be imported into Zoho Analytics. Supported XML Format Elements only The following example illustrates a book ...Import data from files
If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...Importing Data into an Existing Table
You can easily import data stored in local drives, web URLs, or cloud storages/drives in various file formats into existing tables in Zoho Analytics. This allows you to update and modify the records in existing tables in a workspace. You could also ...From files and feeds
Often you would already have data locally stored in tabular file formats like CSV, XLS (Excel), JSON, and HTML files. The data in such formats could also be available as a URL or Web feed or even some application generated. Zoho Analytics offers easy ...Import data from JDBC Driver Supported databases
If you have your data stored in JDBC Driver Supported databases, then you can easily import your data into Zoho Analytics for reporting & analysis. Data Import 1. How do I import data from the JDBC Driver Supported databases? 2. How can I edit the ...