Customer Relationship Management Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
cancel
Showing results for 
Search instead for 
Did you mean: 
hettenahalli
Explorer
In 2008 release SAP has released pre-packaged integration between Qualtrics and SAP Sales Cloud and SAP Service Cloud(SAP Cloud for Customer), in this blog will see how to implement the integration feature "Service Ticket from Survey Response" in step by step.

Feature Overview


By using feature Service Ticket from Survey Response , customer can map the Qualtrics survey response to create a ticket in Service Cloud if the survey response score is less or its submitted in a negative way.

Let's start the configuration.

Configure SAP Service Cloud (SAP Cloud for Customer).


Create communication system


Log on to SAP Service Cloud as an Administrator and navigate to work center Administrator -> General Settings -> Integration -> Communication system

Create a new communication system by entering the ID, Host Name as Qualtrics host name .

Save and Activate it.


 

Create Communication Arrangement called OData Services for Business Objects ->Select "OData Services for Business Objects"


 

Select Communication system created in the previous step.


 

Select the Authentication method, you prefer ( User ID and Password will be used in this example)

Click on Edit Credentials -> Depending on the chosen authentication method, you need to upload a certificate or define a password for the communication user.

Note : Please keep a note of User Name and the Password , which will be further used in SAP Cloud Integration/CI tenant to authenticate the SAP Service Cloud while creating a ticket

Select the Contact, Customer, Ticket OData Service's,

Contact and Customer are required to look for an Customer based on the contact to link the ticket being created by Survey response and Ticket service to create a Service Request in SAP Service Cloud


 

Review the maintained configuration and click on the finish to complete Service Cloud configuration.


 

Now we are done with SAP Service Cloud configuration , so lets configure the source system which is Qualtrics.

Configure Qualtrics


First will see how to get the User API token

Log in to Qualtrics tenant -> click on user icon -> Account Settings


 

Click on Qualtrics ID's and look for an API token.


 

Create an Account in Qualtrics


Have an User ID and Password of the SAP CI tenant , as this integration uses basic authentication between CI and the Qualtrics, if not please create a technical user which can be used by all Survey configurator

Login to Qualtrics with Admin roles -> click on Admin -> Extensions -> Look for SAP Customer Experience App

 


Open the SAP Customer Experience App and click on add account


Enter the SAP CI User Name and Password


 

Configure SAP Cloud Integration / CI


Log on to SAP Cloud Integration

First will configure the needed Security Artifacts

Configure SAP Service Cloud user credentials which are created in the communication arrangement

Go to Operation view and click on the Security Material tile


 

Click on Create -> User Credentials


 

Enter the User Name and Password , which created in SAP Service Cloud Communication Arrangement and Deploy the credentials


 

If the Authentication selected as SSL Certificate in SAP Service Cloud , please find the CI help link to configure CI

Lets create the Secure Parameter, which is needed to update the Ticket ID and Ticket Status back to Qualtrics.

Take the Qualtrics Survey Configurator/Admin or Collaborator API token, please find the Configure Qualtrics section to know about how to get API token in Qualtrics

Again go to Overview->Manage Security Material and Create Secure Parameter



 

Fill all the entries and keep a note of Secure Parameter Name, which will be used in the below section to configure the integration flow


 

Now let's configure integration flows

Navigate to Discover and look for the SAP delivered integration package called "Qualtrics Integration with SAP Sales Cloud and SAP Service Cloud" and Open it


 

Copy to your CI tenant


 

Go to Design page and find the copied package with the same


 

For this Integration feature, we need to configure the two integration flows, which are "Get Code Description from SAP Service Cloud" and "Create Service Ticket in SAP Service Cloud"

Open the integration flow "Get Code Description from SAP Service Cloud" and click on Configure



Choose the Receiver as SAP Service Cloud, Enter the target SAP Service Cloud URL and enter the credential name which is configured in the above

Save and Deploy it


 

will configure another integration flow called "Create Service Ticket in SAP Service Cloud"

Open the integration and click on configure


 

Choose the Receiver as SAP Service Cloud, Enter the target SAP Service Cloud URL and Enter the Credentials name which is created in the above step.

 


Choose the another Receiver as Qualtrics and enter the Qualtrics tenant/brand URL

 


Navigate to More tab and enter the Secure Parameter name which is created in the above step

Save and Deploy the integration flow


Now the integration flows are deployed, collect the end point which will further used in Qualtrics Create Service Ticket task.

Go to Overview -> Manage Integration Content and look for Qualtrics , Select the integration flow "Create Service Ticket in SAP Service Cloud"


 

Now the integration set up is completed, so lets test it out

Log in to Qualtrics and create a survey with embedded data fields which can hold SAP Service Cloud Ticket ID and Status

Click on the Create new projects


Select Survey


 

Give a name to Survey, Qualtrics has some good predefined survey so lets import from there, Click on from library and choose library as from Qualtrics Library and source project as Customer Research -> Customer Satisfaction and further click on get started , so that Qualtrics will create a survey for you with all predefined questions


Open the created survey go to Survey Flow


Click on Add a new element here -> Click on Embedded Data


Create two embedded data fields called C4CTicketID and C4CTicketStatus to receive the Ticket ID and Ticket status from SAP Service Cloud


Now lets configure the SAP Customer Experience Action task will be triggered for an response event, so that if any users respond to this survey , the action task will create a ticket in SAP Service Cloud.

go to Actions -> Editor ->Add Action -> Event Based -> Choose Event as -> Survey Response -> Response Created


We have NPS question in our survey , which asks the user to How he/she would recommend our company to friend or colleagues in the scale of 0 to 10.

so lets create ticket in SAP Service Cloud, if user answers less than 6 which is detractor value, where user was not happy with the company and create ticket to follow up further by using our Customer Experience Action task

so set up the condition as below


 

Now finally will add Customer Experience Action task to create a ticket , if the above condition is met

Click on Add Task and Select Customer Experience App


Select Create Ticket and click Next


Choose the SAP CI Account which we added earlier, this account credentials used to make a call to SAP CI tenant


Now we can add ticket related information , which will be ticket subject , type, priority and long description, below are the few more details about all the fields

  1. Tenant URL (Mandatory): The CI iFlow endpoint URL needs to be mentioned here.

  2. Type (Mandatory): This is the Ticket type with which the Ticket gets created in SAP Service Cloud.

    1. Note – In SAP Service Cloud, the ticket types are configurable and hence, it is fetched dynamically at runtime, by making a call to the CI iFlow endpoint. Without entering the valid “Tenant URL”, Ticket type dropdown will not show any values.



  3. Subject (Mandatory): This is the subject of the Ticket, either a fixed value can be provided here OR piped from the Survey response

  4. Priority (Mandatory): This is the Priority for the Ticket that gets creatd in SAP Service Cloud.

    1. Note – The Ticket Priority is fetched dynamically at runtime, by making a call to the CI iFlow endpoint. Without entering the valid “Tenant URL”, Ticket priority dropdown will not show any values.



  5. Email: This field holds the email id, which is used to determine the SAP Service Cloud account/contact, it is mandatory if Connect ticket to existing SAP Cloud for Customer account and/or existing contact is checked.


Note: it will be defaulted with the Qualtrics standard embedded data field ‘${m://Email}’, value of this field can be changed to suit any other specific requirement.

  1. Description: This is the description (long text) for the Ticket that gets created in SAP Service Cloud. either a fixed value can be provided here OR piped from the Survey response.

  2. Connect ticket to existing SAP Service Cloud account and/or existing contact: This parameter controls the whether the Customer involved with the Survey response needs to be determined in the corresponding SAP Service Cloud Tenant while generating the ticket. If this check-box is enabled, the following customer determination process is triggered, of which there are 2 variants:

    1. B2C Scenario: The Qualtrics Survey response recipient email ID is used to perform a lookup of an existing “Individual Customer” on SAP Service Cloud. If it’s found, then, the Customer is associated to the Ticket being created.

    2. B2B Scenario: The Qualtrics Survey response recipient email ID is used to perform a lookup of an existing “Contact” on SAP Service Cloud. If it’s found, then, the main “Account” of this Contact is associated to the Ticket being created.




Note - If no Customer OR Contact is found with the Qualtrics Survey response recipient email ID, then, no customer determination happens on SAP Service Cloud. Also, customer record is NOT created if it’s not found.

  1. Link SAP Cloud for Customer Ticket to Qualtrics Survey Response: This controls whether the generated SAP Service Cloud Ticket ID and Status is updated back to the Survey Response.


 

Now lets add the CI iflow endpoint which we deployed earlier and this end points will bring all the configured the Ticket Type and Priority list from SAP Service Cloud


 

If then below error comes then the entered endpoint is invalid, so please check the call log in CI and fix the issue.


So now we have Ticket Type and the Priority lists , we are good to configure other values to create to ticket ,

In the Email field, the default place holder '${m://Email}' will be resolved to recipient email id and also you can either enter it or pipe it from the embedded data/survey question answer

In the Description field, I have piped a Survey question answer so that entered answer will be captured as description of the ticket

Action task configuration should be looks like this


 

Final Action workflow should be looks like this


 

Before distributing the Survey, don't forget to Publish the survey


Distribute the Survey to Contacts


Fill the Survey , while filling the survey, I have submitted NPS score as 4 and given some description


Now will check the Ticket which created in SAP Service Cloud

Quick Create View


 

Ticket TI Screen View


 

Short Summary:-

In this blog we learned to integrate SAP Service Cloud and Qualtrics using SAP Cloud Integration , to map any Qualtrics Survey Response to create a Ticket in SAP Service Cloud to capture the Survey data.