Azure SQL - Create a SQL record

Use the Azure SQL - Create a SQL record action A tool for building the processes, logic, and direction within workflows. to insert a new row in a SQL table. This adds new data to the SQL table.

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

Before you begin: 

Jump to:

Configure the Azure SQL - Create a SQL record

  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 added fields.

Azure SQL - Create a SQL record 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 to add records to. 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  
The variable type is dependent on the column type in the SQL table.
Output Item Stores the result of the action as an object. The following values are returned:
  • 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.
  • Result Item: (Object) Contains the values for each supported column type in the created record
 Object