OpenAPI

OpenAPI fetch data from OpenAPI 3.x documents.

OpenAPI features supported

1. All HTTP methods are supported.
2. JSON and form bodies, path and query parameters are accepted.
3. File uploads can be done with multipart/form-data bodies.
4. Supported data types include float, string, int, date, datetime, string enums, and custom schemas or lists containing any of those.
5. Responses can be in html/text or application/json format containing any of the mentioned types.
6. Basic or Bearer Authentication is not supported.

Connection Properties

The config section in a YAML file includes the following properties:

        ymlURL: 
        ymlPath: 

Example Configuration

version: 1.0.1
encrypt_credentials: false
plugins:
  extractors:
    - name: OpenAPI
      connectorname: OpenAPI
      config:
        ymlURL: 
        ymlPath: 
      select:
        - tablename

Configure the Bold Data Hub to connect OpenAPI

1. Click the Data Hub icon on the Navigation Pane.

2. Click Add Pipeline and provide the new pipeline’s name.

3. Select the newly created pipeline and add the OpenAPI template.

4. Update the Url and Path in the template

5. Click Save and choose the desired destination to save the pipeline.

6. Creating a Pipeline in Bold Data Hub automatically creates a Data Source in Bold BI. The Bold BI Data Source is a live data source to the destination database used in Bold Data Hub. For more information on the relationship between Bold Data Hub Pipeline and the associated Data Sources in Bold BI , please refer to Relationship between Bold Data Hub Pipeline and Associated Data Sources in Bold BI.

Schedule Data Hub Job

1. To configure interval-based scheduling, click on the schedules tab and select the created pipeline and click on the schedule icon and configure it.

2. For on-demand refresh, click Run Now button.

3. The Schedule history can be checked using the history option as well as logs.

4. Click on Logs to see if the run is completed and data source is created in Bold BI.

5. Click Edit DataSource Option to view the created tables.