What is the API URL to retrieve all the survey responses

ngsankarngsankar Community Member Qubie ✭
edited April 5 in Qualtrics API

What is the API URL to retrieve all the survey responses

I am unable to find the correct URL to retrieve all the survey responses in JSON format, can someone help me with this? Thanks in advance.

Best Answer

  • TomGTomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭
    Accepted Answer

    You can set the compress parameter to false on the start response export call.

Answers

  • TomGTomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭
  • ngsankarngsankar Community Member Qubie ✭

    Thank you Tom for your response.

    The shared link will only allow downloading the survey responses in a file.

    I want the Survey responses directly in API response JSON format so that I can remove the unnecessary columns programmatically(DOMO) before sending them to the target systems.

    Can you share your thoughts on how to achieve my use case?

  • TomGTomG Raleigh, NCCommunity Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭

    One of the export formats is json. So when your script exports the json file it would read it, process it, and send it to the target systems.

  • ngsankarngsankar Community Member Qubie ✭

    When I am trying to execute the API through PostMan, The data which is showing in the results is not in a readable(special characters) format because the file is zipped format.

    below are the details that i am using it in Postman

    GET:

    https://lxxxx.co1.qualtrics.com/API/v3/surveys/xxxxxxx/export-responses/xxxxx/file

    BODY:

    {"format": "json"}

    Authorization: Bearer token

    Headers: Content-Type application/json.


    I don't want the data to be exported in file, wanted in a data as response JSON .


    I hope i am making some sense here, I am pretty much new to this. Please corret me

  • ngsankarngsankar Community Member Qubie ✭

    Thank you, Tom, can you tell me where I should add the parameter? do you have any syntax like adding at the headers section or URL?

  • ngsankarngsankar Community Member Qubie ✭

    Tom, can you through light on this please?

  • ngsankarngsankar Community Member Qubie ✭

    I got it Tom, Thank you for your support.

    {"format": "json","compress": "false"}

Sign In to Comment