Actions3
Overview
This node enables interaction with a Firebird database, specifically allowing users to update existing rows in a specified table. It is useful when you need to modify records based on a key property (commonly an ID) and update one or more columns with new values.
Typical use cases include:
- Updating user information in a customer database.
- Modifying product details in an inventory system.
- Changing status flags or timestamps in transactional data.
For example, you might update the "description" and "name" columns of a "products" table where the "id" matches a given value.
Properties
| Name | Meaning |
|---|---|
| Table | The name of the database table where the update operation will be performed. |
| Update Key | The column/property used to identify which rows should be updated (usually a unique identifier like "id"). |
| Columns | Comma-separated list of columns that should be updated in the selected rows. |
| Timeout | Maximum time (in seconds) to wait for the update operation before timing out. |
Output
The output is a JSON array representing the result of the update operation. Typically, this includes metadata about the execution such as affected rows or confirmation of success. If an error occurs and the node is configured to continue on failure, the output will contain an object with an error property describing the issue.
No binary data is produced by this node.
Dependencies
- Requires a valid connection to a Firebird database, including host, port, database path, username, and password provided via credentials.
- Uses the
node-firebirdlibrary to connect and execute queries. - The node expects proper configuration of credentials within n8n to authenticate against the Firebird server.
Troubleshooting
Common issues:
- Incorrect table or column names can cause SQL errors.
- Missing or incorrect update key values may result in no rows being updated.
- Network or authentication failures if credentials are invalid or the database is unreachable.
- Timeout errors if the database does not respond within the specified timeout period.
Error messages:
"No credentials got returned!": Indicates missing or misconfigured credentials; ensure credentials are set up correctly."The parameter \"<param>\" is unknown!": Occurs if query parameters do not match expected columns; verify input properties.- SQL errors from the database (e.g., syntax errors, constraint violations): Check table and column names, data types, and constraints.
"The operation \"update\" is not supported!": Should not occur here since update is supported; if it does, verify the operation parameter is correctly set.
To resolve errors, verify all input parameters, credentials, and database connectivity. Use the "Continue On Fail" option to handle errors gracefully during workflow execution.