Links

Airtable

This page describes how to use Census with Airtable.

🏃‍♀️ Getting Started

In this guide, we will show you how to connect Airtable to Census and create your first sync.

1. Add an Airtable Connection

  1. 1.
    Navigate to the Destinations page.
  2. 2.
    Click the New Destination button and select Airtable from the list.
  3. 3.
    Complete the OAuth flow to connect your Airtable account to Census. As part of the OAuth flow, you'll be able to select the specific workspaces and/or bases you'd like to connect to Census. You can always add more workspaces and/or bases later by clicking the Reauth button on the destination in Census.
Note: Census's permissions will be the same as the Airtable user you used during OAuth. If you think this Airtable user's permissions may change or the account is removed, you may want to create a special Airtable account just for Census to use.
You should now have a connection to Airtable! Let's start syncing data.

🗄 Supported Objects and Behaviors

Airtable support is pretty straight forward!
Object Name
Supported?
Behaviors
Table
Update Only, Update or Create, Mirror
Learn more about all of our sync behaviors on our Core Concepts page.
Airtable needs a primary key that is a short text field for Census to be able to join from a source table (though the source can be a numerical type).

Column types

Airtable Field Types
Source SQL
Short Text
String Numeric
Single Select
String Numeric
Checkbox
Boolean Numeric (nonzero = checked, 0 = unchecked)
Attachments
A structured column of the following structure: [ { "url": "http://path/to/attachment.png" } ]
The Rest
Census will give an informative error
message if rejected by Airtable

🚑 Need help connecting to Airtable?

Contact us via [email protected] or start a conversation with us via the in-app chat.
Last modified 2mo ago