skills.rest
HKU-MMLab
HKU-MMLabOFFICIAL
Explore all skills by this author →
GitHub

airtable-pat-rest

Read Airtable bases, tables, and records via the official REST API using a personal access token.

39|1|Updated Jul 2, 2026
Search Tags:#json#crm#rest api#pagination#airtable#personal access token#read records
One-click install
npx skills add https://github.com/HKU-MMLab/UniClawBench --skill airtable-pat-rest-hku-mmlab
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable-pat-rest
Source: https://github.com/HKU-MMLab/UniClawBench/tree/main/injection/101_skill_usage/task_101_22_airtable_crm/skills/airtable-pat-rest
Command: npx skills add https://github.com/HKU-MMLab/UniClawBench --skill airtable-pat-rest-hku-mmlab

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Accessing Airtable data programmatically often requires setting up OAuth flows or third-party connectors. This Skill reads Airtable records directly through the official REST API using a personal access token already provided as environment variables, removing setup friction. ## Core Features & Use Cases - Direct REST API Access: Queries the Airtable API with a bearer token, no OAuth connection or third-party gateway required. - Automatic Pagination: Iterates through offset-based pagination to retrieve all records from a table, up to 100 per request. - Snapshot Support: Reads a provided snapshot file instead of calling the live API when the task supplies one. - Use Case: Pull every record from a CRM table in Airtable to audit customer entries, then export the results as formatted JSON for downstream analysis. ## Quick Start Read all records from my Airtable table using the configured personal access token and print them as JSON.

Frequently Asked Questions about airtable-pat-rest

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I read Airtable records with the REST API?▼

Send a GET request to https://api.airtable.com/v0/{baseId}/{tableName} with an Authorization header containing your personal access token as a bearer token. The API returns up to 100 records per page along with an offset for pagination.

How to paginate through all records in an Airtable table?▼

Check the offset field in each API response and append it as an offset query parameter to the next request. Repeat until the response contains no offset, which indicates all records have been retrieved.

Does the Airtable API require OAuth for reading records?▼

No, a personal access token is sufficient for reading records. Pass the token as a bearer token in the Authorization header; OAuth is only needed for multi-user third-party integrations.

What environment variables are needed for Airtable API access?▼

You need AIRTABLE_PAT for the bearer token, AIRTABLE_BASE_ID for the target base, and AIRTABLE_TABLE_NAME for the table to query. All three must be set before running the read script.

Why does my Airtable API request return an authentication error?▼

Authentication errors usually mean the personal access token is missing, expired, or lacks read scopes for the target base. Verify the token is set correctly in the AIRTABLE_PAT environment variable and has data.records:read permission.

Related Skills

Explore More Data & Analytics Skills→
abdullahbeamabdullahbeam
2

airtable-connect

Query, create, update, and delete Airtable records via natural language.

Community
Advanced
vctplatformvctplatform

data-engineer

Design and implement data pipelines and reporting for the VCT Platform.

Community
Advanced
seb1nseb1n
147

crm-data-enrichment

Enrich CRM records with firmographic and contact data from external sources.

Community
Advanced
ChangZhou-xjChangZhou-xj

airtable

Automate Airtable REST API CRUD operations, filters, and upserts via curl.

Community
Intermediate