Skip to content
AIV

Dataset Using JSON

This guide explains how to create a dataset in AIV using JSON (JavaScript Object Notation) files. JSON is a lightweight, text-based format for storing and transporting data that is easy to read and parse.

What is JSON?

JSON (JavaScript Object Notation) is a text format for storing and transporting data. It is self-describing and widely used for structured data exchange. AIV supports JSON files as a data source for creating datasets.

Prerequisites

Before you begin:

  • Download the sample json.zip file from this link.
  • Extract the zip file to access employee(1).json.
  • Upload the file to Shared Resources. For instructions, see Upload documents.

Steps to Create a Dataset Using JSON

Step 1: Upload the JSON File to Shared Resources

  1. From the hamburger menu, click Document and go to Shared Resources.
  2. Click Upload.

Upload

  1. Select the employee(1).json file from your extracted json.zip.
  2. Click Upload.

Upload JSON

  1. Confirm the success message appears.

Upload success

Step 2: Navigate to Master Data

  1. In the Master Data tab, click Dataset.
  2. Click Create Dataset from the bottom menu or action bar.

Create Dataset

Step 3: Create the Dataset

  1. In Create Dataset, enter:
    • Name: Employee JSON (or your preferred name)
    • Datasource: Existing Files
  2. In the Details tab, select JSON as the file type.
  3. Choose employee(1).json from the list view.
  4. Fill in any additional configuration as needed.

Create JSON dataset

Step 4: Validate and Preview

  1. Open the Output tab to ensure columns are detected correctly.
  2. If columns appear as expected, open the Preview tab to verify the data.
  3. Click Create to save the dataset.

Step 5: Use the Dataset

The dataset appears in the Dataset section and is ready for use in dashboards and widgets. To add it to a dashboard, see Create Table Widget.

JSON dataset created

Explore other ways to create datasets in AIV:

Data SourceGuide
Drag & dropCreate Dataset
ExcelDataset using Excel
CSVDataset using CSV
ParquetDataset using Parquet
NoSQLDataset using NoSQL
Flat filesDataset using Flat files
Google BigQueryDataset using Google BigQuery
Google SheetDataset using Google Sheet
External sourcesDataset using External sources
Stored ProcedureDataset using Stored Procedure
ViewDataset using View