Airtable Import

The “Import from Airtable” script template (template ID 314413) imports data from the Airtable Web API’s “list records” endpoint.

Parameters

• Airtable API Key (required): A platform custom credential whose “password” field contains an Airtable Personal Access Token (https://airtable.com/create/tokens). The “username” field isn’t used and is ignored (you may enter your email address here).
• Airtable Base ID (required): The Airtable base ID (e.g., appXXXXXXXXXXXXXX), found in the base URL.
• Airtable Table ID or Name (required): The table ID (e.g., tblXXXXXXXXXXXXXX) or table name to import. Using the table ID is recommended so the import is not affected by table renames.
• Database (required): The Civis Platform database to which to write records.
• Database Credential (required): A valid database credential for the Civis Platform database. To use the credential associated with the logged-in user, choose from the dropdown the credential that has this user’s Civis Platform username.
• Schema and Tablename (required): The schema and table name you would like to import the data into, e.g., schema.table.
• Column Data Type Overrides (optional): A mapping from column names to data types to use instead of the data types from the data source. Each line should be in the form of "column_name: DATA_TYPE" (without quotes), e.g., "foo_bar: VARCHAR". Only provide an entry for columns for which you want to override the data type; do not provide entries for columns that should use the default data type from the data source. This parameter is useful for data type issues that would otherwise cause the import to fail, e.g., use "foobar: VARCHAR" if the data source says "foobar" should be a numeric type but it actually contains non-numeric values.
• Existing Table Exists (optional): The action to take if a table with the requested name already exists. Options are:
  • Append: Records will be appended to the existing table
  • Fail: The sync job fails if the table exists
  • Drop: Removes the entire table including column information.
  • Truncate: Records on the table will be wiped out while maintaining the current columns.