airtable

1# Airtable
2 
3## Purpose
4Work the user's Airtable: list bases (`bases`), read table records (`records`), and add a record (`create`).
5 
6## Tooling
7All commands go through `bin/airtable.py`:
8 
9```bash
10bin/airtable.py bases                                            # list bases (name, id)
11bin/airtable.py records --base appABC --table "Tasks"            # read records (flattened fields), 10 max
12bin/airtable.py records --base appABC --table "Tasks" --limit 50
13bin/airtable.py create --base appABC --table "Tasks" --fields '{"Name": "Buy milk"}'
14```
15 
16Use `bases` first to resolve a base name to its id (`app...`). The table name is the name shown in the base.
17 
18## Auth
19- Provider id: `airtable` (credential is collected as `custom.airtable`)
20- Collection: personal access token via the secure credential flow (`credentials.request_api_access`): create one at airtable.com/create/tokens with scopes `data.records:read`, `data.records:write`, and `schema.bases:read`, and grant it access to the bases you want to use
21- Connect placement: `bearer_header`
22- Allowed hosts: `api.airtable.com`
23- Status check: `bin/airtable.py bases` (a successful list proves the token works)
24 
25## Operating Rules
261. `create` is a write: confirm the table and field values with the user before running, unless standing permission exists.
272. Reading (`bases`, `records`) needs no confirmation.
28…