JSON

The JSON Connector in Lumenore enables you to import data from JSON files or JSON-based APIs into the platform. It supports reading structured, nested JSON data and converting it into a tabular format for analysis and visualization in Lumenore.

Import Guidelines:

While importing data from JSON, ensure the following:

• Only the .json file format is supported.
• Avoid blank or null values between JSON objects, as they may cause parsing issues.
• Remove all formatting except date formats before uploading the file to Lumenore.

Steps to connect:

Step 1: Navigate to Home > Connect Data > Select Connector > JSON.

Step 2: Click “Browse File.”

Step 3: Select the file. The upload progress will be displayed.

Step 4: Once the file has loaded successfully, the file name appears in the download box.

Step 5: The next button is now enabled. Click “Next.”

Step 6: Select the table you want to export from Excel to the Lumenore database. You can also view the data by clicking the Preview tab. The Preview tab allows you to preview the table data, apply filters, and perform transformations.

Note: For more details, refer to Step 7 of the Excel Connector user guide.

Step 7: Click “Save Dataset” to complete data ingestion.

Step 8: Provide the Dataset name and description (optional). Click Ok.

Step 9: A “Dataset created successfully” message is displayed. After this, the user can cancel and start using the dataset or create a schema by clicking the Create Schema option.