To sync data from Airtable, just go to the data icon in the left of the project dashboard and click the plus icon to add a new connection. Airtable records can be connected to dynamic pages, and their field and table relationships built into the page tree.
Access to Airtable
The first time you connect to Airtable you will be prompted to allow access. The process will ask you to connect to Airtable, and which bases or workspaces you want to allow. The easiest option is to allow all bases in all workspaces, but if that’s not possible you can add specific workspaces or bases individually.
Connect Base & Views
To see the list of bases you have authorized for use in Aeropage, from the dashboard click the database icon then select Airtable. You will then see a list of bases that you can connect to the project.
If you cant see the base you need to connect, you may need to authorize it from Airtable.
Changing Access
If you chose to only allow specific bases access, and you need to add more - this must be done from within Airtable. You can open Airtable, and from the menu in the top-right choose Integrations.
Default Table Fields
Every connected Airtable table has its own default fields namely Name, Image, and Slug.
The default Name field is the primary field for that table. It is commonly used as a slug/URL path for dynamic pages and for displaying the primary field value in your content (i.e. cards, text, etc) The default Image field is the first image attachment found in your field list. The default Slug field is used when you want to have a different slug in the URL. If it’s not set, it will use the value of the default Name field. Usually, Aeropage auto assigns the Name and Image fields depending on your Airtable table schema. However, there are use cases when it needs to be changed.
To do so:
Click the Data Icon at the side of your project dashboard After a popup appears, click on either the Name, Image or Slug select box to choose the field Then sync the data after you have chosen the fields
If you can’t fnd the field in the field list, click “Refresh Data” in the “Choose Fields” popup.
Webhooks & Realtime syncing
When switched on Airtable will notify Aeropage each time a change is made in your base, and the new data will automatically be updated.
You can enable webhooks by clicking on the base and toggling on the desired options.
If there are no changes for a week, the webhooks will automatically disconnect.
Excluding Fields in API response
There are times when the Airtable data exceeds the 4MB response size limit of our API that communicates with Airtable. If you encounter this error, you can exclude fields that are not needed in the project. This setting will apply when querying Airtable data via our API.
To do so:
Open the Data Modal and choose a table. Inside the table settings modal, click on the Excluded Fields button (the one with the number). Choose the fields to be excluded and click the Apply button. There is no need to sync the data since the excluded field settings are saved automatically.
For this to work on and your connected domain, please publish a new version of the project in the project dashboard.
Expired and Revoked Tokens
Airtable tokens expire if it isn’t refreshed within two months after it was last used. You can check if the token is already expired by going to Airtable and clicking on Integrations on the menu in the top-right corner. Expired integrations have a red text displaying the days since it last expired.
You can also delete the expired integrations since it is not functional anymore and just causes confusion.
There are also times when Airtable revokes a token. Usually revoked or expired token returns an UNAUTHORIZED or Invalid Token error as seen in the screenshot below. Aeropage will try to renew the token but when it is revoked, an email notification is sent to the project owner informing them to reauthenticate.
Reauthenticate Aeropage in Airtable
When an Airtable token has expired or has been revoked, you will need to reauthenticate. To do so:
Click on the Data Icon and after that, click the + icon on the upper right corner. Select Airtable on the popup that appears after clicking the + icon. Click Connect to Airtable. This is shown when Airtable token was not found in our database, has expired or has been revoked. A popup window appears which will prompt you to choose the bases and workspaces. Please note to add all the bases that your projects use. Once done, click “Grant Access” button.