Skip to main content

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 base
  • tableIdOrName (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 it
  • records (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”}}]}
Output: Returns the operation result

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 base
  • tableIdOrName (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 it
  • recordId (TEXT, Required): The unique identifier of the record you want to update, use the Find records action to get it
  • fields (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”}}
Output: Returns the operation result

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
Output: Returns the operation result

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 base
  • tableIdOrName (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 it
  • filterByFormula (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
Output: Returns the operation result

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 base
  • tableIdOrName (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 it
  • recordId (TEXT, Required): The unique identifier of the record to delete, use the Find records action to get it
Output: Returns the operation result