Azure SQL - Update SQL records

Use the Azure SQL -Update SQL records action A tool for building the processes, logic, and direction within workflows. to update SQL records.

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

Before you begin: 

Jump to:

Configure the Azure SQL - Update SQL records

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

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select the SQL Table.
  2. Specify the values of any required fields.
  3. Click the Add field button to add non-required record fields.
  4. Select the fields. Click Add.
  5. Specify the value of the fields.
  6. Click the Add condition button to define which records to update.
  7. Select the condition When and Operator values.
  8. Specify the Value that must be matched.
  9. Create or select a variable for the output.

Azure SQL - Update SQL Records action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings 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 that contains the records that you wish you update. Text, Decimal, Integer, Boolean, DateTime, Collection
Add fields

Required column fields automatically display.

Use the Add fields button to add any non-required fields that you need to specify a value for when updating the new record.

The field type is based on the column type in the SQL table. Numerical precision, scale, date type, and maximum values are shown in the field sub-text.

Read only column fields, like Identity, Calculated, or Timestamp, cannot be specified while creating a new record, and those field types are not available in this action.

SQL Data type Nintex variable type Notes
bit Boolean  
decimal Decimal  
money Decimal  
numeric Decimal  
smallmoney Decimal  
float Decimal  
real Decimal  
binary File Not supported.
image File Not supported.
varbinary File Not supported.
bigint Integer Limited support, see the known issues list.
int Integer  
smallint Integer  
tinyint Integer  
Sysname N/A Not supported.
hierarchyid N/A Not supported.
sql_variant N/A Not supported.
Geography N/A Not supported.
Geometry N/A Not supported.
uniqueidentifier String  
xml String  
char Text  
text Text  
varchar Text  
nchar Text  
ntext Text  
nvarchar Text  
datetimeoffset Text  
time Text  
timestamp Text  
date DateTime  
datetime DateTime  
datetime2 DateTime  
smalldatetime DateTime  
Object
Add Condition

Click Add condition to define which records to update. This builds a SQL WHERE statement defining what records to update.

  • 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 update all the records in that table where Smith is the value of the LastName column.

 Text, Decimal, Integer, Boolean, DateTime, Collection
Output Item Stores the result of the action as an integer of the amount of records that were updated. Integer