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 · Accepted solution]

Hi Vivek,

I think it is returning the correct values only.

1) You have set a limit on number of records to be returned to 10 in REST Explorer (sysparam_limit). Please remove that to see if you get all records you want.

2) Your table in the 3rd snapshot shows it has values as numbers (4) also. So the String value returned as 8 or 1 can be valid.

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

Thanks

Antin

[vivektietkumar]

Thanks. But there is either an option to export one record or ten no option to export all records. The problem of hitting the right table is solved I think. So I am marking this thread as closed for now. I might have a different question later. thanks for your help!