Airtable (Independent Publisher)

Connector to read and write data in Airtable. Airtable is a cloud-based spreadsheet-like service that enables users to collaborate and manage different types of data. It is easy-to-use and can act as database or CRM (Customer Relationship Management). It can also be used as project planning, tracking inventory.

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following:      -   Azure Government regions      -   Azure China regions      -   US Department of Defense (DoD)
Power Automate	Premium	All Power Automate regions except the following:      -   US Government (GCC)      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)
Power Apps	Premium	All Power Apps regions except the following:      -   US Government (GCC)      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)

Contact
Name	Woong Choi
URL	https://last72.tistory.com/entry/Airtable-Connector-Support
Email	Woong.Choi@sevensigma.com.au

Connector Metadata
Publisher	Woong Choi
Website	https://airtable.com/
Privacy policy	https://airtable.com/privacy
Categories	Data

Creating a connection

The connector supports the following authentication types:

Default	Parameters for creating connection.	All regions	Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
API Key	securestring	The API Key for this api	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

Create a record	Create a record in a table. JSON record needs to be passed.
Delete a record	Delete a record in a table. Provide Record ID to select a record.
List Records	List Records in table. Returned records do not include any fields with empty values. You can filter, sort, and format the results with the parameters.
Retrieve a record	Retrieve a record in a table. Any empty fields (e.g. [], or false) in the record will not be returned.
Update a record	Update a record in a table. It will only update the fields provided and leave the rest as they were.

Create a record

Operation ID:

CreateaRecord

Create a record in a table. JSON record needs to be passed.

Parameters

Name	Key	Required	Type	Description
Base ID	Base ID	True	string	Base ID
Table	Table	True	string	Table name
			object

Returns

Name	Path	Type	Description
id	id	string	Record ID
createdTime	createdTime	string	Record Created Time

Delete a record

Operation ID:

DeleteaRecord

Delete a record in a table. Provide Record ID to select a record.

Parameters

Name	Key	Required	Type	Description
Base ID	Base ID	True	string	Base ID
Table	Table	True	string	Table name
Record ID	Record ID	True	string	Record ID to be deleted.

Returns

Name	Path	Type	Description
id	id	string	id
deleted	deleted	boolean	deleted
type	error.type	string	type
message	error.message	string	message

List Records

Operation ID:

ListRecords

List Records in table. Returned records do not include any fields with empty values. You can filter, sort, and format the results with the parameters.

Parameters

Name	Key	Required	Type	Description
Base ID	Base ID	True	string	Base ID
Table	Table	True	string	Table name
Formula filter	filterByFormula		string	A formula used to filter records.
Maximum number of records.	maxRecords		integer	The maximum total number of records that will be returned in your requests.
Page size per request	pageSize		integer	The number of records returned in each request. Must be less than or equal to 100.
View	view		string	The name or ID of a view in the table. If set, only the records in that view will be returned.
Cell format	cellFormat		string	The format that should be used for cell values. Supported values are: json: cells will be formatted as JSON, depending on the field type. string: cells will be formatted as user-facing strings, regardless of the field type.
Time zone	timeZone		string	The time zone that should be used to format dates when using string as the cellFormat. This parameter is required when using string as the cellFormat.
User locale	userLocale		string	The user locale that should be used to format dates when using string as the cellFormat. This parameter is required when using string as the cellFormat.

Returns

Name	Path	Type	Description
records	records	array of object	Records
id	records.id	string	Record ID
createdTime	records.createdTime	string	Record Created Time

Retrieve a record

Operation ID:

RetrieveaRecord

Retrieve a record in a table. Any empty fields (e.g. [], or false) in the record will not be returned.

Parameters

Name	Key	Required	Type	Description
Base ID	Base ID	True	string	Base ID
Table	Table	True	string	Table name
Record ID	Record ID	True	string	Record ID to be retrieved.

Returns

Name	Path	Type	Description
id	id	string	Record ID
createdTime	createdTime	string	Record Created Time

Update a record

Operation ID:

UpdateaRecord

Update a record in a table. It will only update the fields provided and leave the rest as they were.

Parameters

Name	Key	Required	Type	Description
Base ID	Base ID	True	string	Base ID
Table	Table	True	string	Table name
Record ID	Record ID	True	string	Record ID to be updated
Content-Type	Content-Type		string	Content-Type for the body of the request. It is defaulted to JSON.
			object

Returns

Name	Path	Type	Description
id	id	string	id
createdTime	createdTime	string	Record Created Time