Hi everyone wanted to share information on connecting to Google services through OAuth 2.0, which can be a bit tricky.
I’ve copied a solution for setting up Google BigQuery. If you are connecting a different Google service, it likely uses the same OAuth 2.0 method. Please ignore parts of this that do not apply to your service, or replace them with the relevant Google Cloud information.
Getting set up
Go to your project dashboard at https://console.cloud.google.com/home/dashboard and click “Explore and enable APIs” under “Getting Started.”
- Click on the BigQuery (or other service) API link, or click “+ Enable APIs and Services”
- Search for and enable the API you wish to connect to
- Click on Credentials
- Click “+ Create Credentials” and choose “OAuth client ID”
- Set up the name for your credentials by clicking “Create Consent Screen” and enter https://parabola.io/api/steps/generic_api/callback as a verified callback URL
Now, you should have a client_id and client_secret.
In Parabola, open the Pull from an API step and select the OAuth 2.0 option from the Authorization tab. Click the blue Authorize button.
You will now see a form with three parts:
Part 1
Replace the value that follows “client_id” with your actual client_id, and replace “bigquery” with the name of the service you are trying to connect to.
Part 2
Enter this URL: https://www.googleapis.com/oauth2/v4/token
For the Access Token Request Body, enter these 4 pairs:
- grant_type : authorization_code
- redirect_uri : https://parabola.io/api/steps/generic_api/callback
- client_id : your client id
- client_secret : your client secret
Replace the values for the last two with your actual client_id and client_secret.
Part 3
Use the same URL as part 2, and in the body, send the following:
- grant_type : refresh_token
- client_id : your client id
- client_secret : your client secret
Replace the values for the last two with your actual client_id and client_secret.
Final Steps
- Click the blue Authorize button at the bottom of the form, and a pop up window should appear asking if you would like to connect Parabola to your Google account
- Click on the account that you want to connect (if it prompts you), and it will show you a warning that “This app isn’t verified”
- Click the “Continue” button, and then allow Parabola access to the service
- Click on “Allow” to create authorize the connection
- It may ask you to verify which project you’d like to connect - choose the project and confirm
After all of that, you should be returned to Parabola, and can now access your Google’s APIs. Feel free to comment specific questions below, and we are happy to help you configure these connections!
Note: We know this documentation is not perfect, and we are continually updating this information any and all suggestions are welcome!