docs/versioned_docs/version-2.35.0/data-sources/airtable.md
ToolJet can connect to your Airtable account to read and write data. Personal Access Token is required to connect to the Airtable data source on ToolJet. You can generate the Personal Access Token by visiting Developer Hub from your Airtable profile.
<div style={{textAlign: 'center'}}> </div>:::info Airtable API has a rate limit, and at the time of writing this documentation, the limit is five(5) requests per second per base. You can read more about rate limits here Airtable API. :::
</div> <div style={{paddingTop:'24px', paddingBottom:'24px'}}>This operation returns a list of records from the specified table.
Base ID: To find the Base ID, first visit Airtable API. Then select the base you want to connect to. The Base ID will be mentioned in the API documentation. Example Base ID: appDT3UCPffPiSmFd
Table name: The name of the table from which you want to fetch the records.
Page size: The number of records returned in each request. Default is 100 records.
Offset: The offset value is used to fetch the next set of records. The offset value is returned in the response of the previous request.
Example response from Airtable:
{
"records": [
{
"id": "recu9xMnUdr2n2cw8",
"fields": {
"Notes": "sdfdsf",
"Name": "dsfdsf"
},
"createdTime": "2021-05-12T14:30:33.000Z"
},
{
"id": "recyIdR7bVdQvmKXa",
"fields": {
"Notes": "sdfdsf",
"Name": "dfds"
},
"createdTime": "2021-05-12T14:30:33.000Z"
},
{
"id": "recAOzdIHaRpvRaGE",
"fields": {
"Notes": "sdfsdfsd",
"Name": "sdfdsf"
},
"createdTime": "2021-05-12T14:30:33.000Z"
}
],
"offset": "recAOzdIHaRpvRaGE"
}
Base ID: To find the Base ID, first visit Airtable API. Then select the base you want to connect to. The Base ID will be mentioned in the API documentation. Example Base ID: appDT3UCPffPiSmFd
Table name: The name of the table from which you want to fetch the records.
Record ID: The ID of the record you want to retrieve.
Example response from Airtable:
{
"id": "recu9xMnUdr2n2cw8",
"fields": {
"Notes": "sdfdsf",
"Name": "dsfdsf"
},
"createdTime": "2021-05-12T14:30:33.000Z"
}
Base ID: To find the Base ID, first visit Airtable API. Then select the base you want to connect to. The Base ID will be mentioned in the API documentation. Example Base ID: appDT3UCPffPiSmFd
Table name: The name of the table from which you want to fetch the records.
Records: The records you want to create. The records should be in the form of an array of objects. Each object should have a fields key, which contains the fields of the record. The field names should be the same as the field names in the Airtable table.
Example creating two records:
[
{
"fields": {
"Notes": "sdfdsf",
"Name": "dsfdsf"
}
},
{
"fields": {
"Notes": "note1",
"Name": "dsfdsf"
}
}
]
Query returns the following response when the records are created successfully:
{
"records": [
{
"id": "rec5RuZ1COoZGtGDY",
"fields": {
"Notes": "sdfdsf",
"Name": "dsfdsf"
},
"createdTime": "2022-02-07T20:25:27.000Z"
},
{
"id": "recaYbFPonNNu6Cwj",
"fields": {
"Notes": "note1",
"Name": "dsfdsf"
},
"createdTime": "2022-02-07T20:25:27.000Z"
}
]
}
Base ID: To find the Base ID, first visit Airtable API. Then select the base you want to connect to. The Base ID will be mentioned in the API documentation. Example Base ID: appDT3UCPffPiSmFd
Table name: The name of the table from which you want to fetch the records.
Record ID: The ID of the record you want to update.
Body: The fields you want to update. The fields should be in the form of an object. The field names should be the same as the field names in the Airtable table.
Example updating a record:
{
"Notes": "Example Notes",
"Name": "change"
}
Query returns the following response when the record is updated successfully:
{
"id": "recu9xMnUdr2n2cw8",
"fields": {
"Notes": "Example Notes",
"Name": "change"
},
"createdTime": "2021-08-08T17:27:17.000Z"
}
Query returns the following response when the record is deleted successfully:
{
deleted: true
id: "recIKsyZgqI4zoqS7"
}