Airtable’s Enterprise API documentation can be accessed when logged into an Airtable account connected to an Enterprise workspace. The article below is a brief overview of Airtable’s helpful API as it specifically relates to our Enterprise customers.
If you or your team have development experience, then using our API can help to perform certain programmatic or bulk actions that would otherwise take tedious, repetitive, and/or manual effort to perform. In order to access and use the Enterprise API you will need:
- An Airtable account
- A workspace or workspaces on the Airtable Enterprise plan
The Airtable Enterprise API uses key-based (token) authentication like Airtable's standard REST API. All requests should send the API key in the Authorization header. This is covered in the Enterprise API documentation near the top of the page.
Additionally, all requests to these endpoints must be made on the server-side. Client-side requests are not allowed because they would expose the user's API key.
WARNINGDo not share your API key with anyone (including anyone at Airtable) since it's effectively a password that allows access to all your bases. If you accidentally reveal your API key, you should regenerate your API key as soon as possible at https://airtable.com/account
Using the Airtable Enterprise API
Airtable’s Admin Panel provides an interface for reviewing users, bases and workspaces, as well as setting enterprise-wide security settings. The Enterprise API allows teams to manage their account programmatically outside of the Admin panel UI through actions like managing users, updating access permissions, and managing bases, tables, and views.
Occasionally, some teams may want to add their own metadata on top of the information pulled by an API request such as department information, managers, or billing units. This allows them to more effectively organize their enterprise resources and take action when necessary.
Example use cases
The API endpoints discussed below represent just some of the ways that our API can be used from an administrative/IT perspective. Note that any links to the API documentation below will result in a 404 page if you are not logged in under an Enterprise-connected Airtable account.
Security and User management
- Get user information - fetches all the information related to a single user.
- Manage single or multiple (batched) users - update email and/or activate/deactivate users for onboarding and offboarding purposes.
- Clear (revoke) and/or regenerate API keys for the specified user.
- Requesting and retrieving audit logs - Request and retrieve audit logs for actions done in enterprise workspaces and bases.
- Enterprise Base Share - This endpoint allows admins to see and manage who has access to bases with the added functionality of deleting base share links.
Base and Workspace management
- Create bases, tables, and fields - As an alternative to duplicating a base from the UI, use these API methods to programmatically create Airtable bases, tables, and fields. Note that some advanced field types such as formulas cannot be created via API.
- Listing and removing views programmatically
- Sharing specific bases with lists of users - Add collaborators to bases programmatically. This is especially useful for onboarding purposes or adding a group of users.
NOTECertain methods described above are only available to users with Enterprise admin permissions. The API listed under "Enterprise account" and "User group" are available to admins only.
I'm an Enterprise user, but I'm unable to access the Enterprise API -- what's causing this?
Your organization may have an FLA (Flexible License Agreement) with Airtable, which means that only certain workspaces are upgraded to Enterprise, while others remain on our self-serve plans (Free, Plus, and Pro). It's only possible to use the Enterprise API in Enterprise-enabled workspaces (and the bases contained in them) at this time.