Microsoft SQL Server on-premises - Query a SQL view

Use the Microsoft SQL Server on-premises - Query a SQL view action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve data from a SQL view.

This retrieves records that match a condition from a SQL view.

For more information about the Microsoft SQL Server on-premises connector, go to Microsoft SQL Server on-premises.

Configure the Microsoft SQL Server on-premises - Query a SQL view action

1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

2. Select a Connection. If you do not have a connection, see Add a connection.

3. Select the View.
4. Specify the Item limit.
5. Select which column to Sort by.
6. Select the Sort order.
7. Click Add condition to define which records to retrieve.

Microsoft SQL Server on-premises - Query a SQL view action fields and settings

Section	Field	Description	Variable types
(Unlabeled)	Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.	The Microsoft SQL Server on-premises connection to use to retrieve the records. To refresh the available connections, click .	(n/a)
	View	The SQL view you want to retrieve data from.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Item limit	The number of records to return.	Integer
	Sort by	The column name to use for sorting the retrieved records.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Sort order	Sort the retrieved records in ascending or descending order.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Add condition	Click Add condition to define which records to retrieve. This builds a SQL WHERE statement defining what records to retrieve. When: The column selected for the condition. Operator: The operator type of the conditional case statement, such as equals, does not equal, is empty, is not empty, contains, begins with, or ends with. Value: The specific value searched for. Summary: A short description of your condition. For example, WHEN LastName equals Smith would retrieve all the records in that table where Smith is the value of the LastName column.	Text, Decimal, Integer, Boolean, DateTime, Collection
Output	Items	Stores the result of the action as an object. See Microsoft SQL Server on-premises View for more details. The following values are returned: Number of rows returned: Integer) Is full result set: (Boolean) Returns False if a data type was excluded, like read-only columns. Rows: (Object) List of retrieved record fields	Object