MailChimp.Collection is a Power Query M function that makes a call to the MailChimp API and returns the resulting dataset as a table, automatically paging through all results.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
MailChimp.Collection(
path as text,
optional entityName as nullable text,
) as tableDescription
Makes a call to the MailChimp API and returns the resulting dataset as a table. Automatically pages through all results. Optional entityName parameter can be used for API endpoints where the root endpoint and main entityName in JSON response do not match.
Examples
Pulls a table of data from the MailChimp API’s lists endpoint.
// Output: A table with list data.
MailChimp.Collection( "lists" )Pulls a table of data from the MailChimp API’s campaign-folders endpoint.
// Output: A table with campaign-folders data.
MailChimp.Collection( "campaign-folders", "folders" )Related functions
Other functions related to MailChimp.Collection are:
