I have never done anything with an API and would even call my programming skills as "light" by most standards. With that said, I am very interested in trying to automate a survey using the Qualtrics API. Having never done this, I am not sure of the process, pitfalls, best practices, etc. Who has already done this and what program(s) did you use? How does it all work together.
Below are my thoughts and I welcome any helpful input anyone has. If I am missing something or am way off base, please let me know.
1. A .csv distribution file will exist somewhere on a regular schedule. It would be ideal if this "somewhere" could be a local drive, but every other automation I have seen uses an SFTP. Is it possible to even use a local drive to point to as part of the API call?
2. I program a script that calls the Qualtrics API and distributes the appropriate email, survey, etc. to the above distribution list. My org is pretty SAS heavy so that is likely what I will try to use unless there is a much better option.
3. I use windows task scheduler to trigger the SAS code on a regular cadence.
4. At this point I am done as the scope of my first program job would be to just automate the distribution and not do anything about pulling the results back.
Best answer by TomG
View original