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	Control Type	Description	Required
token	Token	STRING	TEXT		true

---

Actions

Create Record

Name: createRecord

Adds a record into an Airtable table.

Properties

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

Output

Type: OBJECT

Properties

Name	Type	Control Type
createdTime	DATE_TIME	DATE_TIME
fields	OBJECT Properties {}	OBJECT_BUILDER

JSON Example

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

Delete Record

Name: deleteRecord

Deletes a single record from a table.

Properties

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

Output

Type: OBJECT

Properties

Name	Type	Control Type
id	STRING	TEXT
deleted	BOOLEAN Options true, false	SELECT

JSON Example

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

Get Record

Name: getRecord

Retrieves a single record.

Properties

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

Output

Type: OBJECT

Properties

Name	Type	Control Type
id	STRING	TEXT
createdTime	DATE_TIME	DATE_TIME
fields	OBJECT Properties {}	OBJECT_BUILDER

JSON Example

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

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	Control Type	Description	Required
baseId	Base ID	STRING	SELECT	ID of the base which contains the table that you want to monitor.	true
tableId	Table	STRING Depends On baseId	SELECT	The table to monitor for new records.	true
triggerField	Trigger Field	STRING	TEXT	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

JSON Example

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

---