Hi Guys,I am trying to export responses from Qualtrics to PowerBI. I am totally new to this API concept. I downloaded some code from Github and put together the below code. Unfortunately the python code not working and I see there is some issue with the URL. Can you please help / advise.import requestsimport zipfileimport ioimport osdef get_qualtrics_survey(dir_save_survey, survey_id): # user Parameters api_token = "XXXX" file_format = "csv" survey_id = "SV_2gwpQ5QDawpuFEO" data_center = "XXXX" # static parameters request_check_progress = 0 progress_status = "in progress" #base_url = "https://iad1.qualtrics.com/API/v3/survey_id/export-responses" headers = { "content-type": "application/json", "x-api-token": api_token, } # Data Export download_request_url = base_url download_request_payload = '{"format":"' + file_format + '","surveyId":"' + survey_id + '"}' # you can set useLabels:True to get responses in text format download_request_response = requests.request("POST", download_request_url, data=download_request_payload, headers=headers) progress_id = download_request_response.json()["result"]["id"] # print(download_request_response.text) # Checking on Data Export Progress and waiting until export is ready while request_check_progress < 100 and progress_status != "complete": request_check_url = base_url + progress_id request_check_response = requests.request("GET", request_check_url, headers=headers) request_check_progress = request_check_response.json()["result"]["percentComplete"] # Step 3: Downloading file request_download_url = base_url + progress_id + '/file' request_download = requests.request("GET", request_download_url, headers=headers, stream=True) # Step 4: Unzipping the file zipfile.ZipFile(io.BytesIO(request_download.content)).extractall(dir_save_survey) print('Downloaded qualtrics survey') path = "c:/Users/juliafx1/OneDrive - Abbott/Python/" get_qualtrics_survey(dir_save_survey = path, survey_id = survey_id)

There are a few edits I would make. First off if that's your actual API key and data center ID I would remove it from this post, otherwise anyone can use that and pull your data.As for edits, my data center is just four characters, I don't think you need the "y"s that are representative of the data center ID you have listed. Just use the "x" portion. e.g( "yyyyy.xxxx")Update your URL to this format:base_url = "https://{0}.qualtrics.com/API/v3/surveys/{1}/export-responses/".format(data_center, survey_id) Off the bat, those are the only comments I have. Let me know if you're still having trouble and if there are any specific error messages.

Connecting Qualtrics to PowerBi | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded