- Is this your first time deploying Airbyte?: No
- OS Version / Instance: Ubuntu
- Memory / Disk: 12 GBs / 30 GBs
- Deployment: Docker
- Airbyte Version: 0.40.26
- Source name/version: Airtable/2.0.3
- Destination name/version: Bigquery/1.2.14
- Step: During sync
- Description: I’ve tried to change the authentication to Airtable by using the OAuth, and it does work for two hours, but then I get a message
2023-03-02 09:30:15 source > {"error":{"type":"UNAUTHORIZED","message":"Invalid authentication token"}}
2023-03-02 09:30:15 source > 401 Client Error: Unauthorized for url: https://api.airtable.com/v0/meta/bases
This happened twice already, same pattern: I create a new refresh token, save the connection and execute it hourly, it works for two hours, and from the third hour on I receive this error message.
Furthermore, on the first time this happened, I’ve got this email
But this didn’t happen in the second time. I’ve tried to go to the Integration’s panel, but nothing changed there
Now, I don’t know if the problem is with Airbyte, and how this integration is being called, or with Airtable.
The steps I’ve followed to create the refresh-token:
1- On Airtable, created a new OAuth integration https://airtable.com/create/oauth called “Airbyte”
2- Added the following scopes data.records:read, data.recordComments:read and schema.bases:read
3- Executed this GET request to get the code
using the client_id
generated by the OAuth integration Airtable Web API
4- With the code
received from the GET
request above, executed a POST request as such Airtable Web API
With the information received from the POST request, added the following information in the Airbyte connector:
- Client ID
- access_token
- Client secret
- Refresh token
- token_expiry_date (this one, I’ve chosen as “2 months”)
Full log uploaded
12cde809_e760_4c5e_93f9_16e8776afd71_logs_15506_txt.txt (146.8 KB)
o