Airtable integration: operations for AI agents
Airtable connects to Type.com as an integration. This page lists the 105 operations documented for Claude and Codex in Type.com: 33 read, 29 write, 43 destructive.
About Airtable
Airtable public record, schema and administration API reference, with explicit base grants, enterprise requirements, alternate-host and raw CSV limitations.
Categories: Productivity & Project Management
How to connect Airtable to Type.com
- Connect
- Managed Pipedream OAuth when enabled; direct Bearer personal access token or OAuth access token at fixed /v0 base
- Access
- Organization connection: one shared account for the workspace.
To add the connection, follow the steps in Space connections.
Documented operations
105 operations. Your connection's permissions determine which operations are available. API references describe the vendor surface; they do not expand your connection's credentials or access.
105 operations listed.
scim
- Read
List groups
List groups as [SCIM Groups](https://datatracker.ietf.org/doc/html/rfc7643#section-4.2) objects. [SCIM specification for list responses.](https://datatracker.ietf.org/doc/html/rfc7644#section-3.4.2)
GET /scim/v2/Groups - Read
Get group
Get a single group as a [SCIM Group](https://datatracker.ietf.org/doc/html/rfc7643#section-4.2) object.
GET /scim/v2/Groups/{groupId} - Read
List users
List users as [SCIM User](https://datatracker.ietf.org/doc/html/rfc7643#section-4.1) objects. See the SCIM specification for [list responses](https://datatracker.ietf.org/doc/html/rfc7644#section-3.4.2) for more.
GET /scim/v2/Users - Read
Get user
Get a single user as a [SCIM User](https://datatracker.ietf.org/doc/html/rfc7643#section-4.1) object.
GET /scim/v2/Users/{userId} - Write
Create group
Create a new group from a [SCIM Group](https://datatracker.ietf.org/doc/html/rfc7643#section-4.2) object. This endpoint creates a group with no members. Use the [patch group](/api/patch-scim-group) or [put group](/api/put-scim-group) endpoints to populate the new group with members.
POST /scim/v2/Groups - Write
Create user
Create a new user from a [SCIM User](https://datatracker.ietf.org/doc/html/rfc7643#section-4.1) object. The response is the SCIM user object representing the newly created user. On creation, the user will always be marked active, and the emails array will include a single entry that matches the username. See the [SCIM User schema](https://datatracker.ietf.org/doc/html/rfc7643#section-4.1) for details. **`userName` semantics.** In most configurations, `userName` is the user's email and becomes the `email` field in Airtable. When the targeted SSO identity provider has `emailAttribute` configured, `userName` is the IdP-supplied SSO identifier (which may be non-email, up to 255 characters) and the user's email is taken from `emails[primary].value`. In that mode you must send `emails` with a primary entry on create. **Off-domain provisioning.** To provision a user whose primary email is on a domain that is not verified by the enterprise (for example, a franchise or partner email), send the [Airtable SSO extension](/api/scim-overview#scimAirtableSsoExtension) (`urn:airtable:params:scim:schemas:extension:sso:2.0:User`) with the `emailDomain` field naming a verified enterprise domain whose IdP has `emailAttribute` configured. Without the extension, off-domain SCIM POST requests are rejected with `400 — emailDomain extension required for off-domain provisioning`. Off-domain users created this way are not auto-verified — they receive a verification email and cannot sign in via SSO until they click the link. *WARNING*: As the user is provisioned without a password, the use of this endpoint is only intended on environments with SSO Active. *WARNING*: If your enterprise is not capturing the user's email domain, it is possible this will fail with a conflict against an already created user that is not a member of your enterprise (and this not visible when [listing users](/api/list-scim-users)). If this occurs, it is recommended you add the user to your enterprise (e.g. add them to a workspace and then claim them).
POST /scim/v2/Users - Destructive
Delete group
Delete a single [SCIM Group](https://datatracker.ietf.org/doc/html/rfc7643#section-4.2).
DELETE /scim/v2/Groups/{groupId} - Destructive
Patch group
SCIM patch an array of operations to a Group and applies them sequentially. See [SCIM specification](https://datatracker.ietf.org/doc/html/rfc7644#section-3.5.2) for more.
PATCH /scim/v2/Groups/{groupId} - Destructive
Put group
Replace a Groups's attributes with all new values.
PUT /scim/v2/Groups/{groupId} - Destructive
Delete user
Delete a single SCIM user. The endpoint cannot be used to delete the admin that owns the authentication token used to make the request. The endpoint cannot be used to delete the sole owner of a workspace that has multiple collaborators. See [SCIM specification](https://datatracker.ietf.org/doc/html/rfc7644#section-3.6) for more.
DELETE /scim/v2/Users/{userId} - Destructive
Patch user
Perform a list of SCIM patch operations in sequence on an existing user. See [SCIM specification](https://datatracker.ietf.org/doc/html/rfc7644#section-3.5.2) for more.
PATCH /scim/v2/Users/{userId} - Destructive
Put user
Replace a user's attributes with all new values. The body parameters are the same as those for [creating a user](/api/create-scim-user), except that you can set `active` to true or false.
PUT /scim/v2/Users/{userId}
webhooks
- Read
List webhooks
Lists all webhooks that are registered for a base, along with their statuses. **Read level permissions are required in order to list webhooks.**
GET /v0/bases/{baseId}/webhooks - Read
List webhook payloads
Enumerate the update messages for a client to consume. Clients should call this after they receive a ping. The webhook payload format can be found [here](/api/model/webhooks-payload) and uses [V2 cell value format](/api/field-model). Calling this endpoint will also extend the life of the webhook if it is active with an expiration time. The new expiration time will be 7 days after the list payloads call.
GET /v0/bases/{baseId}/webhooks/{webhookId}/payloads - Write
Create a webhook
Creates a new webhook in the specified base. Payloads may be generated and the notification URL (if given) will get a ping shortly after this completes. The number of webhooks per base is limited to 10. A single OAuth integration can create up to 2 webhooks per base. Each webhook created with OAuth or personal access token will expire and be disabled after 7 days. The webhook life can be extended while it is still active by calling [refresh webhook](/api/refresh-a-webhook) or [list webhook payloads](/api/list-webhook-payloads). After a webhook has expired and been disabled, the webhook's metadata and past payloads can be accessed for an additional 7 days. **Creator level permissions are required in order to register a webhook.**
POST /v0/bases/{baseId}/webhooks - Write
Refresh a webhook
Extend the life of a webhook. The new expiration time will be 7 days after the refresh time. Note that this endpoint only applies to active webhooks with an expiration time. **Creator level permissions are required in order to refresh a webhook.**
POST /v0/bases/{baseId}/webhooks/{webhookId}/refresh - Destructive
Delete a webhook
Deletes a webhook. **Creator level permissions are required in order to delete a webhook.**
DELETE /v0/bases/{baseId}/webhooks/{webhookId} - Destructive
Enable/disable webhook notifications
Enables or disables notification pings for a webhook. See [notification delivery](/api/webhooks-overview#webhook-notification-delivery). **Creator level permissions are required in order to enable or disable webhook notification pings.**
POST /v0/bases/{baseId}/webhooks/{webhookId}/enableNotifications
base
- Read
List bases
Returns the list of bases the token can access, 1000 bases at a time. If there is another page to request, pass the offset as a URL query parameter. (e.g. `?offset=itr23sEjsdfEr3282/appSW9R5uCNmRmfl6`)
GET /v0/meta/bases - Read
Get base collaborators
Returns basic information on the base. Does not include deleted collaborators and only include [outstanding](/api/org-management-glossary#outstanding-invite) invites.
GET /v0/meta/bases/{baseId} - Read
Get base schema
Returns the schema of the tables in the specified base.
GET /v0/meta/bases/{baseId}/tables - Write
Create base
Creates a new base with the provided tables and returns the schema for the newly created base. Refer to field types for supported field types, the write format for field options, and other specifics for certain field types. Supported field types have a write format shown. At least one table and field must be specified. The first field in the fields array will be used as the table's primary field and must be a supported primary field type. Fields must have case-insensitive unique names within the table. A default grid view will be created with all fields visible for each provided table.
POST /v0/meta/bases
workspace
- Write
Create workspace
Creates a new workspace with the provided name within the specified enterprise account and returns the workspace id. The requesting user must be an active effective admin of the enterprise account; the created workspace's owner will be the user who makes the request.
POST /v0/meta/workspaces - Write
Move base
Move a base between two workspaces owned by the enterprise.
POST /v0/meta/workspaces/{workspaceId}/moveBase - Destructive
Delete base
Deletes the specified base. Deleted bases can be restored by workspace owners from the Trash UI, up to the workspace's billing plan retention period.
DELETE /v0/meta/bases/{baseId} - Destructive
Move workspaces
Batch move workspaces between two enterprise accounts belonging to the same organization. This endpoint can only be used if your enterprise account has the Enterprise Hub feature enabled. If the target enterprise account has the invite settings restricted to org unit members, all non-org unit member collaborators will be removed when the workspaces are moved. For more information about invites settings, please see [our support article](https://support.airtable.com/docs/settings-airtable-admin-panel#sharing-and-data-in-the-admin-panel).
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/moveWorkspaces - Destructive
Delete workspace
Deletes the specified workspace. Deleted workspaces can be restored by workspace owners from the Trash UI, up to the workspace's billing plan retention period. **WARNING:** If the API user is not currently a workspace owner (one example where this can happen is if the API user is an enterprise admin), the workspace will not show up in the user's Trash. **WARNING:** Any bases in the deleted workspace will no longer be accessible, be sure to double check whether there are any actively used bases before proceeding with workspace deletion. If you want to retain access to these bases, you should transfer the bases to another workspace before deleting the workspace.
DELETE /v0/meta/workspaces/{workspaceId} - Destructive
Update workspace restrictions
Update [sharing restrictions settings](https://support.airtable.com/docs/workspace-sharing-restrictions) for the workspace.
POST /v0/meta/workspaces/{workspaceId}/updateRestrictions
block
- Read
List block installations
Lists basic information of base block installations.
GET /v0/meta/bases/{baseId}/blockInstallations - Destructive
Delete block installation
A deleted block installation is recoverable.
DELETE /v0/meta/bases/{baseId}/blockInstallations/{blockInstallationId} - Destructive
Manage block installation
Manages block installation state.
PATCH /v0/meta/bases/{baseId}/blockInstallations/{blockInstallationId}
collaborators
- Read
Get interface
Returns general information about the interface. Does not include deleted collaborators and only includes [outstanding](/api/org-management-glossary#outstanding-invite) invites. `pageBundleId` is the ID of the interface and can be found in the [`interfaces`](/api/get-base-collaborators#response-interfaces) object returned by the [get base collaborators](/api/get-base-collaborators) endpoint.
GET /v0/meta/bases/{baseId}/interfaces/{pageBundleId} - Read
Get workspace collaborators
Returns basic information on the workspace. Does not include deleted collaborators and only include [outstanding](/api/org-management-glossary#outstanding-invite) invites.
GET /v0/meta/workspaces/{workspaceId} - Write
Add base collaborator
Add a new base collaborator. Despite the name, this route currently only supports adding one collaborator at a time.
POST /v0/meta/bases/{baseId}/collaborators - Write
Add interface collaborator
Use this to add a collaborator to an interface.
POST /v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators - Write
Add workspace collaborator
Add a new workspace collaborator. Despite the name, this route currently only supports adding one collaborator at a time.
POST /v0/meta/workspaces/{workspaceId}/collaborators - Destructive
Delete base collaborator
Delete a base collaborator.
DELETE /v0/meta/bases/{baseId}/collaborators/{userOrGroupId} - Destructive
Update collaborator base permission
Updates the permission level of a collaborator on a base.
PATCH /v0/meta/bases/{baseId}/collaborators/{userOrGroupId} - Destructive
Delete interface collaborator
Delete an interface collaborator. Requires base collaborator access to remove others, but can be used to remove yourself even with interface-only collaborator access.
DELETE /v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators/{userOrGroupId} - Destructive
Update interface collaborator
Use this to update permissions for an interface-only collaborator.
PATCH /v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators/{userOrGroupId} - Destructive
Delete workspace collaborator
Delete a workspace collaborator.
DELETE /v0/meta/workspaces/{workspaceId}/collaborators/{userOrGroupId} - Destructive
Update workspace collaborator
Updates the permission level of a collaborator on a workspace.
PATCH /v0/meta/workspaces/{workspaceId}/collaborators/{userOrGroupId}
invites
- Destructive
Delete interface invite
Delete an interface invite. The invite must be [outstanding](/api/org-management-glossary#outstanding-invite).
DELETE /v0/meta/bases/{baseId}/interfaces/{pageBundleId}/invites/{inviteId} - Destructive
Delete base invite
Delete a base invite. The invite must be [outstanding](/api/org-management-glossary#outstanding-invite).
DELETE /v0/meta/bases/{baseId}/invites/{inviteId} - Destructive
Delete workspace invite
Delete a workspace invite.
DELETE /v0/meta/workspaces/{workspaceId}/invites/{inviteId}
shares
table
- Write
Create table
Creates a new table and returns the schema for the newly created table. Refer to [field types](/api/model/field-type) for supported field types, the write format for field options, and other specifics for certain field types. Supported field types have a write format shown. At least one field must be specified. The first field in the fields array will be used as the table's primary field and must be a supported primary field type. Fields must have case-insensitive unique names within the table. A default grid view will be created with all fields visible.
POST /v0/meta/bases/{baseId}/tables - Write
Update table
Updates the name, description, and/or date dependency settings of a table.
PATCH /v0/meta/bases/{baseId}/tables/{tableIdOrName}
column
- Write
Create field
Creates a new column and returns the schema for the newly created column. Refer to field types for supported [field types](/api/model/field-type), the write format for field options, and other specifics for certain field types. Supported field types have a write format shown.
POST /v0/meta/bases/{baseId}/tables/{tableId}/fields - Write
Update field
Updates the name, description, and/or options of a field. At least one must be specified.
PATCH /v0/meta/bases/{baseId}/tables/{tableId}/fields/{columnId}
view
- Read
List views
Lists basic information of base views.
GET /v0/meta/bases/{baseId}/views - Read
Get view metadata
Get basic information of base view.
GET /v0/meta/bases/{baseId}/views/{viewId} - Destructive
Delete view
Delete a view.
DELETE /v0/meta/bases/{baseId}/views/{viewId}
enterprise
- Read
Get enterprise
Returns basic information relevant to the enterprise account.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId} - Read
List packages
List all packages for an enterprise account
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/packages - Read
List personal access tokens
List personal access tokens for users administered by this enterprise account. Only supported for root (organization-level) enterprise accounts; a request for a descendant (org unit) enterprise account returns an error. For enterprise-scoped tokens, resourceAccess.enterpriseAccountId is returned only when the scoped enterprise is the requested root enterprise account or one of its descendants.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/personalAccessTokens - Write
Create descendant enterprise
Creates a descendant enterprise account of the enterprise account. Descendant enterprise accounts can only be created for root enterprise accounts with the Enterprise Hub feature enabled. Note that descendant enterprise accounts are also called organizational units (org units). For more information on org units in organizations with Enterprise Hub, please see [our support article](https://support.airtable.com/docs/enterprise-hub-in-airtable#understanding-and-using-organizational-units).
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/descendants - Write
Create base from package
Creates a new base by installing a package template for an enterprise account, and returns the schema for the newly created base. Provide the packageId as part of the request path and the packageReleaseId in the request body to create a base from a package template. You can retrieve them with the [List packages](/api/list-enterprise-packages) endpoint. The package will be installed into a new base, creating all tables, fields, and views defined in the package.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/packages/{packageId}/install - Destructive
Revoke personal access tokens
Revoke personal access tokens for users administered by this enterprise account. Only supported for root (organization-level) enterprise accounts; a request for a descendant (org unit) enterprise account returns an error. The response includes both revokedTokens and errors so callers can handle partial success.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/personalAccessTokens/revoke - Destructive
Remove user from enterprise
Unshare a user from all enterprise workspaces, bases, interfaces, and user groups. If applicable, the user will also have their admin access revoked. Returns lists of unsharing and sharing actions performed as part of the user removal.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/{userId}/remove - Destructive
Update workspace AI allowlist
Add or remove workspaces from the enterprise AI allowlist. Accepts up to 10 workspaces per request. Only applicable when the enterprise AI workspace restriction policy is set to SPECIFIED_WORKSPACES. Set includeDescendantWorkspaces to true to include workspaces from descendant org units.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/workspaceAiAllowlist
auditLogs
- Read
Audit log events
Retrieve audit log events for an enterprise. By default, this will walk all the data we're currently storing and continue walking data into the future.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/auditLogEvents
auditing
- Read
List audit log requests
**NOTE:** Use of this API is discouraged for new use cases. Prefer to use the [audit log events API](/api/audit-logs-overview) instead. Retrieve all audit log requests.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/auditLogs - Read
Get audit log request
**NOTE:** Use of this API is discouraged for new use cases. Prefer to use the [audit log events API](/api/audit-logs-overview) instead. Retrieve a specific audit log request.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/auditLogs/{enterpriseAuditLogTaskId} - Write
Create audit log request
**NOTE:** Use of this API is discouraged for new use cases. Prefer to use the [audit log events API](/api/audit-logs-overview) instead. Create an audit log request. This starts the processing necessary to retrive the logs. The response includes an `id`, which is then used to [check the status of and download](/api/get-audit-log-request) your logs.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/auditLogs
changeEvents
- Read
Change events
Retrieve change events for enterprise bases. These change events are available for 14 days from the date of the event. This endpoint requires change events to be enabled for your enterprise account and toggled on in your enterprise admin panel. Please contact your account team or support to start this process. Events are generated only after you turn change events on in your admin panel.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/changeEvents - Read
List eDiscovery exports
Get the status and result of all eDiscovery exports.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/exports - Read
Get eDiscovery export
Get the status and result of an eDiscovery export.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/exports/{enterpriseTaskId} - Write
Create eDiscovery export
Create an eDiscovery export request. The response includes an `id`, which is then used to [check the status of and download](/api/get-ediscovery-export) your export.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/exports
userManagement
- Read
Get user group
Returns basic information relevant to the user group.
GET /v0/meta/groups/{groupId} - Destructive
Move user groups
Batch move user groups between two enterprise accounts belonging to the same organization. This endpoint can only be used if your enterprise account has the Enterprise Hub feature enabled. If the target enterprise account has the invites settings restricted to org unit members, group members who are non-org unit members will be removed when the user groups are moved. For more information about invites settings, please see [our support article](https://support.airtable.com/docs/settings-airtable-admin-panel#sharing-and-data-in-the-admin-panel).
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/moveGroups
user
- Read
Get users by id or email
Returns basic information relevant to both [internal](/api/org-management-glossary#internal-user) and [external](/api/org-management-glossary#external-user) user.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users - Read
Get user by id
Returns basic information relevant to both [internal](/api/org-management-glossary#internal-user) and [external](/api/org-management-glossary#external-user) user.
GET /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/{userId} - Write
Grant admin access
Grant admin access to users. To use this endpoint, provide either the user's `id` or `email` in the request body. If both are supplied, the `email` will be ignored. In the example request provided, the first two users are successfully processed while all of the remaining users are not processed and are returned in the `errors` array with the reason why they were not able to be processed.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/grantAdminAccess - Destructive
Delete users by email
Delete multiple users by email.
DELETE /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users - Destructive
Manage user batched
Batch manage enterprise account users. One of `id` or `email` must supplied in the body. If both are supplied, `id` will be used as the identifier in changing user email to the `email` specified in the request. *WARNING:* We recommend performing actions on up to 10 users at a time to avoid timeouts. Though we currently do not enforce a limit on the number of users you can manage at once, we are monitoring the performance of this endpoint and may enforce a limit in the future.
PATCH /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users - Destructive
Manage user membership
Batch manage organizations enterprise account users. This endpoint allows you to change a user's membership status from being unmanaged to being an organization member, and vice versa. To use this endpoint, provide either the user's `id` or `email` in the request body. If both are supplied, the `email` will be ignored. This endpoint can only be used if your enterprise is not domain capturing. In the example request provided, the first two users are successfully processed while all of the remaining users are not processed and are returned in the `errors` array with the reason why they were not able to be processed. Note that the domain of the user you are trying to claim must be verified in your organization's Admin Panel. If the domain is not verified, the user will not be claimed and will be returned in the `errors` array. For more information on managing users and the different types of users in organizations, please see [our support article](https://support.airtable.com/docs/using-organizations).
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/claim - Destructive
Revoke admin access
Revokes admin access from users. To use this endpoint, provide either the user's `id` or `email` in the request body. If both are supplied, the `email` will be ignored. In the example request provided, the first two users are successfully processed while all of the remaining users are not processed and are returned in the `errors` array with the reason why they were not able to be processed. Note that you can only revoke directly assigned admin access.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/revokeAdminAccess - Destructive
Delete user by id
Delete ELA enterprise account [internal](/api/org-management-glossary#internal-users) users and "claiming" enterprise account [managed](/api/org-management-glossary#managed-user) users.
DELETE /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/{userId} - Destructive
Manage user
Manage enterprise account [managed](/api/org-management-glossary#managed-user) users.
PATCH /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/{userId} - Destructive
Logout user
Logout the user. Only available for ELA and FLA [internal](/api/org-management-glossary#internal-user) enterprise account users and [managed](/api/org-management-glossary#managed-user) "claiming" enterprise users.
POST /v0/meta/enterpriseAccounts/{enterpriseAccountId}/users/{userId}/logout
doNotRender
- Write
Update record (put)
Updates a single record. Any unspecified fields are **not updated**. Table names and table ids can be used interchangeably. We recommend using table IDs so you don't need to modify your API request when your table name changes. Your request body should include a **fields** property whose value is an object containing your record's cell values, keyed by either field name or field id. Automatic data conversion for update actions can be enabled via **typecast** parameter. The Airtable API will perform best-effort automatic data conversion from string values if the **typecast** parameter is passed in. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.
PUT /v0/{baseId}/{tableIdOrName}/{recordId} - Destructive
Revoke a personal access token
Revoke the personal access token used to authenticate this request.
POST /v0/meta/revoke - Destructive
Update multiple records (put)
Update multiple records. This will perform a **destructive** update and clear all unspecified cell values. Table names and table ids can be used interchangeably. We recommend using table IDs so you don't need to modify your API request when your table name changes. Your request body should include an array of record objects. Each of these objects should have an **id** property representing the record ID and a **fields** property which contains all of your record's cell values by field name or field id for all of your record's cell values by field name. To issue an upsert request, where records would be created if no matching records to update are found, your request body should include a **performUpsert** parameter with **fieldsToMergeOn**. **fieldsToMergeOn** is an array with at least one and at most three field names or ids, where combined together, represent a unique record. Fields to merge on cannot be computed and must be of the following field types: number, text, long text, single select, multiple select, and date. In this case, the id property within record objects is optional. In addition to **records**, **updatedRecords** and **createdRecords** will be included as part of the response, containing record ids to specify which records were created or updated. Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy. Automatic data conversion for update actions can be enabled via **typecast** parameter. The Airtable API will perform best-effort automatic data conversion from string values if the **typecast** parameter is passed in. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.
PUT /v0/{baseId}/{tableIdOrName}
whoAmI
- Read
Get user info
Retrieve the user's ID. For OAuth access tokens, the scopes associated with the token used are also returned. For tokens with the `user.email:read` scope, the user's email is also returned.
GET /v0/meta/whoami
record
- Read
List records
List records in a table. Note that table names and table ids can be used interchangeably. We recommend using table IDs so you don't need to modify your API request when your table name changes. The server returns one page of records at a time. Each page will contain **pageSize** records, which is 100 by default. If there are more records, the response will contain an **offset**. To fetch the next page of records, include **offset** in the next request's parameters. Pagination will stop when you've reached the end of your table. If the **maxRecords** parameter is passed, pagination will stop once you've reached this maximum. Returned records do not include any fields with "empty" values, e.g. **""**, **[]**, or **false**. You can filter, sort, and format the results with query parameters. Note that these parameters need to be URL encoded. You can use our [API URL encoder tool](https://codepen.io/airtable/pen/MeXqOg) to help with this. If you are using a helper library like [Airtable.js](https://github.com/Airtable/airtable.js), these parameters will be automatically encoded. **Note** Airtable's API only accepts request with a URL shorter than 16,000 characters. Encoded formulas may cause your requests to exceed this limit. To fix this issue you can instead make a POST request to `/v0/{baseId}/{tableIdOrName}/listRecords` while passing the parameters within the body of the request instead of the query parameters.
GET /v0/{baseId}/{tableIdOrName} - Read
Get record
Retrieve a single record. Any "empty" fields (e.g. **""**, **[]**, or **false**) in the record will not be returned. **Note** If we can't locate the record on a given table, the request will fallback to a base wide search and will still return the record if the Record ID is valid and the record is located within the same base.
GET /v0/{baseId}/{tableIdOrName}/{recordId} - Read
List records using a JSON request body
List records using the same options as GET list records, supplied in a JSON body to avoid the 16,000-character URL limit. This POST alternative is explicitly documented on the official list-records page but absent from its embedded OpenAPI paths.
POST /v0/{baseId}/{tableIdOrName}/listRecords - Write
Upload attachment
Upload an attachment up to 5 MB to an attachment cell via the file bytes directly. To upload attachments above this size that are accessible by a public URL, they can be added using https://airtable.com/developers/web/api/field-model#multipleattachment
POST /v0/{baseId}/{recordId}/{attachmentFieldIdOrName}/uploadAttachment - Write
Update multiple records
Updates records, or upserts them when `performUpsert` is set (see below). The URL path accepts both table names and table IDs. We recommend using table IDs so you don't need to modify your API request when your table name changes. A `PATCH` request will only update the fields included in the request. Fields not included in the request will be unchanged. A `PUT` request will perform a destructive update and clear all unincluded cell values. ### Upserts Set the `performUpsert` property in your request to enable upsert behavior. When upserting is enabled, the `id` property of records becomes optional. Records that do not include `id` will use the fields chosen by [`fieldsToMergeOn`](/api/update-multiple-records#request-performupsert-fieldstomergeon) as an external ID to match with existing records. * If zero matches are found, a new record will be created. * If one match is found, that record will be updated. * If multiple matches are found, the request will fail. Records that include `id` will ignore `fieldsToMergeOn` and behave as normal updates. If no record with the given `id` exists, the request will fail and will not create a new record. The API response for upsert requests will additionally include `updatedRecords` and `createdRecords` arrays, indicating which records in the `records` array already existed and were updated, or did not exist and were created, respectively. Airtable reserves the right to throttle upsert requests differently from the [standard rate limit throttling policy](https://airtable.com/developers/web/api/rate-limits). ### Typecasting Set the `typecast` parameter to `true` to enable typecasting. When typecasting is enabled, Airtable will try to convert string values in a record's `fields` object to the appropriate cell value. This conversion is only performed on a best-effort basis. Typecasting is disabled by default to ensure your data's integrity, but it may be helpful when integrating with third-party services.
PATCH /v0/{baseId}/{tableIdOrName} - Write
Create records
Creates multiple records. Note that table names and table ids can be used interchangeably. We recommend using table IDs so you don't need to modify your API request when your table name changes. Your request body should include an array of record objects. Each of these objects should have one key whose value is an inner object containing your record's cell values, keyed by either field name or field id. Returns a unique array of the newly created record ids if the call succeeds. You can also include a single record object at the top level.
POST /v0/{baseId}/{tableIdOrName} - Write
Sync CSV data
Syncs raw CSV data into a Sync API table. You must first set up a sync from a base (instructions in this [support article](https://support.airtable.com/docs/airtable-sync-integration-api-endpoint)). The **apiEndpointSyncId** in the path parameters can be found in the setup flow when creating a new Sync API table, or from the synced table settings. The CSV data can contain up to 10k rows, 500 columns, and the HTTP request's size is limited to 2 MB. Up to 10k rows will be synced per sync run. If you send two requests that each contain a CSV with 10k rows before a sync run occurs, then only 10k rows will be synced. There is a rate limit of 20 requests, per 5 minutes, per base for this endpoint.
POST /v0/{baseId}/{tableIdOrName}/sync/{apiEndpointSyncId} - Write
Update record
Updates a single record. Table names and table ids can be used interchangeably. We recommend using table IDs so you don't need to modify your API request when your table name changes. A **PATCH** request will only update the fields you specify, leaving the rest as they were. A **PUT** request will perform a destructive update and clear all unspecified cell values. Your request body should include a **fields** property whose value is an object containing your record's cell values, keyed by either field name or field id. Automatic data conversion for update actions can be enabled via **typecast** parameter. The Airtable API will perform best-effort automatic data conversion from string values if the **typecast** parameter is passed in. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.
PATCH /v0/{baseId}/{tableIdOrName}/{recordId} - Write
Update date dependency metadata
Update date dependency metadata for a linked predecessor on a successor record. The rowId path parameter is the successor record ID.
PATCH /v0/{baseId}/{tableIdOrName}/{recordId}/dateDependencyMetadata - Destructive
Delete multiple records
Deletes records given an array of record ids
DELETE /v0/{baseId}/{tableIdOrName} - Destructive
Delete record
Deletes a single record
DELETE /v0/{baseId}/{tableIdOrName}/{recordId}
comment
- Read
List comments
Returns a list of comments for the record from newest to oldest. Note: Comments in reply to another comment (where `parentCommentId` is set) may not have their parent comment in the same page of results and vice versa.
GET /v0/{baseId}/{tableIdOrName}/{recordId}/comments - Write
Create comment
Creates a comment on a record. [User mentioned](/api/model/user-mentioned) is supported.
POST /v0/{baseId}/{tableIdOrName}/{recordId}/comments - Write
Update comment
Updates a comment on a record. API users can only update comments they have created. [User mentioned](/api/model/user-mentioned) is supported.
PATCH /v0/{baseId}/{tableIdOrName}/{recordId}/comments/{rowCommentId} - Destructive
Delete comment
Deletes a comment from a record. Non-admin API users can only delete comments they have created. Enterprise Admins can delete any comment from a record.
DELETE /v0/{baseId}/{tableIdOrName}/{recordId}/comments/{rowCommentId}
hyperDB
- Read
Read records
Read records from a HyperDB table
POST /v0/{enterpriseAccountId}/{dataTableId}/getRecords - Write
Update or insert records
Update or insert records from a HyperDB table with primary keys matching specified primary keys
PUT /v0/{enterpriseAccountId}/{dataTableId}/upsertRecords - Destructive
Delete records
Delete records from a HyperDB table with primary keys matching specified primary keys
POST /v0/{enterpriseAccountId}/{dataTableId}/deleteRecords
No operations match.
Get started
- Open Space settings → Connections and search for Airtable.
- Connect your account and add the connection to the Space.
- Ask for what you need in any thread in that Space.
See How connections work for access and permissions, or browse all integrations.