Version 23.4.8843

• Establish a Connection
  • ApiKey
  • PersonalAccessToken
• More Information

You can use the Airtable connector from the CData Sync application to capture data from Airtable and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Establish a Connection

To allow Sync to use data from Airtable, you first must establish a connection to Airtable. Follow these steps to connect Airtable to your Sync account:

1. Open the Connections page of the Sync dashboard.

2. Click Add Connection to open the Select Connectors page.

3. Click the Sources tab and locate the Airtable row.

4. Click the Configure Connection icon at the end of that row. If you do not see the Configure Connection icon, you need to add the connector according to the instructions in Connections.

5. Enter connection settings on the Settings tab:

   • Connection Name - Enter a connection name of your choice.

   • Auth Scheme - Select your authentication scheme below to proceed to the relevant section for your scheme. Then fill out the settings as specified in that section.

     • ApiKey
     • PersonalAccessToken
     • OAuthPKCE (The default scheme. This scheme does not require any additional settings. So, you can select this scheme and continue with the settings and steps below.)

     Note: After you fill out the settings for your scheme, return to this section to continue with the remaining settings and steps below.

   • Base Id - Enter your Airtable Base identifier. To locate this value, see Finding Airtable IDs.

   • Enable Metadata API - Select whether you want to enable the Metadata API. The default value is True.

     Note: If you select False, the Base Name property is not available. However, two other properties are displayed that you must define:

     • Table Names - Enter a comma-separated list of table names for the specified base. The list should be in this format: TableA, TableB,…. Supply the table names exactly as they are displayed in the Airtable UI.

     • View Names - Enter a comma-separated list of view names for your tables. The list should be in this format: TableA.ViewA, TableA.ViewB,….

   • Base Name - Enter the schema that you want to use that corresponds to the name of the base in Airtable. This property is available only when the Metadata API is enabled.

   • Display Object Ids - Select whether you want schema, table, view, and column names to be replaced by their corresponding internal identifier. The default value is False.

   • Use Simple Names - Select whether you want simple names to be used for tables and columns. The default value is False.

6. Click Create & Test to create the connection.

7. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

ApiKey

1. For the ApiKey scheme, specify these settings:

   • Api Key - Enter the API key that you use to authenticate to your Airtable account. To generate the key, navigate to your Account page in Airtable. In the API section, click Generate API Key.

   • Client Secret - Enter the unique client secret that you use to authenticate to your Airtable account. This property is required when you authenticate with an API key and you use the Metadata API. The only exception to this requirement is with Enterprise accounts.

2. Complete the remaining steps.

PersonalAccessToken

1. For the PersonalAccessToken scheme, enter your personal access token in the OAuth Access Token field to authenticate to your Airtable account.

2. Complete the remaining steps.

More Information

For more information about interactions between CData Sync and Airtable, see Airtable Connector for CData Sync.