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
Page 1 / 1
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.
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.