Forum Discussion
benjamin_sasin
Resolver I
6 years agoCan Mailchimp Audience be imported?
Hi, I just installed the Mailchimp Connector, and trying to import an audience and compare it to our sales funnel. Only when looking for that data set, I cannot find it. There seems to be only ca...
doyleg_OEH
Advocate II
6 years agoTry this query:
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://<YOUR MAILCHIMP SERVER>.api.mailchimp.com/export/1.0/list/?apikey=<YOUR API>&id=<YOUR LIST ID>"))})
in
Source
Full details of other parameters here - https://mailchimp.com/developer/guides/how-to-use-the-export-api/
Cheers
Gavin