Actions3
Overview
This node allows interaction with a Firebird database, specifically enabling users to insert data into specified tables. It is useful in scenarios where you need to programmatically add new rows to a Firebird database from workflows, such as importing data from other sources or automating data entry tasks.
For example, you can use this node to insert multiple records into a customer table by specifying the target table and columns, then passing the data items through the workflow.
Properties
| Name | Meaning |
|---|---|
| Table | The name of the Firebird database table where new data rows will be inserted. |
| Columns | Comma-separated list of column names that correspond to the properties of the input data to be inserted as new rows. Example: id,name,description. |
| Timeout | Timeout duration (in seconds) for the database operation before it aborts due to inactivity. |
Output
The node outputs JSON data representing the result of the insert operation. Typically, this includes metadata about the executed query, such as the number of affected rows or any returned information from the database after insertion.
If an error occurs during insertion and "Continue On Fail" is enabled, the output will contain an error object with the message describing the failure.
Dependencies
- Requires a Firebird database connection configured via credentials that include necessary authentication details and connection parameters.
- Uses the
node-firebirdlibrary to connect and execute queries on the Firebird database. - The node expects proper network access to the Firebird server.
Troubleshooting
Common issues:
- Incorrect table name or column names may cause SQL errors.
- Mismatch between the number of columns specified and the data provided can lead to query failures.
- Network connectivity problems or incorrect credentials will prevent successful connection.
- Timeout too short for large inserts might cause premature termination.
Error messages:
"No credentials got returned!": Indicates missing or misconfigured API key credential for Firebird connection."The operation \"insert\" is not supported!": Occurs if the operation parameter is set incorrectly; ensure "Insert" operation is selected.- SQL errors related to syntax or constraints will be passed through; verify table schema and data integrity.
Resolutions:
- Double-check table and column names against the Firebird database schema.
- Ensure credentials are correctly set up and have sufficient permissions.
- Increase timeout value if operations take longer than expected.
- Validate input data matches the columns specified.