Google Business API: how to connect

Matillion ETL
1

Hey guys,

 

I'm writing my own API query configs for the new Google My Business API.

Question is has anyone else done this before?

 

I'm having issues with OAuth.

 

The OAuth connection authenticates but doesn't work to grab a refresh token.

I am thinking to build my own refresh token query but just wondering if anyone has experience using Matillion with Google My Business API.

 

https://developers.google.com/my-business/content/basic-setup

 

Thanks,

Steve

2

ANSWER:

 

Be sure to enter the additional parameters:

scope = https://www.googleapis.com/auth/business.manage

auth_provider_x509_cert_url = https://www.googleapis.com/oauth2/v1/certs

prompt = consent

access_type = offline

 

The above parameters are required for Google Business API to issue a refresh token on subsequent calls.

 

And I created my own connector since Google Business endpoints have changed...