Capability library / Application package

Airtable package v1.0.0

Airtable Web API on the customer's bases: list records (GET and the long-query POST form), create records, update records with PATCH, and delete records.

Review state: Reviewed · Distributable: yes, digest matches the release manifest

This page describes AAES Govern’s controls. AAES Operate has private-work permissions, operational reviews and recorded-spend limits; it does not include Govern. About AAES Govern

Before you enable this package

The endpoint host 'airtable-api.invalid' is a reserved .invalid placeholder that fails closed until you substitute the real host in both the endpoint URLs and the egress allowlist.

Read each action's effects and exclusions below. Before installation, also read the complete package requirements, including credential issuance, scope, expiry, and provider permissions. These are deployment prerequisites, not capabilities this package supplies.

Capabilities (5)

Each capability below is one registered operation. The complete package JSON includes its exact network destination allowlist. The repository stores it at packs/airtable.json and embeds a copy in the release binary.

Risk tiers. R0 is the minimum for reads. R2 is the minimum for write, create, update, execute, and invoke. R3 is the minimum for delete, send, pay, deploy, approve, share, and transfer. Operators can raise these levels. A minimum tier does not measure the operation's business or confidentiality risk.

On supported execution paths routed through AAES Govern, the R3 actions listed below require approval by an authorized person. Bypass paths and observation-only registrations are outside that guarantee. A provider's restoration feature does not remove this approval requirement. A provider-side approval, such as approving a GitLab merge request, is also separate from AAES Govern human approval. The capability matrix shows which execution paths are implemented, restricted to lab use, or refused at startup. Live compatibility must be tested in your environment.

Field guide. Endpoint is the service address and request method. Connector is the adapter that makes the call. Custody describes how the credential is held; the credential reference identifies the value to resolve. Data class sets handling requirements: pii means personal data, financial means financial records, and internal means internal organizational data.

airtable.records.read v1.0.0R0

Kind
tool
Action
read
Endpoint
GET https://airtable-api.invalid/v0/BASE_ID/TABLE_ID_OR_NAME
Connector
http
Custody
customer_vault
Credential ref
secret-ref-airtable-token
Data class
pii

Read records.

List records in one table as a collection read. The retrieved documentation states results are paginated by offset (default page of 100), that empty-valued fields are omitted from returned records, and that the GET form is limited to URLs under 16,000 characters — longer filter formulas must use the registered POST form instead. Table records frequently describe people, so the read is classified as pii (personal data); declare internal only after the owner classifies the base.

airtable.records.search v1.0.0R0

Kind
tool
Action
read
Endpoint
POST https://airtable-api.invalid/v0/BASE_ID/TABLE_ID_OR_NAME/listRecords
Connector
http
Custody
customer_vault
Credential ref
secret-ref-airtable-token
Data class
pii

Search records.

The POST form of list records, registered read-only at the read floor: the reviewed documentation prescribes it when encoded filter formulas would exceed the GET URL length limit, passing the same parameters in the request body instead of the query string. Body shape mirrors the GET parameters — filterByFormula, fields, sort, view, pageSize, maxRecords and offset. The registration does not restrict the body; the endpoint performs no write.

airtable.records.create v1.0.0R2

Kind
tool
Action
create
Endpoint
POST https://airtable-api.invalid/v0/BASE_ID/TABLE_ID_OR_NAME
Connector
http
Custody
customer_vault
Credential ref
secret-ref-airtable-token
Data class
pii

Create records.

Create one or more records in one table: the reviewed documentation states the body carries either a single fields object or a records array, with an optional typecast flag for best-effort type conversion (disabled by default to protect data integrity). Created records can later be deleted, so create sits at the minimum R2 tier for reversible writes; the registration does not restrict which fields a request may carry.

airtable.records.update v1.0.0R2

Kind
tool
Action
update
Endpoint
PATCH https://airtable-api.invalid/v0/BASE_ID/TABLE_ID_OR_NAME/RECORD_ID
Connector
http
Custody
customer_vault
Credential ref
secret-ref-airtable-token
Data class
pii

Update records.

Update one record: the reviewed documentation states PATCH updates only the fields specified and leaves the rest unchanged. The PUT form is deliberately not registered — the documentation states it performs a destructive update clearing all unspecified cell values, and the method restriction is one the registration actually enforces. Overwritten cell values are not recoverable through this API; update sits at the minimum R2 tier as the vocabulary's reversible-write tier and policy can raise it for sensitive bases. RECORD_ID is a placeholder the deployment binds before enabling.

airtable.records.delete v1.0.0R3

Kind
tool
Action
delete
Endpoint
DELETE https://airtable-api.invalid/v0/BASE_ID/TABLE_ID_OR_NAME
Connector
http
Custody
customer_vault
Credential ref
secret-ref-airtable-token
Data class
pii

Delete records.

Delete records from one table. The delete-multiple-records reference page (retrieved 2026-09-21) establishes the operation: DELETE on the table path with one records[] query parameter per record id. The retrieved page content did not show the operation's per-call batch limit, so this registration makes no batch-limit claim. Delete is one of the designated actions requiring human approval.

On supported execution paths mediated by AAES Govern, irreversible actions require approval by an authorized person; this does not prevent calls through bypass or observation-only paths; deleted records are not restorable through this endpoint and this pack makes no general-reversibility claim.

Credential reference

The credential field names a reference rather than containing credential material. Packs are designed not to contain secrets; the format checks cover only known credential formats and cannot prove that arbitrary text contains no secrets. Installing a package registers its capabilities. Configure the provider credentials, endpoints, and network access, then test the integration in your environment before enabling it.

Reference
secret-ref-airtable-token
Custody
customer_vault
Injection
header (Authorization)

Configure the value and injection format specified in the package. Assign responsibility for credential rotation and revocation, restrict provider permissions, and keep credential material out of logs and responses.

Complete credential requirements

An Airtable account-issued bearer token (a personal access token with scopes chosen at creation) for the customer's account, held in the client's own secret manager. The stored material must be the complete Authorization header value: the scheme 'Bearer', one separating space, then the token — 'Bearer <token>'. The token-issuance process is external: a person creates the token in the Airtable account's developer hub, selects scopes (for this pack, record read and record write on the specific bases the capabilities touch — the minimum that makes the capabilities work, nothing more) and hands the value to the vault; AAES creates nothing.

The authentication reference page was retrieved on 2026-09-21: it documents the two supported token types (personal access tokens and OAuth access tokens), that passing tokens via the legacy api_key URL parameter is not supported, and that scopes and base/workspace resources are configured at token creation — but it does not state token expiry behaviour, how a token is revoked in the developer hub, or whether editing scopes or disabling issuance invalidates already-issued tokens.

The deployment must therefore confirm before enabling: expiry behaviour (if any), the revocation path, and invalidation-on-edit behaviour — until confirmed, treat disabling issuance as not invalidating already-issued tokens and rotate by revoking the old value explicitly; a revoked or rejected value fails closed.

Executor hygiene: the value must live only in executor memory for the lifetime of a call, must never be written to logs, traces or diagnostics, and must not appear in crash dumps; a deployment that cannot meet that bar must not enable the pack.

Resources

  • airtable-base (table, pii): https://airtable-api.invalid/v0/BASE_ID

Technical package and review record

Complete provider requirements and exclusions

The endpoint host 'airtable-api.invalid' is a reserved non-production placeholder (an RFC 2606 reserved TLD): substitute the real Airtable API host before enabling, in every endpoint, in the resource locator and in every egress allowlist entry — the reviewed documentation names the base path https://api.airtable.com/v0. The allowlist matches exactly, so endpoints and allowlist must be substituted together, and substitution is a required deployment step. BASE_ID, TABLE_ID_OR_NAME and RECORD_ID in the endpoint paths are placeholders the deployment binds before enabling; the reviewed documentation recommends table IDs over names so a table rename does not silently redirect a registration.

Documented exclusions: this pack does not register the meta API — base, table and field schema management (creating or deleting bases or tables, altering field definitions) — webhook management, and enterprise and user administration. This pack does not register public-link or view-sharing operations. Attachment acknowledgment: excluding a separate attachment-upload operation does not exclude attachment effects — the registered airtable.records.create and airtable.records.update carry unrestricted record bodies, and Airtable attachment fields accept attachment objects by URL supplied in an ordinary record write, so a record write can attach externally-hosted files to a base; that effect is in scope of the two registered write capabilities and policy must review it there.

The PUT update form is also deliberately not registered: the retrieved update documentation states a PUT performs a destructive update that clears all unspecified cell values, while PATCH updates only the fields specified — only PATCH is registered, and because the restriction is the registered method (not caller intent about a body) it is a real restriction AAES enforces.

The delete-multiple-records reference page was retrieved on 2026-09-21 and establishes the method, path and records[] query-parameter form; the retrieved page content did not show the per-call batch limit, so the completed review makes no batch-limit claim (see the capability description); the same review found token expiry/revocation behaviour unestablished in the retrieved authentication reference — the cut-off path is deleting the token in the Airtable account, and this pack makes no stronger claim.

Both gaps are documented findings of the completed review, not blockers. The Airtable authentication reference page was retrieved on 2026-09-21 and covers token types, the unsupported legacy api_key parameter, and scope/resource configuration, but not expiry or revocation behaviour; the credential note records what must still be confirmed before enabling.

Download the complete package JSON for exact network allowlists, credential requirements, exclusions, and setup notes. Read these requirements before installation.

The full documentation review record is supplied in the evaluation package. The evaluation package runs in your environment and comes only with the paid design partnership. This page reproduces the source links and review block; the full record is available for evaluation. Discuss a design partnership to inspect it before installation.

Review block

This section reproduces the review block recorded in the pack file. The evidence and approval record is separate: for a reviewed pack, it is in the evaluation materials and in the release binary's embedded assets.

Review completed: 2026-09-23

6 sources, retrieved 2026-09-21

Current documentation links are navigation aids. They do not change the package, its historical sources or its review date. Review dates describe a documentation review, not a live integration test. No package is provider-endorsed or yet tested against a live provider tenant.

Release identity

SHA-256 of the pack file bytes: a04b9c8c5e31ac83fb415d4a5ffc5970fe2a021115c36b2bbb10181835fd965c

Distributable: yes, digest matches the release manifest. Editing a package changes its release identity. A deployment plan checks its own file digests; it does not restore reviewed status or authenticate approval.