Insert
MSSQL Plugin – Insert Action
Summary (SEO Meta Description):
The Insert Action in the MSSQL Plugin allows workflows to insert new records into a Microsoft SQL Server database table.
It supports schema validation, manual input mapping, and dynamic field mapping for flexible data handling.
Overview
The Insert Action enables workflows to add new rows into a specified MSSQL table.
It is commonly used to store processed workflow data, logs, or results directly in a database.
Typical Use Cases:
- Insert workflow results into an MSSQL table
- Store user activity logs or application events
- Add new business records (e.g., patients, orders, invoices)
- Save transformed data after processing
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create an MSSQL connection | Connection |
| Table name | Select the target database table | Dropdown |
| Columns | Define columns for data insertion | Add column(s) |
| Map | Map workflow data fields to table columns | Mapping section |
| Inputs (Manual) | Manually define input fields (optional) | NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY |
| Truncate Fields | Shorten input values if necessary | Boolean |
| Schema | Validate structure of inserted data | Schema selector |
FAQ
Q: Can I insert multiple rows at once?
A: Currently, each action inserts one row per execution. For batch inserts, consider looping within workflows.
Q: What happens if required columns are missing?
A: The action will fail unless all mandatory columns for the target table are provided.
Q: Can I use dynamic workflow data in the insert?
A: Yes. Columns can be mapped to values from workflow inputs or previous actions.
Keywords: WeHub MSSQL Plugin, MSSQL Insert Action, SQL Server Workflow Integration, Insert Data MSSQL