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. Navigate to the Destinations page.

2. Click the New Destination button and select Airtable from the list.

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.