Airtable

Airtable logo

Airtable

Configuration

Airtable source connector integrates with the Airtable API to extract and synchronize data.

Connects to your Airtable bases and syncs everything by default:

  • User info (authenticated user)
  • All accessible bases
  • All tables in each base
  • All records in each table
  • All comments on each record
  • All attachments in each record

No configuration needed - just connect and sync!

Authentication

This connector uses OAuth 2.0 authentication. You can connect through the Airweave UI or API using the OAuth flow.

Supported authentication methods:

  • OAuth Browser Flow (recommended for UI)
  • OAuth Token (for programmatic access)
  • Auth Provider (enterprise SSO)

Configuration Options

This connector does not have any additional configuration options.

Data Models

The following data models are available for this connector:

The authenticated user (from /meta/whoami endpoint).

FieldTypeDescription
user_idstrAirtable user ID
emailOptional[str]User email address
scopesOptional[List[str]]OAuth scopes granted to the token

Metadata for an Airtable base.

FieldTypeDescription
base_idstrAirtable base ID (e.g., appXXXXXXX)
namestrBase name
permission_levelOptional[str]Permission level for this base
urlOptional[str]URL to open the base in Airtable

Metadata for an Airtable table (schema-level info).

FieldTypeDescription
table_idstrAirtable table ID (e.g., tblXXXXXXX)
base_idstrParent base ID
namestrTable name
descriptionOptional[str]Table description, if any
fields_schemaOptional[List[Dict[str, Any]]]List of field definitions from the schema API
primary_field_nameOptional[str]Name of the primary field
view_countOptional[int]Number of views in this table

One Airtable record (row) as a searchable chunk.

FieldTypeDescription
record_idstrRecord ID
base_idstrParent base ID
table_idstrParent table ID
table_nameOptional[str]Parent table name
fieldsDict[str, Any]Raw Airtable fields map
created_timeOptional[datetime]Record creation timestamp

A comment on an Airtable record.

FieldTypeDescription
comment_idstrComment ID
record_idstrParent record ID
base_idstrParent base ID
table_idstrParent table ID
textstrComment text
author_idOptional[str]Author user ID
author_emailOptional[str]Author email address
author_nameOptional[str]Author display name
created_timeOptional[datetime]Comment creation timestamp
last_updated_timeOptional[datetime]Comment last updated timestamp

Attachment file from an Airtable record.

FieldTypeDescription
base_idstrBase ID
table_idstrTable ID
table_nameOptional[str]Table name
record_idstrRecord ID
field_namestrField name that contains this attachment
created_atOptional[datetime]Attachment creation timestamp