External Data Access Node
This node accesses data from an external resource and pulls the returned values into a Clarity Connect extra item variable, which can then be referenced throughout the call flow.
How It Works
Select the desired External Data Type. Clarity Connect will prompt for a database connection string or web service URL prior to connecting.
In the query or parameter strings, use the syntax {{VariableName}} to use locally-assigned variables and {{SYSTEM.SystemVariableName}} to speak system-defined variables, including CustomerFullName, CallerPhoneNumber, CustomerIdentifier, and OriginalToUri.
In the Timeout field, enter the number of milliseconds Clarity Connect will wait for the service to respond.
Additional options allow the user to select whether the session sends to the next node upon either an error or call completion, as well as how to handle single, multiple, or no results. The Coalesce node may be used if multiple results are returned from the query.
Clicking Assign Return Values displays all potential return values from the external access call and allows the user to assign them to an extra item by typing the name of the variable.
Extra Items
When creating a query in the call flow editor, use an actual value guaranteed to return results. For example, when querying first names, enter a real name that will return results. After entering the query and allowing it to map, click Assign Return Values and replace the actual value with the extra item syntax.
When performing a query on a database, only SELECT is supported; DROP and DELETE are not supported. The results returned from the external call can be utilized by assigning a VariableName to a result field and then using the syntax {{VariableName}} to access the value elsewhere in the flow.
If no extra item placeholders are present, the node executes the query as is.
Security
SSL 3.0 is supported, along with Transport Layer Security (TLS) versions 1.0, 1.1, and 1.2, but these must be explicitly defined. Clarity Connect supports the security level of the contracted service for HTTP and WCF web services. TLS may not work in conjunction with an older service.
External Data Type
The External Data Access node supports connecting to a SQL Server or ODBC database, Windows Communication Foundation (WCF) Web Service, or a HTTP Web Service.
Figure 1 External Data Type
Database
From the External Data Type drop-down menu (Figure 1), select Database (Figure 2). Additional fields will prompt for both a Database Connection String and the Query to run.
In the Database Connection String field, include the database server URL and database name using the format below.
Data Source={SQL Server URL};Initial Catalog={Your Database};Integrated Security=True
Select the appropriate Connection Type from the dropdown menu.
Enter the query and then click Assign Return Values.
Figure 2 Database Data Type
HTTP Web Service
From the External Data Type drop-down menu, select HTTP Web Service (Figure 3). Enter the full URL for the HTTP Web Service Address, and then click Assign Return Values.
Figure 3 HTTP Web Service data type
WCF Web Service
From the External Data Type drop-down menu, select WCF Web Service (Figure 4). Enter the full URL for the WCF Web Service Address in the additional field and then click Read WSDL. Select Contract and Method from the drop-down list and enter any parameters that should be sent to the service call.
Click Assign Return Values.
Figure 4 WCF Web Service data type
- An existing WCF service is required to use the WCF Web Service data type.
- This node works best with WCF services that accept built-in parameter types. This node does not perform force-verification parameter types. The node attempts to convert whatever is entered in the field to the necessary parameter type. If it fails, the call will be sent to an error node and fail.
- Data is stored along with the parameter name.
- Any .NET data type is supported (no custom data types).
- Lists and numerations are not supported.