I would like to use Qualtric API to export the mailing list to an excel file via Power Query. I tried to use the code from below thread but when I try the code in excel, it returns "Token Comma Expected" error and highlight [i]null. Does anyone know how to make the code works or is there other alternative that could export the mailing list to an excel file without exporting it manually through the dashboard?
https://www.qualtrics.com/community/discussion/6065/how-can-i-export-mailing-list-contacts-via-api-call
Thank you.
Userlevel 4
+18
I am not sure about power query but have tried the 'list contacts in a mailing list' API. The response received is in json format, which can be saved as a file and then use a json to csv/excel converter to convert the download json response to csv/excel file.
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.