Get Value From DB

Get Value From DB

Allows a value to be retrieved from an external database.

To use this Route Step you must have defined an external database connection via the 'External Connections' page (Provision | External Connections).

With an External Connection in place you can make a call to a stored procedure on the external database 

The stored procedure must only return a single row with a single column as defined by 'Result Field'. The value from that column is returned in the Route Variable defined by 'Result Field'.