Airtable integration
Airtable is a cloud collaboration platform for organizing and managing data.
There are two resources associated with Airtable. Both are required to use Airtable's API from Windmill.
Airtable account
Airtable authenticates with personal access tokens (legacy API keys were removed in February 2024). Create a token on Airtable's Builder hub, grant it the scopes you need (e.g. data.records:read, data.records:write) and access to the bases you want to use, then paste it on Windmill as the apiKey field of the resource.
| Property | Type | Description | Default | Required | Where to find |
|---|---|---|---|---|---|
| apiKey | string | Airtable personal access token | patXXXXXXXXXXXXXX | true | airtable.com/create/tokens > Create token |
Airtable table
Now specify Airtable which database and table you want to interact with:
- Database ID can be found on the URL of the page. It starts with "app" and ends before the next "/". e.g. appcy7pfdzgJIhto.
- Table name is the name of the tab. By default it is called "Table 1".
| Property | Type | Description | Required | Where to find |
|---|---|---|---|---|
| baseId | string | Unique identifier for a specific Airtable base | True | Page URL |
| tableName | string | Name of an individual table within that base | True | In Airtable. Name of the tab of a database |
Your resource can be passed as a parameter or fetched directly within scripts, flows, low-code apps and full-code apps.