User Guide > Map Connectors > Source and Target Map Connectors > Mailchimp
Was this helpful?
Mailchimp
Mailchimp is a marketing automation and email marketing platform. The Mailchimp connector can be a source or target connection.
• Supported Versions: The Mailchimp Marketing API version 3.0.
• Authentication: Mailchimp uses a bearer token for authentication and authorization. When making a call to one of the Mailchimp API endpoints, set the value of the Authorization field to Bearer <API_Key>, where <API_Key> is the bearer token provided by Mailchimp.
Note:  When creating a new map (manually or using the Map Wizard) and the target has no schema, DataConnect attempts to create one using the source schema. This is a straightforward process with a single record source to a single record target. The process differs with a multi-record (or hierarchical) source to a multi-record target. In this case, DataConnect locates the first “flat” source record type (a record where none of the fields are themselves a record) and uses it to generate a basic schema for the target. Users can then build out the schema.
Prerequisites
Before using the connector, ensure the following prerequisites are met:
• Create a Mailchimp account here: https://login.mailchimp.com/signup/.
Note:  Your Mailchimp account plan level determines what you can do with the Mailchimp API. For example, the free plan allows minimum access to Mailchimp resources (it does not allow access to its automations resource). For developers and testers, the best way to have full access to access to Mailchimp resources is to become a Mailchimp Integration Partner.
Tip...  Make a note of the following information when you establish your Mailchimp account (this information is needed for making API calls):
• Data Center
The Data Center is where your account resides. When you login to your account, it points to a new URL which uses the following format:
https://<dc>.api.mailchimp.com/3.0/
where
<dc> is the name of the data center for your account.
For example:
https://us17.admin.mailchimp.com/
• API Key
An API Key is used to authenticate a request to the Mailchimp Marketing API.

To generate an API Key:
Navigate to Mailchimp account > Extra > API Keys section. Click Create New Key and give it a name that describes the name of the application it will be used with. Copy the generated key immediately and store it in a secure location. You won’t be able to see or copy the key once it’s generated.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target. The fields that are available depend on the connector you select.
The Mailchimp connector has several connector parts. For a list of all parts for source connectors, see Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Target Connector, Parts, and Properties.
Connector Properties
You can specify the following source (S) and target (T) properties:
Property
S/T
Description
PageSize
S
Maximum number of records that are returned in a response. The maximum limit is 100. Default value is 50.
Note:  The maximum value is 100, even when a value greater than 100 is specified.
Fields
S
A comma separated list of parent fields to be returned in the response. The returned fields are dependent on the Include/Exclude property. For more information, see Mailchimp Marketing API documentation.
Include/Exclude
S
When the Fields property is defined:
• Include - Choose this to only return resources from fields defined in the Fields property.
• Exclude - Choose this to return all resources excluding resources from fields defined in the Fields property.
Default value is Include.
Flush Frequency
T
Number of records buffered in the memory before being written to the target. Default value is 0 (all records are written at once).
Batch Response
T
The file to which CRUD operation results are written. The format is one entry per record, indicating success or failure. If the operation fails, information about the cause of failure is returned.
Default is to not write a batch response file.
Mailchimp Resources
The Mailchimp Marketing API generally follows REST naming conventions for resources. For example, names for primary resources are typically nouns, such as lists or lists/stores.
The Mailchimp connector has three types of resources:
• primary resource such as lists
• sub-resource such as lists//members
• sub-sub-resource such as lists//members/tags
Sub-resource names can be nested under resources. For example, lists//members and lists//members/tags. For more information, see Mailchimp Marketing API documentation.
Resource Schema
Mailchimp resources provide URL endpoints to retrieve their schema definition.
Each HTTP operation (GET, POST, PUT, PATCH) has its own schema. For most resources, their GET (source) schema is a superset of the target (POST, PUT, PATCH) schema. Therefore, the target connector can use the source schema as its schema. But there are cases where the source schema and the target schema differ and different schemas must be used.
A Mailchimp schema can be hierarchical (one object may contain several sub objects). The following table describes the mapping of Mailchimp property types to DataConnect datatypes:
Mailchimp Property Type
DataConnect Datatype
Description
bool
boolean
A field containing binary options (true or false).
integer
integer
Integer number
number
decimal
Decimal number
string
string
A plain text string, Date-time is mapped to a string with date-time format.
Supported Output Modes
The Mailchimp connector supports the Append output mode for inserting the data via POST operation. For more information, see Target Output Modes.
Source Connector
The Mailchimp source connector provides various APIs to retrieve data from the server. By default, the source connector retrieves all records for a resource. You can improve performance by doing the following:
• Use the Include/Exclude property to only retrieve specific fields.
• Use these Connector Parts: Select a Primary Resource ID if there is a sub-resource, or select a Primary Resource ID and Sub Resource ID if there is a sub-sub-resource from which to retrieve a specific set of records.
Last modified date: 09/22/2025