What is the API URL to retrieve all the survey responses | XM Community
Solved

What is the API URL to retrieve all the survey responses

  • 1 April 2021
  • 8 replies
  • 2402 views

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.

icon

Best answer by TomG 1 April 2021, 21:47

View original

8 replies

I got it Tom, Thank you for your support.
{"format": "json","compress": "false"}

Tom, can you through light on this please?

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?

Userlevel 7
Badge +27

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

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

Userlevel 7
Badge +27

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.

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?

Userlevel 7
Badge +27

See: https://api.qualtrics.com/api-reference/reference/responseImportsExports.json

Leave a Reply