After an initial connection, we are able to stream data into the Big Query tables for about an hour before the workflow starts failing for the following reason:
ERROR: Error: No refresh token
Error: Error: No refresh token
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest.node.js:806:27)
at processTicksAndRejections (internal/process/task_queues.js:93:5)
at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:416:47```
Opening the credentials and reconnecting will give us a new valid token for another hour.
We recently added the Google BigQuery node. You can use the node to create and get your records. If there’s any specification functionality that the node is missing please let us know by creating a feature request
Had the exact same problem using the Youtube Data API, but no native Node there to save me
Turns out, by looking at how other Google Node were implemented in the github repo (credential folder), I found that Google credentials need to be set at “Body” in the Authentication dropdown not “Header”
And then it worked like a charm !
You can also regularly schedule a simple get call in order to refresh the token (if like me you are in test and your refresh token expires after 7 days of inactivity)