Connect a JSON file with Bold Data Hub

The Bold Data Hub JSON connector loads data from a JSON file into Bold Reports^®. JSON is a lightweight text format used to store and exchange data. It is widely used in web APIs and applications because it is simple and structured. It is easy for humans to read and write, and easy for machines to parse and generate.

Example Configuration

The Bold Data Hub JSON connector uses the FileSystem extractor with type: json, as this YAML template shows:

version: 1.0.1
encrypt_credentials: false
union_all_tables: true
add_dbname_column: false
use_snake_casing: true
plugins:
  extractors:
  - name: FileSystem
      connectorname: FileSystem
      schemaname:
      config:
      properties:
        storage: local
        type: json
        filePath: C:\BoldServices\app_data\elt\connectors\mockdata.json
      metadata:
      select:

How do I connect a JSON file in Bold Data Hub?

You connect a JSON file by creating a pipeline in Bold Data Hub, adding the JSON template, and pointing the filePath property to your uploaded file.

Click the Data Hub icon on the Navigation Pane.
Click Add Pipeline and enter a name for the new pipeline.
Select the newly created pipeline and add the JSON template.
Click the Upload File button to upload your JSON file.
Copy the file path and paste it into the filePath property.
Click Save and choose the destination to save the pipeline.

Creating a pipeline in Bold Data Hub automatically creates a data source in Bold Reports^®. The Bold Reports^® data source is a live data source to the destination database used in Bold Data Hub.

JSON Data Hub - Reports

How do I schedule the JSON pipeline?

You schedule the JSON pipeline in Bold Data Hub from the schedules tab, or you run it on demand.

To configure interval-based scheduling, click the schedules tab, select the created pipeline, click the schedule icon, and configure the schedule.
For an on-demand refresh, click the Run Now button.
Check the schedule history with the history option and the logs.
Click Logs to see whether the run is completed and the data source is created in Bold Reports^®.