Help with Rest API Survey

[vivektietkumar]

Hi - I need some help with exposing Survey Response through Rest API.   I have designed a survey that has different kinds of questions like multiple choice, rank and text field. Text feild is the one that I am asking users to input comments like - This tool is bad or The tool serves the intended purpose. Please refer to the below screenshot. The string value is what captures the required info.

1 . I have tried the following with no success. Looked in Survey Response table through Rest API

2. Looked in assessment instance

2

I looked into database schemas but still not able to understand why I am not able to capture text in a string value. The assessment instance question has string value column and it's not a

reference field.

[antin_s]

Hi Vivek,

You need to refer to asmt_metric_result table which stores the Survey Results.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

[vivektietkumar]

Thanks But when I pick this table and runt the following Get command

The result I get is:

There is no entry in my table that was created in 2016 and was created by Billie.Cowley

[antin_s]

Can you go to this table (asmt_metric_result) and check if the entries are there?

[vivektietkumar]

sorry for the late reply. I go to this table and open the list. I can see the user Billie.Cowley. But still my query doenst seem to get proper results. THis is my REST API explorer now:

As you can see the string value returned should be ServiceNow, Sharepoint etc But its returning numbers 8 or 1. Also, created date and time here is 2017 while response shows it as 2016. What I am I doing wrong. Thanks in advance.