How can I export mailing list contacts via API call?

Question

I am needing to export a list of contacts in a mailing list or possibly email the list of contacts to my email. I've searched through the API documentation but could not find anything that would work. Is there a way I can do that without exporting it manually through the dashboard?

JeremyK · Accepted Answer

I found this in the Qualtrics documentation, supposedly it retrieves members in a mailing list. Would it fulfill your needs?Disclaimer: I haven't used this particular API before.

Matt · Answer

I have some code I've developed which you can use in Microsoft Power Query to run the API and bring the contacts into an Excel sheet. Simply open a blank excel workbook, open a blank query and paste this code in the query editor:let iterations = 150, url = "https://Your Qualtrics Data Center Here.qualtrics.com/API/v3/mailinglists/*Mailing List ID Here/contacts", FnGetOnePage = (url) => let Source = Json.Document(Web.Contents(url, [Headers=[#"X-API-TOKEN"="Your API token here**"]])), data = try Source[result][elements] otherwise null, next = try Source[result][nextPage] otherwise null, res = [Data=data, Next=next] in res, GeneratedList = List.Generate( ()=>[i=0, res = FnGetOnePage(url)], each [i]null, each [i=[i]+1, res = FnGetOnePage([res][Next])], each [res][Data])in GeneratedListEnter your data center, mailing list ID ad API token in the spots indicated. This API will bring in up to 15,000 contacts (150 iterations * 100 records per page). If you need to bring in more than 15,000 contacts, simply increase the number of iterations in the second line.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded