Build dashboards with JSON Files

JSON (JavaScript Object Notation) is a lightweight data interchange format used to store structured data. It represents data in a human-readable format with key-value pairs enclosed in curly braces. JSON files are commonly used for transmitting data between servers and web applications due to their simplicity and ease of parsing across various programming languages and platforms.

title

How do I activate this integration?

1

First Step

Log in to your account, navigate to the Data sources page and click on New data source.
2

Second Step

Provide a name for the data source, an optional description, and select JSON as the type. Then click on Connect.
3

Third Step

Upload a JSON file and then click on Save Changes. This should automatically fetch the column descriptions and sample data to verify if the upload was successful.

title

What can I do with this integration?

You can import data from different sheets within your JSON document as data sources on Onvo. The integration ensures that any updates in your JSON document reflect in real-time on your dashboards.

Build interactive dashboards using your JSON data, effortlessly creating widgets based on your visualization preferences. Ask questions in natural language to explore your data, and perform data pre-processing before visualization. Integrating dashboards into your products with the SDK is also supported.

title

How do I create a dashboard using multiple files?

On Onvo, achieve this by creating distinct data sources for each file and specifying the field used for data correlation in the "fields" tab. This allows the AI to generate the necessary code for joining data without manual query writing.

Security considerations

Exercise caution and only upload JSON documents that you intend to share with Onvo to prevent unintentional data exposure.