Replies posted by candrew | XM Community

Replies posted by candrew

1 Reply

JonesE
Level 4 ●●●●
JonesELevel 4 ●●●●
asked in Qualtrics API

API download of the 'User Submitted Files' zip?

I had a similar issue with uploaded files as well and found that if you use a combination of the Q#_URL, Q#_Name, you could easily automate the download using Excel VBA. From there, you could run a zip on the directory (if you'd like).I created the following which allows you to select the range of files (from the CSV) and in this case, I had other fields that indicated the user's first name (Column C), last name (column D), file extension (extracted from file name (column M)) and the URL for the file (Column P). I then renamed the file in question to: .Sub downloadPictures()  Dim b As Range  Dim rng As Range, fname As Range, lname As Range, ftype As Range, url1 As Range,   Dim filename As String, fname_mask As String, dpath As String, strURL As String  dpath = ""  Set rng = Selection  For Each b In rng.Rows    Dim colnum As Integer    colnum = b.Row    Set fname = Range("C" & colnum)    Set lname = Range("D" & colnum)    Set ftype = Range("M" & colnum)    Set url1 = Range("P" & colnu

9
C
1 year ago

Productivity playlist

Terms & Conditions