Data Connector applet

Data Connector applet

The Data Connector applet retrieves data from or sends data to Salesforce, an external web service, or a client's bespoke system. This data is then available in the form of a Data Source for use in subsequent applets in the interaction plan:

Data retrieved by Data Connector applets is also available for use by Data Source Mappings. For information about Data Source Mappings, see Data Source Mappings. Data Source Mappings can subsequently make data available to Dashboards. For information about viewing mapped data source data in Dashboards, see Viewing mapped data source data in Real-time Analytics.

Vonage Contact Center uses account feature toggles to enable reading and writing of data in external sources other than Salesforce. This page describes the functionality available using the Salesforce and Web Service interfaces. For information about how to use the Data Connector with custom interfaces, please contact support.

In this page

Interfaces

For information about using the Data Connector applet with the various interfaces, see the following pages:

All interfaces

Interface

FieldOptionsDescription
Interface

List of available interfaces

(in most cases just Salesforce and Web Service)

The interface to use to retrieve or send data.

Interface failureList of available applets

For most interfaces, the applet that the call is routed to if the applet cannot connect to the interface or the interface returns an error.

For the Web Service interface, the applet that the call is routed to if the applet cannot connect to the external API. The Data Connector applet will try to connect to the API for 10 seconds before timing out.

Action

(The availability and content of this section is determined by which interface you choose and the features enabled for your account.)

FieldOptionsDescription
Action

List of operations available in the selected interface

Based on the interface, available actions to perform. Subsequent sections' content depends on the operation you choose. In the case of CRMs, if record creation and update are available for your account, you can switch between data retrieval, data sending, and record creation and update.

Use SOQLSelect, clear

Only available if you select Salesforce in the Interface list and if enabled for your account, and you select Get Salesforce Data in the Action list.

Select Use SOQL to use SOQL to retrieve the required Salesforce data.

For more information, see Retrieving data from Salesforce using Salesforce Object Query Language (SOQL).

Interface specific fieldsVariesUse custom fields to identify the value or values that the applet must use to identify the appropriate record or records.

CRMs (Google, Microsoft Dynamics, Salesforce, Salesforce (VGIP), Zendesk) only

(Salesforce) Match

FieldOptionsDescription
(Salesforce) ObjectList of available CRM objects

The CRM object containing the field you are comparing to and the fields you want to retrieve.

*Find Salesforce record(s) usingCLID, Data Source, IVR Slot

Available only for get Salesforce data actions

The source of the data to use to locate the appropriate Salesforce object record.

Select CLID to use the caller's phone number to compare all phone number fields in the selected Salesforce object to find a match.

Select Data Source to use a data source to find a match in a specific Salesforce field.

The data source can be anything previously retrieved by a Data Connector, including the dialed number, the caller's number (CLID), the call's unique GUID, or the interaction's external ID (such as Call Id or Salesforce Case number depending on the type of interaction). Visibility of the external ID may depend on your account options.

If you select Data Source in the Find Salesforce record(s) using field, the list in the Match data source field, in which you select the actual data source to use, contains both IVR slot and data source names. IVR slot names are prefixed with 'IVR Slot|'. If you want to use an IVR slot value, we recommend that you select Data Source in the Find Salesforce record(s) using field and then select the IVR slot name in the Match data source field.

Select IVR Slot to use the value stored in an IVR Slot to find a match in a specific Salesforce field.

Match data sourceList of available data sources

The specific data source that contains the value you want to use to locate the appropriate CRM record.

against (Salesforce) fieldList of available CRM fieldsThe CRM field to use to match with the specified value to identify the required record.

Matched records

FieldOptionsDescription
Retrieve multiple recordsSelect, clear

Determines whether or not to retrieve multiple records if multiple records are matched. For more information about retrieving multiple records, see the Retrieving multiple records section below.

Select Retrieve multiple records to retrieve multiple records.

Maximum number of recordsNumber

The maximum number of records to retrieve. This field only appears if you select the Retrieve multiple records check box.

If more than the maximum number of records are matched, not all records are retrieved. The order in which records are retrieved is not guaranteed.

If fewer than the maximum number of records exist, then all of them are retrieved.

Add field to retrieveList of available fieldsSelect a field or fields to retrieve from the matched record or records.

 Retrieving multiple records

The following table shows the next applet that the call is routed to at runtime as determined by multiple record settings.

Retrieve Multiple Records?

Maximum Number to Retrieve

Number of matches

Number of records retrieved

Next applet
No
00No (Salesforce) match
No
11Successful action
No
2 (or more)0Multiple (Salesforce) matches
Yes500No (Salesforce) match
Yes522Successful action
Yes57 (or more)5Successful action

The next table shows the data sources made available by this applet to subsequent applets. In this example, this applet retrieves Account ID and Contact ID.

Retrieve Multiple Records?

Maximum Number to Retrieve

Data Source choices in Data Source fields in subsequent applets
No
Contact | Account ID 
Contact | Contact ID
Yes5

Contact | Account ID 01
Contact | Account ID 02
Contact | Account ID 03
Contact | Account ID 04
Contact | Account ID 05
Contact | Contact ID 01
Contact | Contact ID 02
Contact | Contact ID 03
Contact | Contact ID 04
Contact | Contact ID 05
Contact | Record Count 

Create (Salesforce) record

You must also have this feature enabled for your account.

FieldOptionsDescription
ObjectList of available CRM objects

The CRM object that you want to create.

Select the name of the object to create. Add Field appears.

Add fieldList of fields available for the selected object

The field in the CRM object that you want to populate.

Select the name of the field. The field is added to a table. Source Type and Source appear.

If the selected CRM object contains one or more mandatory fields with no default values, you must provide values. If you do not provide a value for each of the mandatory fields, when you click Update, an error message or messages appear.

Use Add field to add as many fields as you want to populate. Each time you select the name of a field a new row is added to the table with corresponding Source Type and Source fields.

Source TypeData Source, IVR Slot

Available only for get Salesforce data actions

The type of the source that contains the information you want to populate the field with.

Select Data Source to get the information from the data source that you select in Source.

The data source can be anything previously retrieved by a Data Connector, including the dialed number, the caller's number (CLID), or the call's unique GUID.

If you select Data Source, the list in the Source field, in which you select the actual data source to use, contains both IVR slot and data source names. IVR slot names are prefixed with 'IVR Slot|'. If you want to use an IVR slot value, we recommend that you select Data Source in the Source Type field and then select the IVR slot name in the Source field.

Select IVR Slot to get the information from the IVR sot that you select in Source.

SourceList of available data sources

The specific source of the information you want to populate the field with.

Select the data source.

Update (Salesforce) record

You must also have this feature enabled for your account.

SectionFieldOptionsDescription

ObjectList of available CRM objects

The CRM object that you want to update.

Select the name of the object to update. The Object ID Field and Add Field list appear.

Object ID field

All CRM records have a unique ID. Vonage Contact Center uses the value that you specify in this section to locate the record to update.


Field NameStatic textSalesforce records store their unique IDs in a field. Field Name is the name of the ID field for the selected Salesforce object. Use the next two fields to identify the source of the data for this field.

Source TypeData Source, IVR Slot

Available only for get Salesforce data actions

The type of source that the data you want to use is contained in. Click either IVR Slot or Data Source. The Source list is populated with sources of the selected type.

If you select Data Source, the list in the Source field, in which you select the actual data source to use, contains both IVR slot and data source names. IVR slot names are prefixed with 'IVR Slot|'. If you want to use an IVR slot value, we recommend that you select Data Source in the Source Type field and then select the IVR slot name in the Source field.


SourceList of available data sources

The specific source of the information you want to update the field with.

Select the data source or IVR Slot.

Add field


List of fields available for the selected object

The Add Field list contains the fields available on the selected object. Click the field you want to update. Use Add Field to add and update as many fields on the selected CRM object as you want. Each time you select the name of a field a new row is added to the table with the corresponding Source Type and Source fields.

You must update fields that are required by the CRM object.
Fields to update

Field Name

Static text

Contains the selected field. Use the next two fields to identify the source of the data for this field.


Source TypeData Source, IVR Slot

Available only for get Salesforce data actions

The type of source that the data you want to use is contained in. Click either IVR Slot or Data Source. The Source list is populated with sources of the selected type.

If you select Data Source, the list in the Source field, in which you select the actual data source to use, contains both IVR slot and data source names. IVR slot names are prefixed with 'IVR Slot|'. If you want to use an IVR slot value, we recommend that you select Data Source in the Source Type field and then select the IVR slot name in the Source field.


SourceList of available data sources or IVR Slots

The source of the data. Click the source that contains the data for the field.


SOQL Editor

Available in:

  • Salesforce interface, Use SOQL is enabled

You must also have this feature enabled for your account.

FieldOptionsDescription
Query

The SOQL query that describes what data to retrieve from Salesforce. For information about using SOQL to retrieve data from Salesforce using the Data Connector applet, see Retrieving data from Salesforce using Salesforce Object Query Language (SOQL).

Web Service integration only

Web Service interaction

(Only available if you select the Web Service interface and the Call Web Service action. You must have this feature enabled for your account.)

FieldOptionsDescription
Interaction definition

The XML that describes how to contact and retrieve data from or send data to the external web service. For information about exchanging data with an external web service using the Data Connector applet, see Retrieving data from and sending data to a Web Service.

Interaction definition test
Optionally use the Interaction Definition Test section to test your web service interaction definition in the Interaction Definition field. For information about testing your web service interaction definition, see Testing your web service interaction definition.

Request/response definition

(Only available if you select the Web Service interface and the action contains a template. You must have this feature enabled for your account.)

FieldDescription
Request

If present, the request area contains one or more request parameters. Specify a value for each of the available parameters. You can include placeholders to insert data source or custom configuration values into the request parameters.

For more information, see Retrieving data from and sending data to a Web Service.

ResponseIf present, the response area contains one or more response values that the web service returns. Specify the locator for each of the response values. The value or values are stored in data sources for use later, if required, in your interaction plan. The names of the data sources are defined in the template. You will need to know the names of the data sources to use them.
Resulting Data SourcesIf the web service returns one or more response values, the Resulting Data Sources section appears. Resulting Data Sources displays the created data sources and the data type.

Data sources

Available in:

  • Omni-Channel flows for SCV interface

You must also have this feature enabled for your account.

FieldDescription
Interaction plan name

Type the name of an existing or new data source. This data source will contain the interaction plan that the Salesforce Omni-Channel flow returns. For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Agent ID

Type the name of an existing or new data source. This data source will contain the agent ID that the Salesforce Omni-Channel flow returns. For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Omni-Channel flow integration only

Omni-Channel flow settings

Available in:

  • Omni-Channel flows for SCV interface

You must also have this feature enabled for your account.

FieldDescription
Dialed number

The original number that the caller dialed. Salesforce will use this to determine the Omni-Channel flow to use and the fallback queue if you do not specify them in Flow and Fallback queue.

For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Flow

Optional. The developer name in Salesforce of an existing Omni-Channel flow that you want to route the inbound call to. If you don't already have a flow that you want to use, provide the name when you have created it.

You need to provide a Flow if you have not created a channel in your call center, or if you want to override the Omni-Channel flow used for the dialed number.

For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Fallback queue

Optional. The developer name or ID in Salesforce of the queue to use in case the Omni-Channel flow fails.

You need to provide a Fallback queue if you have not created a channel in your call center, or if you want to override the Omni-Channel flow used for the dialed number.

For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Omni-Channel flow properties

Available in:

  • Omni-Channel flows for SCV interface

You must also have this feature enabled for your account.

FieldDescription
Property name

Provide additional properties that the Omni-Channel flow can use in determining the target interaction plan.

Click Add Row to add more properties.

For more information, see Configuring Vonage Contact Center to use Salesforce Omni-Channel flows.

Value

All interfaces

Routing

FieldOptionsDescription
Successful actionList of available applets

The applet that the call is routed to if the Data Connector is successful:

  • using the CRM interfaces, if the Data Connector finds a match for the chosen object in the CRM
  • using the Web Service interface, if the web service that the Data Connector calls returns a success response (HTTP status codes 2xx).
  • using the Omni-Channel flows for SCV interface, if the Data Connector connects to and triggers the Omni-Channel flow.
Failure actionList of available applets

Available only for the Web Service interface

The applet that the call is routed to if the web service that the Data Connector calls returns a failure response (HTTP status codes 1xx, 3xx, or 4xx).

Multiple (Salesforce) matchesList of available applets

Available only for get CRM data and get Salesforce data actions

The applet that the call is routed to if the applet finds multiple matches for the chosen object in the CRM. This field is only available if you select a CRM interface and is unavailable if you select Retrieve multiple records.


No (Salesforce) matchList of available applets

Available only for get CRM data and get Salesforce data actions

The applet that the call is routed to if the applet finds no match for the chosen object in the CRM. This field is only available if you select a CRM interface.

Support and documentation feedback

For general assistance, please contact Customer Support.

For help using this documentation, please send an email to docs_feedback@vonage.com. We're happy to hear from you. Your contribution helps everyone at Vonage! Please include the name of the page in your email.