List Records

Retrieves records from a table with optional filtering, sorting, and pagination. Use filterByFormula for complex queries. Returns up to 100 records per page.

MethodGET
Parameters10 parameters
CategoryRecords
Airtable Logo

Action

List Records

Input & Output Details

A clear overview of the data fields required to trigger List Records action and the information you'll receive in return.

Input Fields

baseId
Required
string
baseId

The unique identifier for the Airtable base (starts with "app"). Found in the base URL.

tableIdOrName
Required
string
tableIdOrName

The ID (starts with "tbl") or name of the table. Table IDs are recommended for stability.

pageSize
integer
pageSize

Number of records per page (1-100, default: 100)

offset
string
offset

Offset cursor for pagination from previous response

maxRecords
integer
maxRecords

Maximum total number of records to return

filterByFormula
string
filterByFormula

Airtable formula to filter records (e.g., "{Status} = 'Done'"). See Airtable formula reference.

sort
array
sort

Array of sort specifications

view
string
view

View ID or name to use for filtering and sorting

cellFormat
string
cellFormat

Cell value format: json (default) or string

returnFieldsByFieldId
boolean
returnFieldsByFieldId

If true, field values are keyed by field ID instead of name

Output Fields

No output fields Required

This action doesn't require any specific output parameters to function.

More Actions from Airtable

Explore the powerful actions available for Airtable

All Actions

Get Current User

Action

Retrieves the current user ID and scopes. Returns email if the token has user.email:read scope.

Create Base

Action

Creates a new Airtable base in a specified workspace with the provided tables and fields. At least one table with one field is required.

List Bases

Action

Retrieves a list of all Airtable bases the integration has access to. Returns up to 1000 bases per page with pagination support.

List Comments

Action

Retrieves all comments on a specific record, ordered from newest to oldest. Includes author info, timestamps, and threaded reply information.

Delete Webhook

Action

Deletes a webhook from a base. The webhook will stop receiving notifications immediately.

Delete Record

Action

Permanently deletes a single record from a table. This action cannot be undone.

List Webhooks

Action

Retrieves all webhooks configured for a base. Shows webhook status, specification, and expiration times.

Get Base Schema

Action

Retrieves the schema of all tables in a base, including field definitions, views, and primary field IDs. Essential for understanding base structure.

Create Comment

Action

Adds a new comment to a record. Supports @mentions using @[userId] format. Comments are visible to all collaborators with record access.

Update Records

Action

Updates up to 10 records with partial updates (only specified fields are changed). Each record needs an ID and the fields to update.

Learn More about Airtable

Airtable integration for managing bases, tables, records, and comments. Enables creating, reading, updating, and deleting data in Airtable workspaces.

Airtable Logo

FAQs about Airtable integration

Connect Other Integrations

Explore more tools and services you can connect with Integrations

AddressZen logo

AddressZen

Address lookup, verification, and validation service for USA, UK, Canada, Ireland, and Australia. Provides real-time address autocomplete, postcode lookup, and address verification APIs.

Analytics & Reports
AgentMail logo

AgentMail

API platform providing AI agents with email inboxes to send, receive, and act upon emails for communication with services, people, and other agents.

Email & Messaging
AI/ML API logo

AI/ML API

Unified API for accessing 100+ AI/ML models including GPT-4, Claude, Stable Diffusion, DALL-E, and more. Supports text generation, image creation, video generation, embeddings, and audio transcription.

AI & Developer Tools
Amdoren API logo

Amdoren API

Access weather forecasts, currency conversion, timezone information, time conversion, and location data. Supports 5-day weather forecasts, 150+ currencies, and worldwide timezone conversions.

Anchor Browser logo

Anchor Browser

Browser automation platform for managing profiles, sessions, and automated browsing tasks.

AI & Developer Tools
Automation & Workflows
AnyAPI logo

AnyAPI

Access 13+ APIs through a single platform: email validation, currency exchange, holidays, IBAN/VAT validation, IP geolocation, phone validation, web scraping, screenshots, sentiment analysis, and more.

Custom APIs & Webhooks
AI & Developer Tools
API Ninjas logo

API Ninjas

Access 50+ APIs for data and utilities including jokes, facts, quotes, weather, nutrition, city data, QR codes, barcodes, trivia, and more. All through a single API key.

AI & Developer Tools
ApiFlash logo

ApiFlash

Simple yet powerful screenshot API for capturing pixel-perfect website screenshots at scale. Built on AWS Lambda with up-to-date Chrome browser.

AI & Developer Tools
Art Search logo

Art Search

Search and discover artworks from a vast collection using semantic AI. Filter by type, material, technique, creation date, and origin. Retrieve detailed artwork information with historical context.

Creativity & Design

How Platoona Works

Build, Automate & Scale — In One Smart Workspace.

Agents assemble & collaborate
The right specialists come together automatically — Writer, Researcher, CMO, CTO, Ops — working as a real team.

Start Working with Agents

Tell Platoona what you need
Just chat normally. Your Platoona Agents understand your goal instantly and know what outcome you're aiming for.

Start Your Journey

Marketplace of Agents, Integrations & Flows
Explore ready-made agents, tools, and automation flows created by the community and the Platoona team.

Explore Marketplace

Connect with 250+ integrations
Tools like Slack, Notion, Gmail, HubSpot, Twilio, Drive, and more — all connected so agents can act directly.

Connect Your Tools

Set up workflows & automation
Create recurring tasks and automated workflows. Your AI platoon runs them on schedule or trigger, keeping work flowing without your constant input.

Automate Your Workflow

Works With the Tools You Already Use.

Connect Slack, Gmail, Notion, HubSpot, Sheets, GitHub, and 250+ more apps.

Google
Notion
Slack
Gmail
Google Forms
Instagram
LinkedIn
Linear
GitHub
Facebook
Google
Notion
Slack
Gmail
Google Forms
Instagram
LinkedIn
Linear
GitHub
Facebook
Todoist
WhatsApp
Youtube
Google Sheets
Calendly
Discord
Zoom
Figma
X
Jira
Todoist
WhatsApp
Youtube
Google Sheets
Calendly
Discord
Zoom
Figma
X
Jira

Ready to transform how you work?

Join thousands of early adopters shaping the future of AI-powered workspaces.

Get Started