Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I've used Mailchimp API to connect to both Lists and campaigns, and have been able to get summary info for all email campaigns through this.
The API doesn't return all information, in particular I'd like to return the number of soft bounces for each campaign.
I've tried to use the API to return reports information but struggling with this. Can anyone advice? Id be happy to just get a single report return for a specific campaign ID as a starter.
The power query ive used to get lists information:
let
dc = "ServerInput",
api_url = "https://" & dc & ".api.mailchimp.com/3.0/",
ClientID = "String",
apikey = "ApiKeyString",
EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & apikey), BinaryEncoding.Base64),
path = "lists?offset=0&count=1000/",
data= Json.Document(Web.Contents(api_url,
[ RelativePath = path,
Headers=[#"Authorization"=EncodedCredentials]])),
lists = data[lists]
in
lists
Thanks for the reply, I'm looking for a non third party solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |