Export mailing list via API call

squmaksqumak Community Member Qubie ✭

Export mailing list via API call

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.

Answers

  • MishrajiMishraji IndiaCommunity Member Guru ✭✭

    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.

Sign In to Comment