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.
Before you begin:
Add the action to the workflow and open the action configuration panel. For more information, see Add, rename, and copy actions.
- Select a Connection. If you do not have a connection, see Add a connection.
- Select the SQL Table.
- Specify the Item limit.
- Select which column to Sort by.
- Select the Sort order.
- Click the Add condition button to define which records to retrieve.
- Select the condition When and Operator values.
- Specify the Value that must be matched.
- Create or select a variable for the output.
The Azure SQL connection is used to create, update, and delete records.
To refresh the available connections, click .
|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|
Click Add condition to define which records to retrieve. This builds a SQL WHERE statement defining what records to retrieve.
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|
Stores the result of the action as an object. The following values are returned: