Tools

Airtable

Learn how to use Airtable with Composio

Overview

Enum

AIRTABLE

Description

Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management

Authentication Details

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
stringDefaults to https://backend.composio.dev/api/v1/auth-apps/add
scopes
stringDefaults to data.records:read,data.records:write,data.recordComments:read,data.recordComments:write,schema.bases:read,schema.bases:write,user.email:read
token
stringRequired
api_key
stringRequired

Actions

Retrieves all airtable bases accessible to the authenticated user, which may include an 'offset' for pagination.

Action Parameters

Action Response

data
object
error
successful
boolean
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.

Action Parameters

name
stringRequired
tables
arrayRequired
workspaceId
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new comment on a specific record within an airtable base and table.

Action Parameters

baseId
stringRequired
recordId
stringRequired
tableIdOrName
stringRequired
text
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new field within a specified table in an airtable base.

Action Parameters

baseId
stringRequired
description
string
name
stringRequired
options
object
tableId
stringRequired
type
stringDefaults to singleLineText

Action Response

data
object
error
successful
boolean
Creates multiple new records in a specified airtable table.

Action Parameters

baseId
stringRequired
records
arrayRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new record in a specified airtable table; field values must conform to the table's column types.

Action Parameters

baseId
stringRequired
fields
objectRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.

Action Parameters

baseId
stringRequired
description
string
fields
arrayRequired
name
stringRequired

Action Response

data
object
error
successful
boolean
Deletes an existing comment from a specified record in an airtable table.

Action Parameters

baseId
stringRequired
recordId
stringRequired
rowCommentId
stringRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Deletes up to 10 specified records from a table within an airtable base.

Action Parameters

baseId
stringRequired
recordIds
arrayRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Permanently deletes a specific record from an existing table within an existing airtable base.

Action Parameters

baseId
stringRequired
recordId
stringRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves the detailed schema for a specified airtable base, including its tables, fields, field types, and configurations, using the `baseid`.

Action Parameters

baseId
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves a specific record from a table within an airtable base.

Action Parameters

baseId
stringRequired
cellFormat
stringDefaults to json
recordId
stringRequired
returnFieldsByFieldId
boolean
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves information, such as id and permission scopes, for the currently authenticated airtable user from the `/meta/whoami` endpoint.

Action Parameters

Action Response

data
object
error
successful
boolean
Retrieves all comments for a specific record in an airtable table, requiring existing `baseid`, `tableidorname`, and `recordid`.

Action Parameters

baseId
stringRequired
recordId
stringRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.

Action Parameters

baseId
stringRequired
cellFormat
stringDefaults to json
fields
array
filterByFormula
string
maxRecords
integer
offset
string
pageSize
integerDefaults to 100
recordMetadata
array
returnFieldsByFieldId
boolean
sort
array
tableIdOrName
stringRequired
timeZone
stringDefaults to utc
userLocale
string
view
string

Action Response

data
object
error
successful
boolean
Updates multiple existing records in a specified airtable table; these updates are not performed atomically.

Action Parameters

baseId
stringRequired
records
arrayRequired
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean
Modifies specified fields of an existing record in an airtable base and table; the base, table, and record must exist.

Action Parameters

baseId
stringRequired
fields
objectRequired
recordId
stringRequired
returnFieldsByFieldId
boolean
tableIdOrName
stringRequired

Action Response

data
object
error
successful
boolean