Response export without file? | XM Community
Skip to main content
Question

Response export without file?

  • August 13, 2021
  • 1 reply
  • 63 views
D
Forum|alt.badge.img+1

I'm using PowerShell to get response exports and load them into a database. Right not, my process is to generate the file, download it to my computer, then process the results. Has anyone figured out how to do this without downloading the file? That step is slow and cumbersome, and I'd rather just be able to process everything in memory.
I'm using this
https://api.qualtrics.com/guides/reference/responseImportsExports.json
And this basic process
http://codecaching.blogspot.com/2017/01/powershell-retrieving-qualtrics-survey.html

Abhishek_U

1 reply

JeremyK
Level 3 ●●●
Forum|alt.badge.img+7
  • JeremyK
  • Level 3 ●●●
  • September 3, 2021

PowerShell should be able to handle that, no problem. In that blog post, once you hit the $response variable, there's your object with the entire response export data. It's not too much of a stretch to parse the data and insert into your desired databases, all from memory. I've done something similar with csv, processing in memory and then pushing up to an Azure Storage blob.

Terms & ConditionsAccessibility statement