Mailchimp Connectors

ZappySys Mailchimp Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connectors you can perform many Mailchimp operations without any coding. You can use this connector to integrate Mailchimp data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python)

Download for SSIS Download for Other Apps Documentation

Click on your App below to get started with Mailchimp Integration

Choose your App / Scenario for which you like to integrate Mailchimp

SSIS

SQL Server

Power BI

SSRS

Informatica

MS Access

MS Excel

SSAS

Python

JAVA

Tableau

SAP Crystal Reports

Azure Data Factory (ADF)

ODBC

Actions supported by Mailchimp Connector

Mailchimp Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.

Get User Details

Gets details about the current Mailchimp user account.

Get List of Campaigns

Get all campaigns in an account.

Parameter

Description

Campaign type

The campaign type. Possible values: regular, plaintext, absplit, rss, or variate.

Option	Value
regular	regular
plaintext	plaintext
absplit	absplit
rss	rss
variate	variate

Status of the campaign

The status of the campaign. Possible values: save, paused, schedule, sending, or sent.

Option	Value
save	save
paused	paused
schedule	schedule
sending	sending
sent	sent

Campaign sent before (Format: 2015-10-21T15:41:36)

Restrict the response to campaigns sent before the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Campaign sent after (Format: 2015-10-21T15:41:36)

Restrict the response to campaigns sent after the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Campaign created before (Format: 2015-10-21T15:41:36)

Restrict the response to campaigns created before the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Campaign created after (Format: 2015-10-21T15:41:36)

Restrict the response to campaigns created after the set time. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Using list Id

The unique id for the list.

Using folder Id

The unique folder id.

To customer

Retrieve campaigns sent to a particular list member. Member ID is The MD5 hash of the lowercase version of the list member’s email address.

Get Campaign Details

Get information about a specific campaign.

Parameter	Description
Campaign Id	The ID of the campaign for which data should be read.

Add New List

Create a new list in your Mailchimp account.

Get Lists

Get information about all lists in the account.

Parameter

Description

Created before (Format: 2015-10-21T15:41:36)

Restrict response to lists created before the set date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Created after (Format: 2015-10-21T15:41:36)

Restrict results to lists created after the set date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Created before last campaign send date (Format: 2015-10-21T15:41:36)

Restrict results to lists created before the last campaign send date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Created after last campaign send date (Format: 2015-10-21T15:41:36)

Restrict results to lists created after the last campaign send date. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Includes email address

Restrict results to lists that include a specific subscriber's email address.

Contains active ecommerce store

Restrict results to lists that contain an active, connected, undeleted ecommerce store.

Option	Value
true	true
false	false

Get List Details

Get information about a specific campaign.

Parameter	Description
List Id	The ID of the list for which data should be read.

Delete List

Delete a specific list.

Parameter	Description
List Id	The ID of the list which should be deleted.

Update List Details

Update the settings for a specific list.

Parameter	Description
List Id	The ID of the list for which data should be updated.

Add New List Member

Add a new member to the list. It throws error if same email exists

Parameter

Description

List Id

The ID of the list for which you like to perform this operation.

Skip Merge Validation

If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false.

Option	Value
true	true
false	false

Add or Update Upsert List Members (Bulk Subscribe or Unsubscribe)

Add or Update Upsert List Members (Bulk Subscribe or Unsubscribe).

Parameter

Description

List Id

The ID of the list for which you like to perform this operation.

Skip Merge Validation

If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false.

Option	Value
true	true
false	false

Skip Duplicate Check

If skip_duplicate_check is true, we will ignore duplicates sent in the request when using the batch sub/unsub on the lists endpoint. The status of the first appearance in the request will be saved. This defaults to false.

Option	Value
true	true
false	false

Update Exising Subscription Status?

Whether this batch operation will change existing members' subscription status.

Option	Value
true	true
false	false

Sync Tags

Whether this batch operation will replace all existing tags with tags in request.

Option	Value
true	true
false	false

Add New List Members in Bulk

Adds multiple members using Bulk API.

Parameter

Description

List Id

The ID of the list for which you like to perform this operation.

Skip Merge Validation

If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false.

Option	Value
true	true
false	false

Get List Members

Get information about members in a specific Mailchimp list.

Parameter

Description

List Id

The ID of the list for which you like to perform this operation.

Email Type

The email type.

Option	Value
html	html
text	text

Status

The subscriber's status. Possible values: subscribed, unsubscribed, cleaned, pending, transactional, or archived.

Option	Value
subscribed	subscribed
unsubscribed	unsubscribed
cleaned	cleaned
pending	pending
transactional	transactional
archived	archived

Since Timestamp Opt (Format: 2015-10-21T15:41:36)

Restrict results to subscribers who opted-in after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Before Timestamp Opt (Format: 2015-10-21T15:41:36)

Restrict results to subscribers who opted-in before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Since Last Changed (Format: 2015-10-21T15:41:36)

Restrict results to subscribers whose information changed after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Before Last Changed (Format: 2015-10-21T15:41:36)

Restrict results to subscribers whose information changed before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Unique Email Id

A unique identifier for the email address across all Mailchimp lists.

VIP Only

A filter to return only the list's VIP members. Passing true will restrict results to VIP list members, passing false will return all list members.

Option	Value
true	true
false	false

Interest Category Id

The unique id for the interest category.

Interest Ids

Used to filter list members by interests. Must be accompanied by interest_category_id and interest_match. The value must be a comma separated list of interest ids present for any supplied interest categories.

Interest Match

Used to filter list members by interests. Must be accompanied by interest_category_id and interest_ids. 'any' will match a member with any of the interest supplied, 'all' will only match members with every interest supplied, and 'none' will match members without any of the interest supplied. Possible values: 'any', 'all', or 'none'.

Since Last Campaign

Filter subscribers by those subscribed/unsubscribed/pending/cleaned since last email campaign send. Member status is required to use this filter.

Option	Value
true	true
false	false

Unsubscribed Since (Format: 2015-10-21T15:41:36)

Filter subscribers by those unsubscribed since a specific date. Using any status other than unsubscribed with this filter will result in an error.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Get All Members in All Lists

Get information about all members in all lists.

Parameter

Description

Email Type

The email type.

Option	Value
html	html
text	text

Status

The subscriber's status. Possible values: subscribed, unsubscribed, cleaned, pending, transactional, or archived.

Option	Value
subscribed	subscribed
unsubscribed	unsubscribed
cleaned	cleaned
pending	pending
transactional	transactional
archived	archived

Since Timestamp Opt (Format: 2015-10-21T15:41:36)

Restrict results to subscribers who opted-in after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Before Timestamp Opt (Format: 2015-10-21T15:41:36)

Restrict results to subscribers who opted-in before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Since Last Changed (Format: 2015-10-21T15:41:36)

Restrict results to subscribers whose information changed after the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Before Last Changed (Format: 2015-10-21T15:41:36)

Restrict results to subscribers whose information changed before the set timeframe. Uses ISO 8601 time format: 2015-10-21T15:41:36+00:00.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Unique Email Id

A unique identifier for the email address across all Mailchimp lists.

VIP Only

A filter to return only the list's VIP members. Passing true will restrict results to VIP list members, passing false will return all list members.

Option	Value
true	true
false	false

Interest Category Id

The unique id for the interest category.

Interest Ids

Interest Match

Since Last Campaign

Filter subscribers by those subscribed/unsubscribed/pending/cleaned since last email campaign send. Member status is required to use this filter.

Option	Value
true	true
false	false

Unsubscribed Since (Format: 2015-10-21T15:41:36)

Filter subscribers by those unsubscribed since a specific date. Using any status other than unsubscribed with this filter will result in an error.

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

Get a Specific Member From All Lists

Get information about all members in all lists.

Parameter	Description
Member Id	The ID of the member for which to get details.

Get List Member Details

Get information about a specific list member, including a currently subscribed, unsubscribed, or bounced member.

Parameter	Description
List Id	The ID of the list for which you like to perform this operation.
Member Id	The ID of the list member for which data should be read.

Delete List Member (Archive)

Archive a list member. To permanently delete, use the delete_list_member_permanent endpoint.

Parameter	Description
List Id	The ID of the list for which you like to perform this operation.
Member Id	The ID of the list member for which data should be deleted.

Delete List Member (Permanent delete)

Delete all personally identifiable information related to a list member, and remove them from a list. This will make it impossible to re-import the list member.

Parameter	Description
List Id	The ID of the list for which you like to perform this operation.
Member Id	The ID of the list member for which data should be deleted.

Update List Member Details

Update the settings for a specific list member.

Parameter

Description

List Id

The ID of the list for which you like to perform this operation.

Member Id

The ID of the member to update.

Skip Merge Validation

If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false.

Option	Value
true	true
false	false

Generic Request

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameter	Description
Url	API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains
Body	Request Body content goes here
IsMultiPart	Check this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle
Filter	Enter filter to extract array from response. Example: $.rows[] --OR-- $.customers[].orders[*]. Check your response document and find out hierarchy you like to extract
Headers	Headers for Request. To enter multiple headers use double pipe or new line after each {header-name}:{value} pair