Airtable (Independent Publisher) [DEPRECATED]
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 protected] |
| 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 [DEPRECATED] |
Create a record in a table. JSON record needs to be passed. |
| Delete a record [DEPRECATED] |
Delete a record in a table. Provide Record ID to select a record. |
| List Records [DEPRECATED] |
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 [DEPRECATED] |
Retrieve a record in a table. Any empty fields (e.g. [], or false) in the record will not be returned. |
| Update a record [DEPRECATED] |
Update a record in a table. It will only update the fields provided and leave the rest as they were. |
Create a record [DEPRECATED]
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 [DEPRECATED]
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 [DEPRECATED]
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 [DEPRECATED]
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 [DEPRECATED]
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 |