Update
MSSQL Plugin – Update Action
Summary (SEO Meta Description):
The MSSQL Plugin’s Update Action allows workflows to update existing rows in Microsoft SQL Server tables.
It supports conditional updates, column mapping, and schema validation for structured automation.
Overview
The Update Action in the MSSQL Plugin enables workflows to modify existing records in SQL Server tables.
You can specify target columns, define conditions, and map workflow inputs to database fields.
Typical Use Cases:
- Update user details (e.g., email, phone) in a CRM database
- Modify workflow-related records in MSSQL tables
- Apply schema validation to ensure updates are consistent
- Conditionally update rows using WHERE clauses
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create a database connection | Connection |
| Table name | Target table for updates | Dropdown |
| Columns | Define which columns to update | String[] + Map |
| Condition | WHERE clause conditions (rows to update) | String |
| Inputs | Define input variables for dynamic updates | Manual Toggle |
| Schema (Inputs) | Validate update inputs | Schema |
| Query Inputs | Define query variables for WHERE clause | Manual Toggle |
| Schema (Query Inputs) | Validate query inputs | Schema |
FAQ
Q: Can I update multiple rows at once?
A: Yes. Use the Condition field to match multiple rows; all matching records will be updated.
Q: Does it support column mapping?
A: Yes. You can map workflow inputs to specific table columns using the Columns and Map configuration.
Q: Can I validate inputs before applying updates?
A: Yes. Both Inputs and Query Inputs support schema validation for safety and consistency.
Keywords: WeHub MSSQL Plugin, MSSQL Update Action, Update SQL Server Rows, Workflow Database Automation