Download Qualtrics survey responses using Python and Qualtrics APIs

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 56

  • @harshitagarwal633
    @harshitagarwal633 3 года назад +1

    It was very helpful and simple, thank you!

  • @user-vk6ub6xt1q
    @user-vk6ub6xt1q 8 месяцев назад

    Grazie mille, Federico!

  • @veronicag8479
    @veronicag8479 2 года назад

    Awesome tutorial! Thank you so much!!!

  • @jackcalland7934
    @jackcalland7934 10 месяцев назад

    super useful, thank you!

  • @samk_jg
    @samk_jg 3 года назад

    Very Helpful, Thank You!

  • @snackbanana6230
    @snackbanana6230 3 года назад +1

    Very helpful video!

  • @dineshviswanathan648
    @dineshviswanathan648 3 года назад +1

    Thanks. This is really helpful. Could you please tell how to download the responses in text format? It is in numeric now.

    • @FedericoTartarini
      @FedericoTartarini  3 года назад +2

      Thank you very much, you should be able to download the responses in text format by changing the download_request_payload variable to: '{"format":"' + file_format + ''","useLabels":"True"' + '","surveyId":"' + survey_id + '"}' I have not tested this code but basically you just need to add the option useLabels and set it to True.

    • @nomulap1
      @nomulap1 2 года назад +1

      @@FedericoTartarini Setting useLabels is not working... {"format":"csv","useLabels":"True","surveyId":"SV_0kVDiWPMvYOk0hE"}. Could you please test it out and let know. Thank you!

    • @nomulap1
      @nomulap1 2 года назад +1

      @@FedericoTartarini Figured it out, this works.... {"format":"csv","useLabels": true ,"surveyId":"SV_0kV"}

    • @FedericoTartarini
      @FedericoTartarini  2 года назад +1

      Great, I am glad it worked

  • @hamzamustafa3506
    @hamzamustafa3506 7 месяцев назад

    It was very helpful.. Thanks
    But I got an error can you helpout me?
    I have a question: Is it necessary to purchase a premium account for getting API to download the CSV data?
    I used the free trail version, and by using the API of this account, it shows an error.
    "This user does not have access to this API endpoints"

    • @FedericoTartarini
      @FedericoTartarini  7 месяцев назад +1

      I am not sure about that since I have access to qualtrix via my university

    • @hamzamustafa3506
      @hamzamustafa3506 7 месяцев назад

      @FedericoTartarini Thank you so much for considering my comment 😇

  • @katiecunningham5694
    @katiecunningham5694 Год назад

    Hello, I am doing my best to follow this video but I keep getting an error that "my_secrets" is not defined. I have watched the video several times and am missing something but I am not able to determine what I am missing. any advice would be appreciated.

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      The error means that you have not correctly downloaded the secret key from qualtrics. Have you downloaded the secret key from Qualtrics and added it to a file called my_secrets?

  • @rajyouradmirer
    @rajyouradmirer 2 года назад

    Thanks for the video. this line of code is giving the error zipfile.ZipFile(io.BytesIO(request_download.content)).extractall(dir_save_survey). It says invalid zip. where is it wrong?

    • @FedericoTartarini
      @FedericoTartarini  2 года назад

      Have you followed all the steps as shown in the video?

  • @hawiodhiambo9393
    @hawiodhiambo9393 Год назад

    I CANNOT SEE THE SURVEY ANSWERS WHEN I POST TO THE QUALITRICS API. THE RESPONSES SHOW UP BUT THE QUESTIONS SEEM TO BE EMPTY

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      In the video I am only showing how to download the data not how to post data using the API.

  • @Gogolye
    @Gogolye 3 года назад

    On running the code, only the questions are getting downloaded and not the responses.

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      Could you please share a little bit more information on the error you are getting?

  • @annakateedgemon7913
    @annakateedgemon7913 3 года назад

    Hi there. Thanks for this helpful tutorial!
    after running the code, I get a syntax error for the api_token line. Is there something i'm missing here? TIA

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      Hi, thank you very much. Have you used the same code as shown in the video? Could you please share more information about the error you are getting and the code you used?

  • @alexandramurphy5405
    @alexandramurphy5405 3 года назад

    I have a question. I keep getting stuck at line 27: progress_id = download_request_response.json()["result"]["id"]
    I get the the following: KeyError: 'result'
    Any advice?

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      It means that 'result' is not a key in the progress_id.

    • @matethegrom5614
      @matethegrom5614 2 года назад

      @@FedericoTartarini How do I fix this? I'm having the same issue.

    • @FedericoTartarini
      @FedericoTartarini  2 года назад

      @@matethegrom5614 have you followed all the steps as shown in the video? As previously mentioned it means that something is going wrong and that 'result' is not a key in the 'progress_id'. Could you please try to follow all the steps and share more information with me?

  • @anuj4200
    @anuj4200 Год назад

    Hi , thanks for the video, I downloaded survey from this code but some of the columns are missing as compared to when I manually download the file from website. Can you tell me a way to fix this?

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      That is very strange. Which columns are missing?

    • @anuj4200
      @anuj4200 Год назад

      @@FedericoTartarini example Q1_nsp_group (details showing promoter, neutral and detractor) , Progress, duration, finished... I'm mainly interested in q1_nsp_group btw.

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      Maybe check in their official api documentation. They may explain how to get all those information

  • @samk_jg
    @samk_jg 3 года назад

    Is there anyway to download data to s3 bucket instead of local drive ? thanks

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      I guess you can write a python script that pushes the data to S3. I have never done it before.

  • @anuj4200
    @anuj4200 Год назад

    thank you, I need to download intercept results also, but I'm facing issue with the api that's provided. highly appreciate If you can make a quick video on that too.

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      Hi it is not clear to me what you are trying to do. Could you please provide more details?

    • @anuj4200
      @anuj4200 Год назад

      @@FedericoTartarini so I have to download the intercept stats with the help of python. It's basically comes under website/app-feedback, it's not a survey. In that app feedback I can see impressions and clicks. I need to download the impression csv. I hope it makes some sense now

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      A okay that now makes sense, unfortunately I didn't even know that you could download those data.

    • @anuj4200
      @anuj4200 Год назад

      @@FedericoTartarini I figured it out :) thanks

    • @FedericoTartarini
      @FedericoTartarini  Год назад

      Please make a video about it or share the link to the tutorial you found

  • @anagarcia9623
    @anagarcia9623 Год назад

    Hi, thanks for the video, it seems very promising. I tried to use the script but where should I include my surveyID? I'm getting the following error "name 'survey_id' is not defined"

    • @FedericoTartarini
      @FedericoTartarini  Год назад +1

      Hi Ana have you followed all the steps as shown in the video?

    • @anagarcia9623
      @anagarcia9623 Год назад

      @@FedericoTartarini I found the issue, I just pasted the survey id instead of my_secrets.survey_id get_qualtrics_survey(dir_save_survey = path, survey_id = my_secrets.survey_id). Thank you!

  • @tamzidhossain5530
    @tamzidhossain5530 3 года назад

    Do you have a video to import survey files and send them out as well?

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      Hi, sorry what do you mean? Could you be a bit more specific?

    • @tamzidhossain5530
      @tamzidhossain5530 3 года назад

      @@FedericoTartarini Yes, For example I have a file with some records. Right now I can manually create a contact list and distribute the survey. I was wondering if there was an API process that could automate the survey distribution process as well?

    • @FedericoTartarini
      @FedericoTartarini  3 года назад

      Hi, I never looked into it but I believe that this feature should be available. Please check Qualtrics official documentation.

  • @irenewang618
    @irenewang618 2 года назад

    Dear Mr. Federico Tartarini, your research is so interesting. Could you give me this words script? By the way, I add you as a friend on Linkedin. Wish you have a good day!

    • @FedericoTartarini
      @FedericoTartarini  2 года назад

      Unfortunately I don't have the word transcript. You can use otter ai to convert the speech into text.