Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes the steps you need to perform in both Airtable and Microsoft Entra ID to configure automatic user provisioning. When configured, Microsoft Entra ID automatically provisions and deprovisions users and groups to Airtable using the Microsoft Entra provisioning service. For important details on what this service does, how it works, and frequently asked questions, see Automate user provisioning and deprovisioning to SaaS applications with Microsoft Entra ID.
Supported capabilities
- Create users in Airtable.
- Remove users in Airtable when they don't require access anymore.
- Keep user attributes synchronized between Microsoft Entra ID and Airtable.
- Provision groups and group memberships in Airtable.
- Single sign-on to Airtable (recommended).
Prerequisites
The scenario outlined in this article assumes that you already have the following prerequisites:
- A Microsoft Entra tenant.
- One of the following roles: Application Administrator, Cloud Application Administrator, or Application Owner.
- An Airtable tenant.
- A user account in Airtable with Admin permissions.
Step 1: Plan your provisioning deployment
- Learn about how the provisioning service works.
- Determine who is in scope for provisioning.
- Determine what data to map between Microsoft Entra ID and Airtable.
Step 2: Create an Airtable Personal Access Token to authorize provisioning with Microsoft Entra ID.
Login to Airtable Developer Hub as an Admin user, and then navigate to
https://airtable.com/create/tokens.Select "Personal Access Tokens" from the left hand navigation bar.
Create a new token with a memorable name such as "AzureAdScimProvisioning".
Add the "enterprise.scim.usersAndGroups:manage" scope.
Select "Create Token" and copy the resulting token for use in Step 5 below.
Step 3: Add Airtable from the Microsoft Entra application gallery
Add Airtable from the Microsoft Entra application gallery to start managing provisioning to Airtable. If you have previously setup Airtable for SSO, you can use the same application. However it's recommended that you create a separate app when testing out the integration initially. Learn more about adding an application from the gallery here.
Step 4: Define who is in scope for provisioning
The Microsoft Entra provisioning service allows you to scope who is provisioned based on assignment to the application, or based on attributes of the user or group. If you choose to scope who is provisioned to your app based on assignment, you can use the steps to assign users and groups to the application. If you choose to scope who is provisioned based solely on attributes of the user or group, you can use a scoping filter.
Start small. Test with a small set of users and groups before rolling out to everyone. When scope for provisioning is set to assigned users and groups, you can control this by assigning one or two users or groups to the app. When scope is set to all users and groups, you can specify an attribute based scoping filter.
If you need extra roles, you can update the application manifest to add new roles.
Step 5: Configure automatic user provisioning to Airtable
This section guides you through the steps to configure the Microsoft Entra provisioning service to create, update, and disable users and/or groups in TestApp based on user and/or group assignments in Microsoft Entra ID.
To configure automatic user provisioning for Airtable in Microsoft Entra ID:
Sign in to the Microsoft Entra admin center as at least a Cloud Application Administrator.
Browse to Entra ID > Enterprise apps
In the applications list, select Airtable.
Select the Provisioning tab.
Set + New configuration.
In the Tenant URL field, input your Airtable Tenant URL and Secret Token. Select Test Connection to ensure Microsoft Entra ID can connect to Airtable. If the connection fails, ensure your Airtable account has the required admin permissions and try again.
Select Create to create your configuration.
Select Properties in the Overview page.
Select the pencil to edit the properties. Enable notification emails and provide an email to receive quarantine emails. Enable accidental deletions prevention. Select Apply to save the changes.
Select Attribute Mapping in the left panel and select users.
Review the user attributes that are synchronized from Microsoft Entra ID to Airtable in the Attribute-Mapping section. The attributes selected as Matching properties are used to match the user accounts in Airtable for update operations. If you choose to change the matching target attribute, you need to ensure that the Airtable API supports filtering users based on that attribute. Select the Save button to commit any changes.
Attribute Type Supported for filtering Required by Airtable userName String ✓ ✓ active Boolean displayName String title String emails[type eq "work"].value String preferredLanguage String name.givenName String ✓ name.familyName String ✓ name.formatted String addresses[type eq "work"].formatted String addresses[type eq "work"].streetAddress String addresses[type eq "work"].locality String addresses[type eq "work"].region String addresses[type eq "work"].postalCode String addresses[type eq "work"].country String phoneNumbers[type eq "work"].value String phoneNumbers[type eq "mobile"].value String phoneNumbers[type eq "fax"].value String externalId String nickName String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:employeeNumber String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:department String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager.value String addresses[type eq "home"].formatted String addresses[type eq "home"].streetAddress String addresses[type eq "home"].locality String addresses[type eq "home"].region String addresses[type eq "home"].postalCode String addresses[type eq "home"].country String addresses[type eq "other"].formatted String addresses[type eq "other"].streetAddress String addresses[type eq "other"].locality String addresses[type eq "other"].region String addresses[type eq "other"].postalCode String addresses[type eq "other"].country String emails[type eq "home"].value String emails[type eq "other"].value String locale String name.honorificPrefix String name.honorificSuffix String name.middleName String name.familyName String phoneNumbers[type eq "home"].value String phoneNumbers[type eq "other"].value String phoneNumbers[type eq "pager"].value String timezone String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:costCenter String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:division String urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:organization String userType String Select Groups.
Review the group attributes that are synchronized from Microsoft Entra ID to Airtable in the Attribute-Mapping section. The attributes selected as Matching properties are used to match the groups in Airtable for update operations. Select the Save button to commit any changes.
Attribute Type Supported for filtering Required by Airtable displayName String ✓ ✓ members Reference To configure scoping filters, refer to the following instructions provided in the Scoping filter article.
Use on-demand provisioning to validate sync with a few users before deploying more broadly in your organization.
When you're ready to provision, select Start Provisioning from the Overview page.
Step 6: Monitor your deployment
Once you configure provisioning, use the following resources to monitor your deployment:
- Use the provisioning logs to determine which users are provisioned successfully or unsuccessfully
- Check the progress bar to see the status of the provisioning cycle and how close it's to completion
- If the provisioning configuration seems to be in an unhealthy state, the application goes into quarantine. Learn more about quarantine states the application provisioning quarantine status article.
More resources
- Managing user account provisioning for Enterprise Apps
- What is application access and single sign-on with Microsoft Entra ID?