Select
MSSQL Plugin – Select Action
Summary (SEO Meta Description):
The MSSQL Plugin’s Select Action allows workflows to query Microsoft SQL Server tables.
It supports column selection, filtering, ordering, and pagination with schema validation for structured results.
Overview
The Select Action in the MSSQL Plugin enables workflows to retrieve data from Microsoft SQL Server databases.
It is useful for querying records, applying filters, sorting results, and mapping query outputs into workflow pipelines.
Typical Use Cases:
- Query specific tables in MSSQL for reporting
- Retrieve filtered data sets with conditions
- Use ordered results with pagination (limit/offset)
- Fetch structured outputs into workflows for further processing
⚙️ 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 querying | Dropdown |
| Columns | Columns to select (supports multiple) | String[] |
| Condition | WHERE clause conditions | String |
| Order | ORDER BY clause | String |
| Limit | Maximum number of rows to fetch | Number |
| Offset | Rows to skip before returning results | Number |
| Inputs | Define input variables for dynamic queries | Manual Toggle |
| Schema (Inputs) | Validate incoming query inputs | Schema |
| Outputs | Map query results to workflow outputs | Manual Toggle |
| Schema (Outputs) | Validate output data | Schema |
FAQ
Q: Can I run complex queries with joins?
A: Yes. While the Select Action UI focuses on single-table queries, you can extend it with custom SQL in advanced configurations.
Q: Does it support pagination?
A: Yes. Use Limit and Offset fields to paginate query results.
Q: Can I validate outputs?
A: Yes. Outputs can be mapped and validated against schemas for consistency.
Keywords: WeHub MSSQL Plugin, MSSQL Select Action, Query SQL Server, Workflow Database Querying, MSSQL Automation