Airtable

Airtable is a user-friendly and flexible cloud-based database management tool.

Categories: productivity-and-collaboration

Type: airtable/v1

---

Connections

Version: 1

Bearer Token

Properties

Name	Label	Type	Description	Required
token	Token	STRING		true

---

Actions

Create Record

Name: createRecord

Adds a record into an Airtable table.

Properties

Name	Label	Type	Description	Required
baseId	Base ID	STRING	ID of the base where table is located.	true
tableId	Table ID	STRING Depends On baseId	The table where the record will be created.	true
fields		DYNAMIC_PROPERTIES Depends On baseId, tableId		false

Example JSON Structure

{
  "label" : "Create Record",
  "name" : "createRecord",
  "parameters" : {
    "baseId" : "",
    "tableId" : "",
    "fields" : { }
  },
  "type" : "airtable/v1/createRecord"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Delete Record

Name: deleteRecord

Deletes a single record from a table.

Properties

Name	Label	Type	Description	Required
baseId	Base ID	STRING	ID of the base where table is located.	true
tableId	Table ID	STRING Depends On baseId	ID of the table where the record is located.	true
recordId	Record ID	STRING Depends On tableId, baseId	ID of the record that will be deleted.	true

Example JSON Structure

{
  "label" : "Delete Record",
  "name" : "deleteRecord",
  "parameters" : {
    "baseId" : "",
    "tableId" : "",
    "recordId" : ""
  },
  "type" : "airtable/v1/deleteRecord"
}

Output

Type: OBJECT

Properties

Name	Type	Description
id	STRING	The ID of the deleted record.
deleted	BOOLEAN Options true, false	Indicates if the record was deleted.

Output Example

{
  "id" : "",
  "deleted" : false
}

Get Record

Name: getRecord

Retrieves a single record.

Properties

Name	Label	Type	Description	Required
baseId	Base ID	STRING	ID of the base where table is located.	true
tableId	Table ID	STRING Depends On baseId	ID of the table where the record is located.	true
recordId	Record ID	STRING Depends On tableId, baseId	ID of the record that will be retrieved.	true

Example JSON Structure

{
  "label" : "Get Record",
  "name" : "getRecord",
  "parameters" : {
    "baseId" : "",
    "tableId" : "",
    "recordId" : ""
  },
  "type" : "airtable/v1/getRecord"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Triggers

New Record

Name: newRecord

Trigger off when a new entry is added to the table that you have selected.

Type: POLLING

Properties

Name	Label	Type	Description	Required
baseId	Base ID	STRING	ID of the base which contains the table that you want to monitor.	true
tableId	Table	STRING Depends On baseId	The table to monitor for new records.	true
triggerField	Trigger Field	STRING	It is essential to have a field for Created Time or Last Modified Time in your schema since this field is used to sort records, and the trigger will not function correctly without it. Therefore, if you don’t have such a field in your schema, please create one.	true

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

JSON Example

{
  "label" : "New Record",
  "name" : "newRecord",
  "parameters" : {
    "baseId" : "",
    "tableId" : "",
    "triggerField" : ""
  },
  "type" : "airtable/v1/newRecord"
}

---