Airtable

Load data from Airtable table.

Airtable Node

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