Delete batch of responses in progress | XM Community

Delete batch of responses in progress


Userlevel 3
Badge +5
  • Level 2 ●●
  • 31 replies

I have the email addresses for 300 out of my 900 responses in progress that I want to delete. I want to record the remaining 600 responses in progress. Will someone please let me know the steps to delete a batch of 300 responses in progress using their email addresses?
Thanks,
Tim


13 replies

Userlevel 7
Badge +36

Tim
Click on Export Data within the response in progress. Delete all the rows of email addresses for whom you don't want to record the session. Use the session id of the rest which comes within ResponseId column of exported file.
image.png
Once you have that file ready. Use this API to delete the session for all session id's by running the API in loop.
Hope it helps!

Userlevel 3
Badge +5

I am using this Delete API - https://yul1.qualtrics.com/API/v3 /surveys/{surveyId}/sessions/{sessionId}
I replaced yul1 with my organizationID.datacenterID and input my surveyID and sessionID
Will you please let me know how to resolve this Postman error -  "errorMessage": "The requested resource does not exist."
Thanks,
Tim

Userlevel 7
Badge +36

Tim
Have you included X-API-TOKEN and Content type in the postman request headers?
Kindly include that and run.
image.pngHope it helps!

Userlevel 3
Badge +5

I am trying to delete one response in progress before doing a batch.
In Params I input my sessionId for the Value
image.pngI set Authorization to Inherit auth from ...
And in Headers I input my API token for the Value
image.pngand I still get "The requested resource does not exist" error. What am I missing?
Thanks,
Tim

Userlevel 7
Badge +36

https://community.qualtrics.com/XMcommunity/discussion/comment/52533#Comment_52533You need to include the X-API-TOKEN from your account settings>API Token
Your API Token will go in the below shown pic. And replace the URL with session ID and survey ID. Choose delete as a method. This worked for me.
image.pngHope it helps!

Userlevel 3
Badge +5

Deleting one response worked by using x-api-token versus x-api-key and content-type application/json. Thank you very much!
Now how do I run this for an excel list / batch of sessionId's?
Thanks again,
Tim

Userlevel 7
Badge +36

https://community.qualtrics.com/XMcommunity/discussion/comment/52555#Comment_52555Tim
The following video should help you in running a csv file in a loop within postman.
Loop Through a Data File | Postman Level Up - YouTube
Hope it helps!

Userlevel 3
Badge +5

I found this https://blog.postman.com/looping-through-a-data-file-in-the-postman-collection-runner/
Create .csv file with list of sessionId’s
Change from a session id to {{sessionId}} and select create value
Run and select the .csv file
and it also worked.
Thank you very much for all your help!

Userlevel 7
Badge +36

Tim
Glad it worked for you!
If the answer was helpful kindly accept the answer.

Userlevel 3
Badge +5

Hi Deepak,
The 2 answers worked however I don't see a button to accept them.
Thanks again,
Tim

Userlevel 7
Badge +36

Tim
Do you see an option as shown in image below?
image.png

Userlevel 3
Badge +5

No I don't see that anywhere.

Userlevel 7
Badge +36

Tim
I think AmaraW can help here.

Leave a Reply