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

The SQL statement that is to be executed. The call statement uses positional replace args '?'.

e.g.

call mystatement(?,?,?,?);

Value List

The value List MUST contain a comma separated list of encoded fields names. The number of fields MUST match the call statements '?' arguments.

e.g.

${njLeadId}, ${phoneNo}, ${surname}, ${njDispositionAction}