description: Load data from Airtable table.

Airtable

Airtable is a cloud collaboration service that combines the functionality of a spreadsheet with a database. This module provides comprehensive functionality to load and process data from Airtable tables.

This module provides a sophisticated Airtable document loader that can:

• Load data from specific Airtable bases, tables, and views
• Filter and select specific fields
• Handle pagination and large datasets
• Support custom filtering with formulas
• Process data with text splitters
• Customize metadata extraction

Inputs

Required Parameters

• Base Id: The Airtable base identifier (e.g., app11RobdGoX0YNsC)
• Table Id: The specific table identifier (e.g., tblJdmvbrgizbYICO)
• Connect Credential: Airtable API credentials

Optional Parameters

• View Id: Specific view identifier (e.g., viw9UrP77Id0CE4ee)
• Text Splitter: A text splitter to process the extracted content
• Include Only Fields: Comma-separated list of field names or IDs to include
• Return All: Whether to return all results (default: true)
• Limit: Number of results to return when Return All is false (default: 100)
• Filter By Formula: Airtable formula to filter records
• Additional Metadata: JSON object with additional metadata
• Omit Metadata Keys: Comma-separated list of metadata keys to omit

Outputs

• Document: Array of document objects containing metadata and pageContent
• Text: Concatenated string from pageContent of documents

Features

• API-based data retrieval
• Field selection and filtering
• Pagination support
• Formula-based filtering
• Customizable metadata handling
• Text splitting capabilities
• Error handling for invalid inputs

Notes

• Requires valid Airtable API credentials
• Base ID and Table ID are mandatory
• Field names containing commas should use field IDs instead
• Filter formulas must follow Airtable formula syntax
• Rate limiting and API quotas apply
• Supports both full and partial data retrieval

URL Structure Example

For a table URL like:

https://airtable.com/app11RobdGoX0YNsC/tblJdmvbrgizbYICO/viw9UrP77Id0CE4ee

• Base ID: app11RobdGoX0YNsC
• Table ID: tblJdmvbrgizbYICO
• View ID: viw9UrP77Id0CE4ee

{% hint style="info" %} This section is a work in progress. We appreciate any help you can provide in completing this section. Please check our Contribution Guide to get started. {% endhint %}