Azure SQL - Query a SQL table

Use the Azure SQL - Query a SQL table action A tool for building the processes, logic, and direction within workflows. to retrieve data from a SQL table. This retrieves records that match a condition from a SQL table.

For more information about the Azure SQL connector, go to Azure SQL.

Configure the Azure SQL - Query a SQL table

  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 SQL Table.
  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 table 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)

Table The list is populated based on the connection selected. Select the table to query from. 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 to sort the table. Text, Decimal, Integer, Boolean, DateTime, Collection
Sort Order The order that the rows must be sorted in within the output. Select the order that the rows should follow. 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.
  • First row: (Object) Contains the properties of the first row in a query.
Object