How to get survey responses in CDS

(3) Share

Report

Posted on by Welly Lee

Today, we rolled out new field in "Customer Voice survey responses" entity (msfp_surveyresponse) that stores the individual question responses in your survey.

The survey question response continues to be stored to "Customer Voice survey question responses" and the new field provides an alternate way to get to the information. With this new change, for example, you can directly get the response to the survey questions from survey response as follows:

The details of the survey response is stored in JSON format with an example schema as follows:

{

"type": "array",

"items": {

"type": "object",

"properties": {

"questionId": {

"type": "string"

"response": {

"type": "string"

}

"required": [

"questionId",

"response"

]

}

The changes is part of the CDS solution update version 2.0.0.8

Hope this will make it easier for you to create report and follow up workflow for Customer Voice survey responses

I have the same question (0)

All responses (8)

Answers (0)

Megan V. Walker 1,841 Most Valuable Professional on at

Like (1)

Report

Looks like a new blog post needs to be written.... on it
Welly Lee on at

Like (1)

Report

Looking forward to reading the latest blog post on https://meganvwalker.com/
Mattw112b 387 on at

Like (1)

Report

Thanks Welly. I just did this and the questions come as long IDs. What is best way to pull down the plain text? For example:

[

{

"questionId": "rf60d791170744cfd95c856f01c0688df",

"response": "1"

},

{
Welly Lee on at

Like (1)

Report

You will need to join with msfp_question (msfp_questionid)
Megan V. Walker 1,841 Most Valuable Professional on at

Like (2)

Report

New post just published here: https://meganvwalker.com/sending-notifications-from-the-details-of-survey-responses/ - with corresponding video here: www.youtube.com/watch
jamiehandelman 5 on at

Like (0)

Report

Hello - Thanks for this! I am having issues with the trigger - I am doing it on create on the Customer Voice Survey Responses just as you are. It's not recognizing when I am submitting a survey. I added a trigger condition as follows @equals(triggerBody()?['_msfp_surveyid_value'], 'SURVEY ID') and I don't have any filter queries. I cannot get it to work and I am wondering if you have any ideas! Thanks.
Welly Lee on at

Like (0)

Report

jamiehandelman -- you can use the following trigger

@equals(triggerBody()?['msfp_sourcesurveyidentifier'], '<Form ID>')

and get the form ID from the survey URL below
Home Depot 2 on at

Like (0)

Report

You will need to join with msfp_question (msfp_questionid). After the minor changes, we can get more responses through this survey, check out Home Depot Survey.