Delete Record
Deletes a specific record from an Airtable table.
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.
Inputs
- Key Id - The key identifier returned from the Connect node.
- Base Id - The unique identifier of the Airtable base where the record exists.
- Table Name - The name of the table where the record exists.
- Record Id - The unique identifier of the record to be deleted.
Output
- result - An object containing the deletion result, including the deleted record's ID and deletion time.
How It Works
The Delete Record node removes a specific record from an Airtable table. When executed, the node:
- Validates the required inputs (Base Id, Table Name, and Record Id)
- Constructs the Airtable API endpoint URL for the specific record
- Retrieves the API key using the provided Key Id
- Sends a DELETE request to the Airtable API
- Returns the deletion confirmation as the result
Requirements
- A valid Airtable account
- An Airtable base with appropriate permissions
- A connected Airtable session (using the Connect node)
- Valid Base Id, Table Name, and Record Id
- Sufficient permissions to delete records from the table
Error Handling
The node will return specific errors in the following cases:
- Empty or invalid Key Id
- Empty or invalid Base Id
- Empty or invalid Table Name
- Empty or invalid Record Id
- Record not found (404 error)
- Airtable API errors (e.g., insufficient permissions)
- HTTP connection errors
Usage Notes
- The Record Id must be the unique identifier assigned by Airtable when the record was created
- Record Ids can be obtained from the result of Create Record, List Records, or Read Record operations
- Once a record is deleted, it cannot be recovered through the API (unless using Airtable's backup features)
- The node will fail if the record doesn't exist or if you don't have permission to delete it
- Deleted records are returned in the "deleted" field of the result object
Example
To delete a specific contact record:
Inputs:
- Key Id: (from Connect node)
- Base Id: "appBase123"
- Table Name: "Contacts"
- Record Id: "recRecord123"
Output: The result will contain confirmation of the deletion:
{
"id": "recRecord123",
"deleted": true
}
Best Practices
- Always verify the Record Id before deletion to prevent accidental data loss
- Consider implementing confirmation steps in your automation flows for deletions
- Use List Records or Read Record nodes to verify record existence before attempting deletion
- Handle deletion errors appropriately in your workflows
- Keep backups of important data before performing bulk deletions