Overview
Database solution combining spreadsheet simplicity with powerful database capabilities. Through Langdock’s integration, you can access and manage Airtable directly from your conversations.Authentication: OAuth
Category: Productivity & Collaboration
Availability: All workspace plans
Available Actions
Create records
airtable.create_records
Creates one or more new records in a table
Requires Confirmation: Yes
Parameters:
baseId(TEXT, Required): The unique identifier of the base where records will be created, use the List bases action to find the basetableIdOrName(TEXT, Required): The table ID or table name where records will be created. Table ID and name can be used interchangeably but prefer using the table ID if possible, use the Get base schema action to find itrecords(OBJECT, Required): The records to create as an array. Each record must have a fields object. Example: {“records”: [{“fields”: {“Name”: “John”, “Email”: “john@example.com”}}, {“fields”: {“Name”: “Jane”, “Email”: “jane@example.com”}}]}
Update records
airtable.update_records
Updates a record in a table
Requires Confirmation: Yes
Parameters:
baseId(TEXT, Required): The unique identifier of the base containing the record, use the List bases action to find the basetableIdOrName(TEXT, Required): The table ID or table name of the table containing the record. Table ID and name can be used interchangeably but prefer using the table ID if possible, use the Get base schema action to find itrecordId(TEXT, Required): The unique identifier of the record you want to update, use the Find records action to get itfields(OBJECT, Required): The fields you want to update with their new values. Only include fields that should be changed. Example: {“fields”: {“Status”: “Completed”, “Notes”: “Updated via API”}}
List bases
airtable.list_bases
Lists all available bases the user has access to
Requires Confirmation: No
Parameters: None
Output: Returns the operation result
Get base schema
airtable.get_base_schema
Returns the schema of all tables in the specified base including fields and views
Requires Confirmation: No
Parameters:
baseId(TEXT, Required): The unique identifier of the base to retrieve the schema from, use the List bases action to find the base
Find records
airtable.find_records
Finds records in a table with optional filtering
Requires Confirmation: No
Parameters:
baseId(TEXT, Required): The unique identifier of the base containing the table, use the List bases action to find the basetableIdOrName(TEXT, Required): The table ID or table name to search for records. Table ID and name can be used interchangeably but prefer using the table ID if possible, use the Get base schema action to find itfilterByFormula(TEXT, Optional): Optional Airtable formula to filter records. Examples: {Status} = ‘Active’ for text matching, {Age} > 25 for numeric comparisons, IS_AFTER({CreatedDate}, ‘2023-01-01’) for dates, FIND(‘urgent’, {Description}) for text search, AND({Status} = ‘Active’, {Priority} = ‘High’) for multiple …limit(NUMBER, Optional): Maximum number of records to return. Defaults to 100 if not specified
Delete record
airtable.delete_record
Deletes a record from a table
Requires Confirmation: Yes
Parameters:
baseId(TEXT, Required): The unique identifier of the base containing the record, use the List bases action to find the basetableIdOrName(TEXT, Required): The table ID or table name containing the record. Table ID and name can be used interchangeably but prefer using the table ID if possible, use the Get base schema action to find itrecordId(TEXT, Required): The unique identifier of the record to delete, use the Find records action to get it