Skip to main content

MailChimp.Collection

Returns a table with data from a MailChimp endpoint.

Syntax​

MailChimp.Collection(
    path as text,
    optional entityName as text
) as table

Remarks​

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​

Example #1​

Pulls a table of data from the MailChimp API's lists endpoint.

MailChimp.Collection("lists")

Result:

A table with list data.

Example #2​

Pulls a table of data from the MailChimp API's campaign-folders endpoint.

MailChimp.Collection("campaign-folders", "folders")

Result:

A table with campaign-folders data.