Airtable
Askel connects to your customer's Airtable workspace, letting your product read and write records across bases and tables in the structured, relational format that Airtable customers already use to run their operations.
What you can do
Create records in any table
Use the Airtable records endpoint to insert new rows, populating single-line text, number, date, select, checkbox, linked record, and attachment fields.
Read and filter records
List records with a filterByFormula expression to retrieve only the rows that match your criteria, reducing data transferred and processing time.
Update fields on existing records
PATCH individual records by record ID to update specific fields without overwriting the entire row, preserving values set by the customer's team.
Delete records
Remove records by ID, useful for archiving entries that your product has fully processed or replacing soft-delete patterns the customer uses.
Read table and field schema
Fetch the table and field metadata via the Airtable Meta API to discover field types and options at connect time, powering accurate field-mapping suggestions.
Upload attachments to records
Post file URLs to attachment fields on a record, which Airtable fetches and stores. Useful for linking PDFs, images, or exports generated by your product.
Writing project completion data into a customer's Airtable operations base
You sell a project delivery tool. Lakeview Consulting tracks all client projects in an Airtable base called Client Delivery. When your product marks a project as complete, the corresponding Airtable record should be updated with the completion date, hours logged, and final status.
- 1
Generate a Personal Access Token
Lakeview's Airtable admin goes to airtable.com/create/tokens, creates a token with data.records:read and data.records:write scopes on the Client Delivery base, and pastes it into your product.
- 2
Discover the table schema
Askel calls the Meta API to read the Client Delivery table's fields: project name, client, status, completion date, and hours logged. A mapping draft appears immediately.
- 3
Match records by project ID
Askel uses filterByFormula to find the Airtable record whose Project ID field matches the completed project. This avoids creating duplicates.
- 4
Update the record
Askel PATCHes the found record with the completion date, hours logged, and a status field value of Completed. Only those three fields are touched.
- 5
Log the write
Askel records the Airtable record ID and update timestamp in your product's audit log. If Lakeview's team questions the data, your CS rep can trace the exact operation.
API token
The customer generates a Personal Access Token from airtable.com/create/tokens, scoping it to the specific bases and permission levels needed. Askel stores the token securely. Personal Access Tokens support granular per-base scoping, so customers can grant access only to the bases relevant to your product without exposing their entire workspace.
How Askel sits between your product and the customer's system
FAQ for Airtable
Which Airtable plans include API access?+
What are the API rate limits?+
Can we work with linked record fields?+
What happens if the customer restructures their base?+
catching drift before it breaks, and hitting go-live dates.
© 2025 Askel.ai. All rights reserved.