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.

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.

Export mailing list via API call | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded