FME Flow - Failing to retrieve refresh token from GCP

Hi ​@fmejohn93, this is a frustrating issue for sure. 

Often times when web connections work temporarily on FME Flow the issue is the web service from Form. I haven’t personally used BigQuery, but this issue arises for other OAuth 2.0 web connections. 

Did you create a copy of the Google BigQuery template before adding your credentials and uploading that to FME Flow? Part 2 in the article Creating an OAuth 2.0 Web Service and Connection in FME explains how to do this. 

Tandra,

Thanks for your response. I did try creating a new web service and connection based on the Google BigQuery (safe.google-bigquery) template and performed the initial authorization on FME Form. Once I published that connection, service and workspace to Flow, the job succeeded even though it says this new web service has not been configured for Web authorization.

I will try the workspace again later and see if I get any error

There are two parts to authenticating web services on FME Flow. First you need to add the details (client secret and redirect URI) under “Manage Web Services”, then you can authenticate the connection in Web Connections. 

If the steps in Manage Web Services aren’t completed, the Authorize button will be greyed out. 
 

Were both steps completed? 

Tandra,

After adding the client secret and redirect URI for this new web service and authenticating it, I run into the same error in my original post: works at first and then fails when trying again after roughly an hour.

Thanks, I’ve just submitted a case ticket regarding this issue