Integration
Airtable
Collaborative database platform
- Category
- APIs
- Runs in
- The Phloem cloud — nothing to install
Lets Hamming read records from an Airtable base live, filtered and sorted as you ask.
What Phloem reads
- Tables and fields — field names and types, select options, and links between tables
- Records — read live, filtered with an Airtable formula, sorted and limited
Read-only.
What you need
- The Base ID (starts with
app, in the base's URL). - An Airtable personal access token with access to that base and these scopes:
data.records:read— requiredschema.bases:read— lets Phloem list the base's tables and fields. Without it, you paste table IDs and Phloem guesses fields from sample records.
Connect
- In the console, open Connectors, choose Add connector, then Airtable.
- Enter Base ID and Personal Access Token.
- Pick the tables. With
schema.bases:read, choose them from the list. Without it, paste Table IDs, one per line (tblXXXXXXXX, from the table's URL), and Phloem checks it can read them. - Name and save the connection.
What Hamming can do
- Query — read records from a table, with an optional formula filter, sort and limit, e.g.
{"table": "Parts", "filter": "AND({Status}='Open')"} - Sample — a few records from a table
Notes
- Connecting stops with a message if the token is invalid, cannot reach the base, or lacks
data.records:read.
#Connection fields
What the Add connector form asks for.
| Field | Type | Required |
|---|---|---|
| Base ID Airtable Base ID (starts with 'app') appXXXXXXXXXXXXXX | Text | Yes |
| Personal Access Token Airtable Personal Access Token | Secret | Yes |
| Table IDs Paste one Table ID per line — find them in the Airtable URL (tblXXXXXXXX). Only shown when your PAT can't list tables itself. tblXXXXXXXX
tblYYYYYYYY | Text | — |
Updated