Curiosity

Airtable

Ingests records from an Airtable base. The connector introspects the first batch of records, derives a typed schema (string / int / float / bool / list), and creates a node type per table on demand.

variant=info text="CRM / business apps" variant=secondary text="API key"

What gets ingested

Element Mapped to
Table A node type (<TableName> — dynamic)
Record An instance of that node type, keyed by Airtable record ID
Cell value Property on the node (typed from the first 100 records)
Linked record Edge to the target table's node

Authentication

  • Type: Airtable API key (a workspace-level token).
  • The connector stores the API key encrypted.

Access control mapping

  • Workspace-configured PermissionsSetting (users + access groups) is applied to every ingested record. Per-base ACLs from Airtable are not enumerated.

Sync cadence

  • Default cron: 0 23 * * * (daily at 23:00 UTC).
  • Incremental sync: offset pagination through the Airtable API. The schema is re-validated on each run; new columns become new properties.

Notable

  • Dynamic schema means you can ingest any Airtable base without writing C# code — but if the base has a field that mixes types across records, the connector will pick a string fallback.