Airtable
Introduction
In this guide we'll walk through the process of linking Cerb to Airtable. You'll be able to use Airtable's full API for any automations you wish to make.
Get a Airtable API key
Log in to your Airtable Account or sign up if you don't already have one.
Click your user icon in the top right and click Builder Hub.
Choose Personal Access Tokens from the left menu and click Create New Token.
Name the token and select any scopes and access bases that are needed. For instance:
data.records:read
schema.bases:read
Click Create token and copy the API key.
Create the Airtable service in Cerb
-
Navigate to Search » Connected Services.
-
Click the (+) icon in the top right of the list.
-
Select Airtable.
-
Paste the key you copied earlier in the API Key field.
-
Click the Create button.
Examples
List bases
https://airtable.com/developers/web/api/list-bases
start:
http.request/listBases:
output: http_response
inputs:
method: GET
url: https://api.airtable.com/v0/meta/bases
authentication: cerb:connected_account:airtable
on_success:
set:
response@json: {{http_response.body}}
http_response@json: null
Get base schema
https://airtable.com/developers/web/api/get-base-schema
start:
set:
baseId: appa1b2c3d4e5f6
http.request/getBaseSchema:
output: http_response
inputs:
method: GET
url: https://api.airtable.com/v0/meta/bases/{{baseId}}/tables
authentication: cerb:connected_account:airtable
on_success:
set:
response@json: {{http_response.body}}
http_response@json: null
List records
https://airtable.com/developers/web/api/list-records
start:
set:
baseId: appa1b2c3d4e5f6
tableIdOrName: Projects
http.request/getRecords:
output: http_response
inputs:
method: GET
url: https://api.airtable.com/v0/{{baseId}}/{{tableIdOrName}}
authentication: cerb:connected_account:airtable
on_success:
set:
response@json: {{http_response.body}}
http_response@json: null