Integrated Database Steps
  • 26 Jul 2022
  • 1 Minute to read
  • Dark
    Light

Integrated Database Steps

  • Dark
    Light

Article Summary

Step Details

Introduced in Version---
Modified in Version8.4.0
LocationIntegrations > 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

PropertyDescriptionData Type
Use Transaction DataAllow users to use transaction data with the integrated database table---
Run In Defined EnvironmentAllows the step to run in the environment or use an Agent ---
Override Connection StringAllows users to manually override the connection string of the database---

Inputs

PropertyDescriptionData Type
Inserted/Updated/Merged ObjectsAllows 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

PropertyDescriptionData Type
Failed

Error DetailsDescription of the error displayedString

Error MessageError message to be displayedString


Related Information

Forum Posts:
Integration Settings



Was this article helpful?