Airtable Source Provider
The Airtable Source feeds data from Airtable bases supporting Record and Records queries.
Settings
| Setting | Description | Default |
|---|---|---|
| Name | The name that will identify this source instance. | |
| Default Cache Time | The default duration in seconds before the cache is renewed, set to 0 to disable caching. This setting can be overriden in each query configuration. | 3600 |
| Setting | Description |
|---|---|
| Account | The Airtable Account which to authenticate with. |
| Base | The Airtable base which to retrieve the data from. |
| Table | The Airtable base table which data to create the source with. |
Record Query
Fetches a single record from an Airtable base and resolves to Record Type.
| Setting | Description | Default | Dynamic |
|---|---|---|---|
| Record ID | The ID of the record to query. | ✓ | |
| Cache | The duration in seconds before the cache is invalidated and the query re-executed. | 3600 |
Records Query
Fetches records from an Airtable base and resolves to a list of Record Type.
| Setting | Description | Default | Dynamic |
|---|---|---|---|
| View | Optional table view to use instead of a raw query. | ||
| Start | The offset applied to the query. | 1 | ✓ |
| Quantity | The limit applied to the query. | 20 | ✓ |
| Cache | The duration in seconds before the cache is invalidated and the query re-executed. | 3600 |
Record Type
The record type will be dynamically generated based on the Airtable base table schema by mapping field types with GraphQL types as follows.
| Airtable Field Types | Type | Filters |
|---|---|---|
| Number, Count, Currency, Duration, Percent, Rating, Auto number | Int | |
| AI Text, Long Text, Rich text, Single line text | String | Limit |
| Date, Date and time, Created time, Last modified time | String | Date |
| Multiple select | String with separator | |
| Created by, Last modified by, Collaborator, Multiple collaborators | User | |
| Multiple attachments | Attachment |
Every record has the following fields available regardless of it schema.
| Field | Description | Type | Filters |
|---|---|---|---|
| ID | The unique identifier of this record. | String | |
| Created Time | The unixstamp when this record was created. | String | Date |
User Type
| Field | Description | Type |
|---|---|---|
| The user email. | String | |
| Name | The user name. | String |
| ID | The user unique identifier. | String |
Attachment Type
| Field | Description | Type |
|---|---|---|
| URL | The attachment url, e.g. https://v5.airtableusercontent.com/foo. Notice that URLs expire 2 hours after being returned from the Airtable API. | String |
| Filename | The attachment filename, e.g. foo.jpg. | String |
| Type | The attachment content type, e.g. image/jpeg. | String |
| Size | The attachment file size, in bytes. | Int |
| Width | The attachment width in pixels, if attachment is an image. | Int |
| Height | The attachment height in pixels, if attachment is an image. | Int |
| Thumbnail | The attachment thumbnail, if attachment is an image. | String |
| ID | Unique attachment id. | String |