Mailchimp Connector for Azure Data Factory (SSIS)

Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
You can use this connector to integrate Mailchimp data inside SSIS and SQL Server. Let's take a look at the steps below to see how exactly to accomplish that.

Download Documentation

If you are new with SSIS and ZappySys SSIS PowerPack then check below links to get started.

How to get started with SSIS and SSIS PowerPack. it covers how to install necessary tools to design/debug SSIS Packages, deploy to SSIS catalog and last Schedule SSIS Package to run using SQL Agent. It will also cover how to secure SSIS package and Parameterize values (e.g. Password, Hostname, etc).
SSIS API Source Help File
SSIS API Destination Help File

Connect to Mailchimp in other apps

Connect to Mailchimp in SSIS

Connect to Mailchimp in SQL Server

Connect to Mailchimp in Power BI

Connect to Mailchimp in SSRS

Connect to Mailchimp in Informatica

Connect to Mailchimp in MS Access

Connect to Mailchimp in MS Excel

Connect to Mailchimp in SSAS

Connect to Mailchimp in C#

Connect to Mailchimp in Python

Connect to Mailchimp in JAVA

Connect to Mailchimp in Tableau

Connect to Mailchimp in SAP Crystal Reports

Connect to Mailchimp in Azure Data Factory (Pipeline)

Connect to Mailchimp in Talend Studio

Connect to Mailchimp in UiPath

Connect to Mailchimp in PowerShell

Connect to Mailchimp in ODBC

Create SSIS package

First of all, create an SSIS package, which will connect to Mailchimp in SSIS. Once you do that, you are one step closer to deploying and running it in Azure-SSIS integration runtime in Azure Data Factory (ADF). Then simply proceed to the next step - creating and configuring Azure Blob Storage Container.

Prepare custom setup files for Azure-SSIS runtime

Now it's time to start preparing custom setup files for Azure-SSIS runtime. During Azure-SSIS runtime creation you can instruct ADF to perform a custom setup on a VM (Azure-SSIS node); i.e. to run the custom installer, copy files, execute PowerShell scripts, etc. In that case, your custom setup files are downloaded and run in the Azure-SSIS node (a VM) when you start the runtime. In this section we will prepare custom setup files so that you can run SSIS packages with SSIS PowerPack connectors inside in Azure-SSIS runtime.

Read more on Azure-SSIS runtime custom setup in Microsoft Azure Data Factory reference.

Trial Users

Use the step below if you are a Trial User, when you did not purchase a license key. Proceed with these steps:

Download SSIS PowerPack trial installer.
Make sure you don't rename the installer and keep it named as SSISPowerPackSetup_64bit_Trial.msi.
Create a text file and name it main.cmd (make it all lowercase, very important).

Copy and paste this script into it and save it:

set DIR=%CUSTOM_SETUP_SCRIPT_LOG_DIR%

echo Calling Step 1 : %TIME% >> "%DIR%\steps_log.txt"
dir /s /b > "%DIR%\file_list.txt"

echo Calling Step 2 : %TIME% >> "%DIR%\steps_log.txt"

::Install SSIS PowerPack
msiexec /i  "SSISPowerPackSetup_64bit_Trial.msi" ADDLOCAL=ALL /q  /L*V "%DIR%\powerpack_trial_install_log.txt"

echo Calling Step 3 : %TIME% >> "%DIR%\steps_log.txt"
dir "C:\Program Files\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"
dir "C:\Program Files (x86)\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"

echo DONE : %TIME% >> "%DIR%\steps_log.txt"

echo complete

This is the entry-point script that is executed when Azure-SSIS runtime is started.

At last! You are ready to upload these two files — main.cmd & SSISPowerPackSetup_64bit_Trial.msi — into your Azure Blob Storage container's folder, which we will do in the Upload custom setup files to Azure Blob Storage container step.

Paid Customers

Use the steps below if you are a Paid Customer, when you purchased a license. Proceed with these steps:

Download SSIS PowerPack paid installer.
Make sure you don't rename the installer and keep it named as SSISPowerPackSetup_64bit.msi.
Have your SSIS PowerPack license key handy, we will need it in the below script.
Create a text file and name it main.cmd (make it all lowercase, very important).
Copy and paste the below script into it.
Paste your license key by replacing parameter's --register argument with your real license key.

Finally, save main.cmd:

set DIR=%CUSTOM_SETUP_SCRIPT_LOG_DIR%

echo Calling Step 1 : %TIME% >> "%DIR%\steps_log.txt"
dir /s /b > "%DIR%\file_list.txt"

echo Calling Step 2 : %TIME% >> "%DIR%\steps_log.txt"

::Install SSIS PowerPack
msiexec /i  "SSISPowerPackSetup_64bit.msi" ADDLOCAL=ALL /q  /L*V "%DIR%\powerpack_install_log.txt"

echo Calling Step 3 : %TIME% >> "%DIR%\steps_log.txt"

::Activate PowerPack license (Optional)
"C:\Program Files (x86)\ZappySys\SSIS PowerPack (64 bit)\LicenseManager.exe" -p SSISPowerPack --register "lgGAAO0-----REPLACE-WITH-YOUR-LICENSE-KEY-----czM=" --logfile "%DIR%\powerpack_register_log.txt"

::Show System Info
echo Calling Step 4 : %TIME% >> "%DIR%\steps_log.txt"
"C:\Program Files (x86)\ZappySys\SSIS PowerPack (64 bit)\LicenseManager.exe" -i -l "%DIR%\sysinfo_log.txt"

echo Calling Step 5 : %TIME% >> "%DIR%\steps_log.txt"
dir "C:\Program Files\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"
dir "C:\Program Files (x86)\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"

echo DONE : %TIME% >> "%DIR%\steps_log.txt"

echo complete

This is the entry-point script that is executed when Azure-SSIS runtime is started.

At last! You are ready to upload these two files — main.cmd & SSISPowerPackSetup_64bit.msi — into your Azure Blob Storage container's folder, which we will do in the Upload custom setup files to Azure Blob Storage container step.

Upload custom setup files to Azure Blob Storage container

Within Azure Blob Storage container we will store custom setup files we prepared in the previous step so that Azure-SSIS can use them in custom setup process. Just perform these very simple, but very important steps:

Create Azure Blob Storage container, if you haven't done it already
Make sure you create and use Azure Blob Storage container instead of Azure Data Lake Storage folder. Azure Data Lake Storage won't allow creating an SAS URI for the container, which is a crucial step in the process.
Find Blob Containers node, right-click on it and hit Create Blob Container option:
Upload the two custom setup files — main.cmd & the MSI installer — into your Azure Blob Storage container's folder:
It was easy, wasn't it? It's time we create an SAS URI in the next step.

Create SAS URI for Azure Blob Container

Once you have custom setup files prepared, it's time we generate an SAS URI. This SAS URI will be used by a new Azure-SSIS runtime to install SSIS PowerPack inside the runtime's node, a VM. Let's proceed together by performing the steps below:

Install and launch Azure Storage Explorer.
Right-click on the Storage Accounts node and then hit Connect to Azure storage... menu item:
Proceed by right-clicking on that container node and select Get Shared Access Signature... option.
Next, set the Expiry time field to a date far in the future.
If you restart Azure-SSIS runtime and your SAS URI is expired by that time, it will not start.
Select Read, Create, Write, and List permissions:
We also recommend to add Delete permission too to support future functionality.
Copy SAS URL to the clipboard and save it for the next step: You can also generate and copy SAS URL from within Azure Portal itself:

Create Azure-SSIS integration runtime

Once you have the SAS URL we obtained in the previous step, we are ready to move on to create an Azure-SSIS runtime in Azure Data Factory:

Firstly, perform the steps described in Create an Azure-SSIS integration runtime article in Azure Data Factory reference.
In Advanced settings page section, configure Custom setup container SAS URI you obtained in the previous step:
And you are done! That was quick! You can see your Azure-SSIS runtime up and running:

The custom setup script is executed only once — at the time an Azure-SSIS runtime is started.

It is also executed if you stop and start Azure-SSIS runtime again.

Deploy SSIS package in Visual Studio

We are ready to deploy the SSIS package to Azure-SSIS runtime. Once you do that, proceed to the next step for the grand finale!

Execute SSIS package in SQL Server Management Studio (SSMS)

After all hard work, we are ready to execute SSIS package in SQL Server Management Studio (SSMS):

Connect to the SQL Server which is linked to your Azure-SSIS runtime and contains SSISDB database.
Navigate to Integration Services Catalog » Your Folder » Your Project » Your Package, right-click on it, and hit Execute...:
To view the status of the past execution, navigate to Integration Services Catalog » Your Folder » Your Project » Your Package, right-click on it, and select Reports » Standard Reports » All Executions menu item:

Scenarios

Moving SSIS PowerPack license to another Azure-SSIS runtime

If you are a Paid Customer, there will be a time when you no longer use Azure-SSIS runtime or you need to use your license on a different ADF instance. To transfer a license from one Azure-SSIS runtime to another, perform these steps:

Copy & paste this script into main.cmd we used in the previous step:

set DIR=%CUSTOM_SETUP_SCRIPT_LOG_DIR%

echo Calling Step 1 : %TIME% >> "%DIR%\steps_log.txt"
dir /s /b > "%DIR%\file_list.txt"
 
echo Calling Step 2 : %TIME% >> "%DIR%\steps_log.txt"

::Install SSIS PowerPack
msiexec /i  "SSISPowerPackSetup_64bit.msi" ADDLOCAL=ALL /q  /L*V "%DIR%\powerpack_install_log.txt"
 
echo Calling Step 3 : %TIME% >> "%DIR%\steps_log.txt"
 
::De-Activate same license
"C:\Program Files (x86)\ZappySys\SSIS PowerPack (64 bit)\LicenseManager.exe" -p SSISPowerPack --unregister --logfile "%DIR%\powerpack_un_register_log.txt"
 
::Show System Info
echo Calling Step 4 : %TIME% >> "%DIR%\steps_log.txt"
"C:\Program Files (x86)\ZappySys\SSIS PowerPack (64 bit)\LicenseManager.exe" -i -l "%DIR%\sysinfo_log.txt"
 
echo Calling Step 5 : %TIME% >> "%DIR%\steps_log.txt"
dir "C:\Program Files\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"
dir "C:\Program Files (x86)\Microsoft SQL Server\*Zappy*.*"  /s /b >> "%DIR%\installed_files.txt"
 
echo DONE : %TIME% >> "%DIR%\steps_log.txt"
 
echo complete

Start Azure-SSIS runtime.
This will unregister your license on the original Azure-SSIS runtime.
Stop Azure-SSIS runtime to deallocate resources in Azure.
Now you are free to activate it on another Azure-SSIS runtime.

Advanced topics

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. [Read more...]

Get List of Campaigns

Get all campaigns in an account. [Read more...]

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. [Read more...]

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. [Read more...]

Get Lists

Get information about all lists in the account. [Read more...]

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. [Read more...]

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

Delete List

Delete a specific list. [Read more...]

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

Update List Details

Update the settings for a specific list. [Read more...]

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 [Read more...]

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). [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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. [Read more...]

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	Set 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

Conclusion

In this article we discussed how to connect to Mailchimp in Azure Data Factory (SSIS) and integrate data without any coding. Click here to Download Mailchimp Connector for Azure Data Factory (SSIS) and try yourself see how easy it is. If you still have any question(s) then ask here or simply click on live chat icon below and ask our expert (see bottom-right corner of this page).

Download Mailchimp Connector for Azure Data Factory (SSIS) Documentation

More integrations

Other application integration scenarios for Mailchimp

SSIS

SQL Server

Power BI

SSRS

Informatica

MS Access

MS Excel

SSAS

Python

JAVA

Tableau

SAP Crystal Reports

Azure Data Factory (Pipeline)

Talend Studio

UiPath

PowerShell

ODBC

Other connectors for Azure Data Factory (SSIS)

Amazon Ads

Amazon MWS

Amazon Selling Partner (SP-API)

Asana

Azure DevOps

Cosmos DB

DropBox

FastSpring

Google Drive

Hubspot

Jira

Mailchimp

ManagedEngine ServiceDesk Plus (Zoho)

Nativo

OData

OneDrive

Outlook Mail (Office 365)

Power BI

ServiceNow

SharePoint Online

Shopify

Smartsheet

Stripe

YouTube

Zendesk

Zoho CRM

Zoho SalesIQ

Zoom

REST API

JSON

JSON File

XML

SOAP

XML File

JDBC-ODBC Bridge

Salesforce

CSV

Amazon S3 JSON File

Amazon S3 XML File

Amazon S3 CSV File

Azure Blob JSON File

Azure Blob XML File

Azure Blob CSV File

FTP/SFTP JSON File

FTP/SFTP XML File

FTP/SFTP CSV File

Build your own Custom API Connector

Download Mailchimp Connector for Azure Data Factory (SSIS) Documentation

Common Searches:

How to connect Mailchimp in Azure Data Factory (SSIS)?
How to get Mailchimp data in Azure Data Factory (SSIS)?
How to read Mailchimp data in Azure Data Factory (SSIS)?
How to load Mailchimp data in Azure Data Factory (SSIS)?
How to import Mailchimp data in Azure Data Factory (SSIS)?
How to pull Mailchimp data in Azure Data Factory (SSIS)?
How to push data to Mailchimp in Azure Data Factory (SSIS)?
How to write data to Mailchimp in Azure Data Factory (SSIS)?
How to POST data to Mailchimp in Azure Data Factory (SSIS)?
Call Mailchimp API in Azure Data Factory (SSIS)
Consume Mailchimp API in Azure Data Factory (SSIS)
Mailchimp Azure Data Factory (SSIS) Automate
Mailchimp Azure Data Factory (SSIS) Integration
Integration Mailchimp in Azure Data Factory (SSIS)
Consume real-time Mailchimp data in Azure Data Factory (SSIS)
Consume real-time Mailchimp API data in Azure Data Factory (SSIS)
Mailchimp ODBC Driver | ODBC Driver for Mailchimp | ODBC Mailchimp Driver | SSIS Mailchimp Source | SSIS Mailchimp Destination
Connect Mailchimp in Azure Data Factory (SSIS)
Load Mailchimp in Azure Data Factory (SSIS)
Load Mailchimp data in Azure Data Factory (SSIS)
Read Mailchimp data in Azure Data Factory (SSIS)
Mailchimp API Call in Azure Data Factory (SSIS)