Actions8
- Record Actions
- Vector Actions
- Raw Query Actions
Record → Delete
AI-generatedOverview
This node deletes a record from a specified table in HelixDB, a time-series database. It is useful when you need to remove outdated or unwanted records from your database. For example, you might delete a user record by its ID from a 'users' table.
Use Case Examples
- Deleting a user record by ID from the 'users' table.
- Removing an obsolete entry from a data table.
Properties
| Name | Meaning |
|---|---|
| Table Name | The name of the table from which the record will be deleted. |
| Record ID | The unique identifier of the record to delete. |
Output
JSON
json- The response from HelixDB after attempting to delete the record, typically confirming deletion or providing error details.
Dependencies
- Requires HelixDB server running with deployed HelixQL queries.
- Requires an API key credential for HelixDB authentication.
Troubleshooting
- Common issues include providing an incorrect table name or record ID, which will cause the operation to fail.
- If the HelixDB server is not running or the API credentials are invalid, the node will throw an authentication or connection error.
- Error message 'Unsupported operation: record:delete' indicates a misconfiguration of the resource or operation parameters.
Links
- HelixDB Documentation - Official documentation for HelixDB including query syntax and API usage.