Azure SQL - Query a SQL view

Use the Azure SQL - 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 Azure SQL connector, go to Azure SQL.

Configure the Azure SQL -Query a SQL view

  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.
  1. Select the View.
  2. Specify the Item limit.
  3. Select which column to Sort by.
  4. Select the Sort order.
  5. Click the Add condition button to define which records to retrieve.
  6. Select the condition When and Operator values.
  7. Specify the Value that must be matched.
  8. Create or select a variable for the output.

Azure SQL - 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 Azure SQL connection is used to create, update, and delete records.

To refresh the available connections, click .

(n/a)

View The list is populated based on the connection selected. Select the table view to query. Text, Decimal, Integer, Boolean, DateTime, Collection
Item limit Item limit contains the maximum amount of rows that will be returned from the query result. The default is 1000 items and the maximum is 5000 items. Integer
Sort By Sort by contains a list of all the supported columns in the selected table. Select 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 Conditions

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. The following values are returned:
  • Number of rows returned: (Integer) The number of rows returned from the query.
  • Is full result set: (Boolean) Returns true if the table only contains supported column types. If any unsupported column types exist, e.g. varbinary, then it will return false.
  • Rows: (Collection) Contains the values returned from the SQL query.
Object