REST API Connector

The REST API inbound connector extracts data from external REST API endpoints and loads the data into Nitro tables. The connector allows users to maximize their data integrations without creating and running custom scripts. The REST API connector is not limited to specific data sources and can be used to source data from most web applications that offer data using REST APIs. Both secure and open APIs are supported.

To configure the REST API connector:

  1. Create a Nitro support ticket to request approval for a REST API URL and auth URL.
  2. Log into the NAC.
  3. Select Inbound from the Connectors menu.
  4. Select New Connector.
  5. Enter the Display Name and Description for the connector.
  6. Select Data API as the Connector Type.

  7. Select the Base URL in Source Details.
  8. Select the Authorization Type:
  9. Enter the following Source Details:
    • Auth URL (required)
    • Auth Pretoken (optional)
    • Token Key (required)
    • Payload (optional) - Add one or more key-value pairs
    • Header (optional) - Add one or more key-value pairs
  10. Select Save and continue to Adding REST API Resources.

Adding REST API Resources

Multiple resources under the base API URL can be configured under the same connector with their own path, header, and query parameters, and mapped to different tables with loading patterns such as append_load or truncate_and_load.

The tables for this connector are created during the loading process and do not need to be pre-created using YAMLs.

To add REST API resources:

  1. Select Edit for the connector you just created.
  2. Select Add in the Rest API Resources section.
  3. Enter required and optional information.

  4. Select Save.

Running the REST API Job

Once you have configured the REST API connector, you can run the REST API Extract Load job.

  1. Select History from the Jobs menu.
  2. Select Run Job.
  3. Select the REST API connector you created.
  4. Select the REST API Extract Load job.
  5. Select Execute. The job runs and extracts data from all active resources set for the connector and loads the data into the mapped tables.