MailChimp.Collection

Updated on

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 table

Description

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" )

Other functions related to MailChimp.Collection are:

Contribute » | Contributors: Rick de Groot