Qualtrics API/Python Script

Anonymous — Wed, 19 Jun 2019 14:28:51 GMT

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")))

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.

topic Qualtrics API/Python Script in Developer

Qualtrics API/Python Script