Step Details | |
| Introduced in Version | --- |
| Modified in Version | 8.4.0 |
| Location | Integrations > Database > [DatabaseName] |
The Integrated Database steps allow users to manipulate database tables that have been externally added to the platform. The Insert step allows a user to add a record to the integrated table and the Update step allows a user to change the details of an existing record in the table.
Properties
The Integrated Database steps include the following steps that can insert and/or update a record in a table:
- Insert
- Update
- Insert and Update
Environment
| Property | Description | Data Type |
|---|---|---|
| Use Transaction Data | Allow users to use transaction data with the integrated database table | --- |
| Run In Defined Environment | Allows the step to run in the environment or use an Agent | --- |
| Override Connection String | Allows users to manually override the connection string of the database | --- |
Inputs
| Property | Description | Data Type |
|---|---|---|
| Inserted/Updated/Merged Objects | Allows the user to insert and/or update a record in the table (for Postgres integrations, the Insert, Update, and Insert and Update steps allow the generation of auto-increment Serial Primary Key columns if the id field is set as NULL) | Object |
Outputs
| Property | Description | Data Type | |
|---|---|---|---|
| Failed | |||
| Error Details | Description of the error displayed | String | |
| Error Message | Error message to be displayed | String | |
Related Information
Forum Posts:
Integration Settings