SQL Action
- Robert Sutton (Deactivated)
- Brett Sutton (Deactivated)
SQL Action
Runs an SQL statement on an external database.
The SQL Action can be utilised to insert data into an external database system.
An External Database Connection must have been established via 'Provision | External Connections'.Â
There are serious security implications when setting up an External Database Connection so this option should be discussed with Noojee support before proceeding.
Fields
Campaign Template
The Campaign Template that this action will pull fields from.
External DB Connection
The external DB connection to be utilised.
Call
Name of the stored procedure to be called.
e.g. mystoredproc
Value List
The value List can contain a comma separated list of encoded fields names that are passed to the stored procedure.
e.g.
${njLeadId}, ${phoneNo}, ${surname}, ${njDispositionAction}
This will result in a SQL call of the form:
call mystoredproc("1","0383208100", "Smith" "Sale")