• Overview
  • Configuration

Related-apps

Airtable

Synchronize user data seamlessly with Airtable and AD integration

Project management Identity provisioning

Airtable is a platform that helps business functions to build and share relational databases. By integrating Airtable to ADManager Plus organizations can synchronize and manage user provisioning changes across their AD and other connected systems. For instance if a user is created in Airtable, ADManager Plus' workflows enable IT teams to synchronize these user creation changes across AD, Exchange, Microsoft 365 and other integrated applications, and vice versa.

 

Automated user provisioning and updates

When a new user is created or an existing user is updated in Airtable, ADManager Plus workflows automatically propagate these changes across AD, Exchange, Microsoft 365, and other integrated applications. This ensures that user accounts are consistently managed and up-to-date across all systems, eliminating the need for manual intervention.

 

Bi-directional workflow automation

ADManager Plus not only pushes updates from Airtable to AD and other systems, but also pulls changes from AD back into Airtable, ensuring that both platforms remain in sync. This bidirectional flow of data helps maintain consistency and accuracy across your entire IT environment.

 

Configuration Document: Integrating Airtable with ADManager Plus

Prerequisites

Airtable uses OAuth 2.0 to authorize API requests.

It requires a BaseId and TableId for authorization.

Privileges

To import users (inbound action): Ensure the account used for authorization has permission to read all user accounts.

To perform any action or query in Airtable (outbound action): Ensure the account used for authorization has permission to perform the desired action.

Note: ADManager Plus comes with preconfigured set of APIs that help perform basic actions with the integration. If the action you require is not available, please gather the necessary API details from Airtable's API documentation to configure inbound or outbound webhooks to perform the required actions.

Authorization configuration

  • Log in to ADManager Plus and navigate to the Automation tab.
  • In the left pane, under Configuration, click Application Integrations.
  • Under Enterprise Applications, click Airtable.
  • Toggle the Enable Airtable Integration button on.
  • On the Airtable Configuration page, click Authorization.
  • Perform the steps to generate a BaseId and TableId from Airtable, and paste them in the respective value fields.
  • Click Configure.

Inbound webhook configuration

Inbound webhooks enable you to fetch user data from Airtable and send it to ADManager Plus. The attribute mapping configured in this section can be selected as the data source during automation configuration. To configure an inbound webhook for Airtable:

  • Under Inbound Webhook, click Airtable Endpoint Configuration.
  • In the Endpoint Configuration tab, an endpoint, Airtable USERS ENDPOINT, comes preconfigured with Endpoint URL, API Method, Headers, and Parameters fields to fetch user accounts from Airtable. If you would like to use this preconfigured endpoint, replace {BaseId} with the domain name of your Airtable instance in the Endpoint URL field. However, if you would like to use a new endpoint to import users, you can configure one using the + Add API endpoint button and filling in the required fields as per Airtable's API documentation. Click here to learn how.

    • Note:

    • The API key value pair is preconfigured as a header for authenticating API requests as configured during authorization configuration.
    • Ma cros: You can add macros to your endpoint configuration to dynamically change it as per your requirement using the macro chooser component
    • Refer to Airtable's API documentation and configure additional headers and parameters, if required. In the Settin gs tab, the Repeat calling this endpoint option will be configured to fetch 30 records per call. This will be repeated until no next page token is received.
  • Once done, click Test & Save. A response window will display all the requested parameters that can be fetched using the API call. After verifying if the requested parameters have been called to action, click Proceed.

    • Note:

    • Refer to Airtable's API documentation to learn about the parameters that must be configured to fetch only specific parameters.
    • You can configure multiple endpoints for Airtable using the + Add API endpoint button. Click here to learn how.
  • Click Data Source - LDAP Attribute Mapping to match endpoints and to map AD LDAP attributes with the respective attributes in Airtable.
  • Click + Add New Configuration and perform the following actions:
    • Enter the Configuration Name and Description, and select the Automation Category from the drop-down menu.
    • In the Select Endpoint field, select the desired endpoint and a Primary Key that is unique to a user (for example, employeeIdentifier).

    • Note: When multiple endpoints are configured, this attribute must hold the same value in all the endpoints.

    • In the Attribute Mapping field, select the attribute from the LDAP Attribute Name drop-down menu and map it with the respective attribute in Airtable.
    • If you would like to create a new custom format for this, click Add New Format.
    • Click Save.

Outbound webhook configuration

Outbound webhooks enable you to send changes made in AD to Airtable, fetch data from Airtable, and carry out tasks in Airtable—all from ADManager Plus. The webhooks configured in this section can be included in Orchestration Templates, which in turn can be used during event-driven and scheduled automations. They can also be applied directly to desired users to perform a sequence of actions on them (Management > Advanced Management > Orchestration).

To configure outbound webhooks for Airtable:

  • Under Outbound Webhook, click Airtable Webhook Configuration.
  • Click + Add Webhook.
  • Enter a name and description for this webhook.
  • Decide on the action that has to be performed and refer to Airtable's API documentation for the API details, such as URL, headers, and parameters.
  • Select the HTTP method that will enable you to perform the desired action on the endpoint from the drop-down menu.
  • Enter the endpoint URL.
  • Configure the Headers, Parameters, and Message Type in the appropriate format based on the API call that you would like to perform.
  • Click Test and Save.
  • A pop-up window will then display a list of AD users and groups to test the configured API call. Select the desired user or group over which this API request has to be tested and click OK. This will make a real-time call to the endpoint URL, and the selected objects will be modified as per the configuration.
  • The webhook response and request details will then be displayed. Verify them for the expected API behavior and click Save.