Upgrading Airtable data connections
Last updated
Last updated
Airtable data connections in Stacker use Airtable API keys. Upgrading your Airtable connections means that your Airtable data connection will use a new authentication method.
The upgrade will also give your apps new functionality, for example such as real time data sync between your Airtable base and Stacker, also known as real time Airtable sync. Read more about real time Airtable sync .
Aside from getting real time updates, it is important to upgrade because Airtable is on the 1st of February 2024. In other words, you will need to upgrade for your apps to continue working.
The upgrade is free, and does not change your data structure or layouts.
Note: Any Airtable data connections created in workspaces created after the 10th of April already use the new authentication method, and do not need to be upgraded.
The new authentication methods also provide a higher standard for security, as compared to API keys. You can see more in from Airtable.
Personal Access Tokens and OAuth provide a higher standard for security over API Keys, which were the predecessor that provided “all-or-nothing” access over everything that an Airtable user account could see or do. These new methods have more granular control of resources and scopes and allow you to extend Airtable, all while ensuring the highest grade of security.
You will need to upgrade each data connection separately, and only takes a few minutes. See the video below, or follow the instructions here:
Click App Settings
Under Data Sources, click the Upgrade button
Follow the flow which directs you to Airtable to grant access to Stacker
We suggest you pick “All current and future bases in all current and future workspaces” in the dropdown, so that you do not have to go through the full upgrade flow for future data connections. After granting access you will be redirected to Stacker.
Click Grant access
This Airtable base is not accessible error showing on the top of the data grid or the app settings page means that your Airtable data connection has lost access to Stacker.
You will need to repair your Airtable data connection if:
The token is still valid but no longer provides access to the base it is connected to. For example, you've adjusted the permission of the token to no longer include the base.
The token is no longer valid. For example, the token was revoked in Airtable.
The data connection has no token assigned. For example, the Stacker user who set up the data connection has been removed from Stacker.
To fix your data connection, you will need to Repair the data connection from the app settings page in Stacker:
Go to App Settings
Click Data Sources
Find the data connection that says This Airtable base is not accessible
Click the Repair button
If you need to re-authenticate, you will be guided to Airtable to grant access to Stacker:
Pick “All current and future bases in all current and future workspaces” in the dropdown, so that you do not have to go through the full upgrade flow for future data connections
Click Grant access
Your data source should be repaired with no error message
From the Repair modal, click on the word Airtable to be navigated to Airtable in a new tab.
In Airtable, click your profile image in the top right-hand corner
Click Integrations in the dropdown menu
Click Third-party integrations
Click Stacker
Under All Workspaces, check that the base you are using in Stacker is available.
Change the permissions to All current and future bases in all current and future workspaces
Navigate back to Stacker and click Try Again
Your data source should be repaired with no error message
If this does not repair your data connector:
Your Airtable account may not have access to the base of the data connector. If this is the case, contact the owner of the base and ask them to share the base with you, or ask them to go through the repair flow.
The base may no longer exist—it may have been deleted. In this case, we are unable to repair the data connection.
Depending on the reason for repair, you may be asked to either , or
If you are asked to adjust the permissions of your token, you will be shown after clicking Repair. The video will walk you through the steps to adjust permissions: