How do I connect Google Fit data to Bold BI?

In this article, we will guide you on how to connect Google Fit data to Bold BI using the Generic Web API connector.

1. Go to Google API Console.
2. Select an existing project or create a new one. Follow the instructions here to create a project and obtain an API key.
3. Once you have obtained the API key, enable the Google Fit API in the Google Cloud Platform Console. You can follow the instructions here to enable the API.
4. Then click the Credentials tab in the left pane.
5. Click New credentials and select OAuth Client ID.
6. Under Application type, select Web application.
7. Under Authorized JavaScript origins, enter the base URL of the site from which requests will originate (for example, https://developers.google.com is the URL used by the OAuth Playground).
8. Under Authorized redirect URI, enter the Callback URL of the site where responses will be handled.
9. Click Create. Your new OAuth 2.0 Client ID and secret appear in the list of IDs for your project.
10. Go to Google OAuth Playground
11. Under Step 1 Select & authorize APIs locate and expand Fitness API v1 and select the Fitness scopes to use.
12. Click Authorize APIs.
13. Select the Google API Console project to use, and click Allow when prompted. You will be able to access and modify data associated with the selected Google API Console account.
14. Click the Exchange authorization code for tokens button under Step 2.

15. Copy the access token from the Google Playground.

Connect through Generic Web API connector in Bold BI
Once you have completed the above steps, you can connect the Google Fit API to Bold BI using the Generic Web API connector. Follow the instructions here to set up the Generic Web API connector in Bold BI.

1. Set the API endpoint URL based on the Google Fit API you want to access. Add the required endpoint (Google Fit API) URL in the Bold BI Web data source URL field.

2. Set the required headers, method type and body,

• HTTP Method: Set the HTTP method to POST.
  • Headers: Add the following headers:
    • Authorization: Bearer <access_token>
    • Content-Type: application/json
  • Body: Set the request body based on the Google Fit API you want to access.

Note: Access token will expire in 3600 seconds (approx. 1 hour).

Now, you should have successfully connected Google Fit to Bold BI using the Generic Web API connector. You can start building visualizations and dashboards using the Google Fit data.

Related Articles:

• Google Fit API Documentation
• Bold BI Generic Web API Documentation