I’m making an API with a service that calls the MailChimpAPI. Right now I can extract the data of all campaigns with all the stats from the campaigns, but I wan’t to show (this is for a Power BI and an Excel with Power Query) the members of a campaign that clicked the email, with their info.

I’ve searched the MailChimp API and the link I need to use is:

GET /reports/{campaign_id}/click-details/{link_id}/members

I tested the url on Postman and everything okay, but the problem comes from the link_id, If a want to retrieve the data of all campaigns I need to know the link_id of each one, and I don’t know how to get that id without searching manually.

Because I want to retrieve the data of all campaigns. with the people that clicked on the email, but for each campaign. I hope I gave enough information, but let me know if i’m not explaining something right.