List Records from Airtable
n8n-nodes-base.httpRequest
Retrieve records from an Airtable table with filtering, sorting, and pagination support. Perfect for syncing data and building dynamic workflows.
💡 Use Cases
- Sync Airtable records to other systems
- Build reports from Airtable data
- Trigger workflows based on record data
📚 API Documentation
Reference documentation for this API endpoint:
🔗 https://airtable.com/developers/web/api/list-records ↗📋 Node Configuration
{
"nodes": [
{
"parameters": {
"content": "## 📋 List Records from Airtable\n\n**Usage:**\nRetrieve records from an Airtable table with optional filtering, sorting, and pagination.\n\n**Required Input:**\n- `baseId`: Your Airtable base ID (starts with 'app')\n- `tableIdOrName`: Table ID or name\n\n**Optional Parameters:**\n- `fields[]`: Only return specific fields\n- `filterByFormula`: Airtable formula to filter records\n- `maxRecords`: Maximum number of records to return\n- `pageSize`: Records per page (max 100)\n- `sort[0][field]`: Field to sort by\n- `sort[0][direction]`: 'asc' or 'desc'\n- `view`: Name or ID of a view\n- `offset`: Pagination offset from previous response\n\n**Setup:**\n1. Create HTTP Header Auth credential\n2. Set Name: `Authorization`\n3. Set Value: `Bearer YOUR_PERSONAL_ACCESS_TOKEN`\n4. Get token from airtable.com/create/tokens\n\n**Output:**\nReturns array of records with id, createdTime, and fields",
"height": 238,
"width": 389,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
332
],
"typeVersion": 1,
"id": "sticky-airtable-list-records",
"name": "Sticky Note"
},
{
"parameters": {
"method": "GET",
"url": "=https://api.airtable.com/v0/{{ $json.baseId }}/{{ $json.tableIdOrName }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "maxRecords",
"value": "={{ $json.maxRecords || 100 }}"
},
{
"name": "pageSize",
"value": "={{ $json.pageSize || 100 }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"id": "airtable-list-records-node",
"name": "List Airtable Records",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
368,
400
],
"credentials": {
"httpHeaderAuth": {
"id": "airtable-header-auth",
"name": "Airtable Header Auth"
}
}
}
],
"connections": {},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "airtable-flowkit-instance"
}
}
[
{
"id": "ef47b6b8-0aee-4332-8a53-64d5c42d9f4c",
"meta": {
"name": "API Call Node",
"id": "api-call",
"icon": {
"svg": "
{
"subflows": [
{
"flow": [
{
"id": 835,
"module": "http:ActionSendDataBasicAuth",
"version": 3,
"parameters": {
"key": "ANONYMIZED_CREDENTIALS",
"handleErrors": false,
"useNewZLibDeCompress": true
},
"mapper": {
"ca": "",
"qs": [
{
"name": "maxRecords",
"value": "{{ $json.maxRecords || 100 }}"
},
{
"name": "pageSize",
"value": "{{ $json.pageSize || 100 }}"
}
],
"url": "https://api.airtable.com/v0/{{1.baseId}}/{{1.tableIdOrName}}",
"data": "",
"gzip": true,
"method": "get",
"headers": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "Authorization",
"value": "Bearer {{ANONYMIZED_TOKEN}}"
}
],
"timeout": "",
"useMtls": false,
"bodyType": "raw",
"contentType": "application/json",
"serializeUrl": false,
"shareCookies": false,
"parseResponse": true,
"followRedirect": true,
"useQuerystring": false,
"followAllRedirects": false,
"rejectUnauthorized": true
},
"metadata": {
"designer": {
"x": 300,
"y": 300,
"name": "List Records from Airtable"
},
"restore": {
"expect": {
"qs": {
"mode": "chose",
"items": [
null,
null
]
},
"method": {
"mode": "chose",
"label": "GET"
},
"headers": {
"mode": "chose",
"items": [
null,
null
]
},
"bodyType": {
"label": "Raw"
},
"contentType": {
"label": "JSON (application/json)"
}
},
"parameters": {
"key": {
"label": "ANONYMIZED_CREDENTIALS"
}
}
},
"parameters": [
{
"name": "key",
"type": "keychain:basicauth",
"label": "Credentials",
"required": true
},
{
"name": "handleErrors",
"type": "boolean",
"label": "Evaluate all states as errors (except for 2xx and 3xx )",
"required": true
},
{
"name": "useNewZLibDeCompress",
"type": "hidden"
}
],
"expect": [
{
"name": "url",
"type": "url",
"label": "URL",
"required": true
},
{
"name": "serializeUrl",
"type": "boolean",
"label": "Serialize URL",
"required": true
},
{
"name": "method",
"type": "select",
"label": "Method",
"required": true,
"validate": {
"enum": [
"get",
"head",
"post",
"put",
"patch",
"delete",
"options"
]
}
},
{
"name": "headers",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Headers"
},
{
"name": "qs",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Query String"
},
{
"name": "bodyType",
"type": "select",
"label": "Body type",
"validate": {
"enum": [
"raw",
"x_www_form_urlencoded",
"multipart_form_data"
]
}
},
{
"name": "parseResponse",
"type": "boolean",
"label": "Parse response",
"required": true
},
{
"name": "contentType",
"type": "select",
"label": "Content type",
"validate": {
"enum": [
"text/plain",
"application/json",
"application/xml",
"text/xml",
"text/html",
"custom"
]
}
},
{
"name": "data",
"type": "buffer",
"label": "Request content"
}
]
}
}
]
}
],
"metadata": {
"version": 1
}
}