Delete Multiple Records from Airtable
n8n-nodes-base.httpRequest
Delete multiple records from an Airtable table in a single request. Supports batch deletion of up to 10 records.
💡 Use Cases
- Bulk delete obsolete records
- Clean up multiple test records
- Remove records in batch
📚 API Documentation
Reference documentation for this API endpoint:
🔗 https://airtable.com/developers/web/api/delete-multiple-records ↗📋 Node Configuration
{
"nodes": [
{
"parameters": {
"content": "## 🗑️ Delete Multiple Records from Airtable\n\n**WARNING:** This action permanently deletes records!\n\n**Usage:**\nDelete up to 10 records in a single request.\n\n**Required Input:**\n- `baseId`: Your Airtable base ID (starts with 'app')\n- `tableIdOrName`: Table ID or name\n- `records[]`: Array of record IDs to delete\n\n**URL Format:**\n```\n?records[]=recXXX&records[]=recYYY\n```\n\n**Setup:**\n1. Create HTTP Header Auth credential\n2. Set Name: `Authorization`\n3. Set Value: `Bearer YOUR_PERSONAL_ACCESS_TOKEN`\n\n**Output:**\nReturns array of deleted records:\n```json\n{\n \"records\": [\n { \"id\": \"recXXX\", \"deleted\": true },\n { \"id\": \"recYYY\", \"deleted\": true }\n ]\n}\n```\n\n**Note:**\nDeleted records cannot be recovered via API.",
"height": 238,
"width": 389,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
332
],
"typeVersion": 1,
"id": "sticky-airtable-delete-multiple",
"name": "Sticky Note"
},
{
"parameters": {
"method": "DELETE",
"url": "=https://api.airtable.com/v0/{{ $json.baseId }}/{{ $json.tableIdOrName }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "records[]",
"value": "={{ $json.recordId1 }}"
},
{
"name": "records[]",
"value": "={{ $json.recordId2 }}"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"id": "airtable-delete-multiple-node",
"name": "Delete Multiple 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": "bb4e6505-48fd-4092-87ce-af09b8281197",
"meta": {
"name": "API Call Node",
"id": "api-call",
"icon": {
"svg": "
{
"subflows": [
{
"flow": [
{
"id": 466,
"module": "http:ActionSendDataBasicAuth",
"version": 3,
"parameters": {
"key": "ANONYMIZED_CREDENTIALS",
"handleErrors": false,
"useNewZLibDeCompress": true
},
"mapper": {
"ca": "",
"qs": [
{
"name": "records[]",
"value": "{{1.recordId1}}"
},
{
"name": "records[]",
"value": "{{1.recordId2}}"
}
],
"url": "https://api.airtable.com/v0/{{1.baseId}}/{{1.tableIdOrName}}",
"data": "",
"gzip": true,
"method": "delete",
"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": "Delete Multiple Records from Airtable"
},
"restore": {
"expect": {
"qs": {
"mode": "chose",
"items": [
null,
null
]
},
"method": {
"mode": "chose",
"label": "DELETE"
},
"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
}
}