Custom
MSSQL Plugin – Custom Action
Summary (SEO Meta Description):
The Custom Action in the MSSQL Plugin allows you to run custom SQL queries directly within a workflow.
It supports both inputs and outputs mapping, making it flexible for complex database operations.
Overview
The Custom Action enables workflows to execute raw SQL queries against a Microsoft SQL Server database.
It is ideal for scenarios where predefined actions (Insert, Select, Update, Delete, Upsert) are not sufficient.
Typical Use Cases:
- Execute complex SELECT queries with joins and conditions
- Run stored procedures inside MSSQL
- Perform batch updates or calculations
- Generate custom reports by querying specific fields
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create an MSSQL connection | Connection |
| SQL | SQL query to execute | String |
| Inputs (Manual) | Define custom query parameters (optional) | NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY |
| Truncate Fields | Shorten field values if required | Boolean |
| Schema (Inputs) | Schema validation for input parameters | Schema selector |
| Outputs (Manual) | Define custom outputs from query results | NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY |
| Truncate Fields | Shorten output field values if required | Boolean |
| Schema (Outputs) | Schema validation for query results | Schema selector |
FAQ
Q: Can I run multiple SQL statements in one action?
A: It is recommended to run one statement per action. Running multiple may depend on your MSSQL configuration.
Q: Does this action support dynamic inputs?
A: Yes. You can pass workflow data as parameters into your SQL queries using manual inputs.
Q: Can I retrieve results from a SELECT query?
A: Yes. Use the Outputs section to define how the query results should be mapped back into the workflow.
Keywords: WeHub MSSQL Plugin, MSSQL Custom SQL, MSSQL Workflow Query, Microsoft SQL Server Integration