Hi everyone!
I followed the instruction for importing a base in Airtable to Nocodb and I got all the tables imported, but with no data.
the log gave me this error: data :: You should provide valid api key to perform this operation(AUTHENTICATION_REQUIRED)[Http code 401]
Help is much appreciated.
Thx
API Keys in Airtable are deprecated. Please use the link below to know how to create PAT (Personal Access Token). Ensure you give appropriate permissions for the base you are trying to import
Thx for the advice. I did use a PAT with the appropriate permissions (those suggested by nocodb) and I able to import all the tables, but not the data in them?
If you have multiple base with same name, it is easy to mix up when configuring permissions. Please check if your token has appropriate data-read permissions for the base being imported.
You can try using the following CURL command to verify if your PAT has appropriate access. Replace “appID” with your airtable application ID, “tableName” with your table name and “YOUR_SECRET_API_TOKEN” with your PAT
curl "https://api.airtable.com/v0/appID/tableName?maxRecords=3 \
-H “Authorization: Bearer YOUR_SECRET_API_TOKEN”
I started over and concluded the the error was sitting approx 20 inches away from the screen. I runs perfectly now.
Thx dstala