How do I connect REST APIs with OAuth2 authentication?

In Bold BI, there are only limited OAuth 2.0 based data connectors available at present. If you have any other REST API-based data source with OAuth 2.0 based authentication, you can connect it to Bold BI following this document.

To connect an OAuth2 data source, you first need to create the Refresh Token API of your data source as a separate data source and save the token column as a dashboard parameter. Afterwards, this parameter is passed to the data source through authorization header as bearer token.

Steps to create token as dashboard parameter

1. Create an extract mode Web data source with a Token API of your data source. The token API should be entered into the URL, as well as adding the required parameters and headers as described in the data source you are connecting.
   

   

2. Click Connect and you should be able to see the tokens from the API you connected.
   

   

3. In Query Designer page, drag and drop the table and click the dashboard parameter icon.
   

   

4. Create a dashboard parameter in the token data source with token column as dashboard parameter. In the parameter dialog, for Value select the Data Source radio button and select the column which has the token in Value Field and Display Field.

   

5. Save the parameter once you did the above changes.

6. Now you can pass the token to any data source which needs this token, by following below syntax.
   Syntax: @{{:DatasourceName.ParameterName}}
   

   
   

By following the above steps you can fetch the OAuth 2.0 token from your data source in a web connector and pass it into another web connector to fetch the data.

Related Articles

• Dashboard parameters
• Generic Web data source connector