NWC SQL Queries - retrieve multiple columns
The SQL connectors allow a designer to select a single column for select queries. Many times we wish to select multiple columns. Can these actions be modified so we can add an unlimited number of columns?
We now have functionality to query both SQL On-premises (via Nintex Gateway) and AzureSQL.
The functionality returns the column types we support (which is most of them) and will give back the full row in a structured manner.