Airtable (Independent Publisher) (Preview)

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 connection10060 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

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

Returns

Name Path Type Description
id
id string

Record ID

createdTime
createdTime string

Record Created Time

Delete a record

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

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

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

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.

Returns

Name Path Type Description
id
id string

id

createdTime
createdTime string

Record Created Time