I've been trying for the longest to figure out how to import survey results from Qualtrics into Power BI using Python. Qualtrics support has given me code and I was told all I needed to do was change the apiToken, surveyId, fileFormat and dataCenter lines below but I have not been able to get this to work:
# Python 3
import requests
import json
import io, os
import sys
import pandas
from pandas.io.json import json_normalize
# Setting user Parameters
apiToken = '[ID]'
surveyId = "[ID]"
fileFormat = "csv"
dataCenter = ‘[Datacenter]’
# Setting static parameters
requestCheckProgress = 0.0
progressStatus = "inProgress"
baseUrl = "https://{0}.qualtrics.com/API/v3/surveys/{1}/export-responses/".format(dataCenter, surveyId)
headers = {
"content-type": "application/json",
"x-api-token": apiToken,
}
# Step 1: Creating Data Export
downloadRequestUrl = baseUrl
downloadRequestPayload = {"format": fileFormat, "compress": False, "useLabels": True}
downloadRequestResponse = requests.request("POST", downloadRequestUrl, json=downloadRequestPayload, headers=headers)
progressId = downloadRequestResponse.json()["result"]["progressId"]
print(downloadRequestResponse.text)
# Step 2: Checking on Data Export Progress and waiting until export is ready
while progressStatus != "complete" and progressStatus != "failed":
print ("progressStatus=", progressStatus)
requestCheckUrl = baseUrl + progressId
requestCheckResponse = requests.request("GET", requestCheckUrl, headers=headers)
requestCheckProgress = requestCheckResponse.json()["result"]["percentComplete"]
print("Download is " + str(requestCheckProgress) + " complete")
progressStatus = requestCheckResponse.json()["result"]["status"]
#step 2.1: Check for error
if progressStatus is "failed":
raise Exception("export failed")
fileId = requestCheckResponse.json()["result"]["fileId"]
# Step 3: Downloading file
requestDownloadUrl = baseUrl + fileId + '/file'
requestDownload = requests.request("GET", requestDownloadUrl, headers=headers, stream=True)
#data = json.loads(requestDownload.content)
#df = json_normalize(data['responses'])
data = requestDownload.content
df = pandas.read_csv(io.StringIO(data.decode("utf-8")))
df
I'm not a developer nor do I have Python experience, so I have no clue what I would need to change to get what I'm looking for. I'm slightly confused because this seems to be code for exporting results to a CSV, but I was hoping to connect straight from Power BI to Qualtrics.
