Actions3
Overview
This node allows executing SQL queries and performing data manipulation operations on a Firebird database. It supports running custom SQL queries with named parameters, as well as inserting and updating records in specified tables. This node is useful for integrating Firebird databases into workflows where you need to fetch, insert, or update data dynamically based on previous workflow steps.
Common scenarios include:
- Running complex SELECT queries with dynamic parameters to retrieve data.
- Inserting new records into a Firebird table using data from previous nodes.
- Updating existing records in a Firebird table based on key columns.
- Automating database interactions without writing external scripts.
Example: You can use this node to query product information by ID and value thresholds, then process the results downstream in your workflow.
Properties
| Name | Meaning |
|---|---|
| Query | The SQL query to execute. Supports named parameters prefixed with : (e.g., :param1). |
| Parameters | Comma-separated list of named parameters used in the query. These parameter values are taken from input data fields. Allowed characters: letters, numbers, underscore. |
| Timeout | Timeout duration (in seconds) for the database operation before it aborts. |
Output
The node outputs an array of JSON objects representing the result rows returned by the executed query or the outcome of insert/update operations.
- For executeQuery operation, the output JSON contains the rows fetched by the SQL query.
- For insert and update operations, the output JSON contains the result metadata from the database.
- If an error occurs and "Continue On Fail" is enabled, the output will contain an object with an
errorfield describing the issue.
The node does not output binary data.
Dependencies
- Requires a Firebird database connection configured via credentials that include host, port, database name, user, password, and optionally timeout.
- Uses the
node-firebirdlibrary internally to connect and run queries. - The node expects the Firebird server to be accessible from the n8n environment.
Troubleshooting
- Unknown Parameter Error: If the SQL query uses a named parameter not listed in the Parameters property, the node throws an error indicating the unknown parameter. Ensure all parameters used in the query are declared and provided in the input data.
- Connection Issues: Errors connecting to the Firebird server may occur if credentials are incorrect or the server is unreachable. Verify network connectivity and credential correctness.
- Timeouts: Long-running queries might time out based on the configured timeout value. Increase the timeout if needed.
- Unsupported Operation: If an unsupported operation is selected, the node throws an error stating the operation is not supported.
- SQL Syntax Errors: Malformed SQL queries will cause errors from the database. Validate your SQL syntax carefully.