Sqlexec

Submits an SQL (Structured Query Language) statement to a database server for the purposes of updating or inserting a record.

Supported Script Types

Generic Email Chat Phone Voicemail Work Item SMS

Properties

Property Details
SQLStatement

The SQL Statement that will be submitted to the database server.

This statement should not return records.

FetchIdentityVar

The name of a variable to receive the identity value from an insert.

This property is used only when the table you are inserting contains an identity column.

TimeoutSec The amount of seconds that the action will wait to execute before timing out. The value must be between 0 and 60.

Branches

Branch Details

Default

Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the other branches are not defined.
OnError Path taken when an action fails to execute properly.
OnTimeout Path taken if there is no response for the number of seconds specified.

Tips & Tricks

  • For more details on database servers, see Sqlselect.