Mailchimp

Sync overview

Output schema

The Mailchimp connector can be used to sync data for Mailchimp Lists and Campaigns. The linked Mailchimp documentation contains detailed description on the fields in each entity.
Please create a Github issue to request support for syncing more Mailchimp entities.

Data type mapping

Integration Type
Airbyte Type
Notes
array
array
the type of elements in the array is determined based on the mappings in this table
date, time, datetime
string
int, float, number
number
object
object
properties within objects are mapped based on the mappings in this table
string
string

Features

Feature
Supported?(Yes/No)
Notes
Full Refresh Sync
Yes
Incremental Sync
Coming soon
Replicate Incremental Deletes
Coming soon
SSL connection
Yes
Enabled by default
Namespaces
No

Performance considerations

At the time of this writing, Mailchimp does not impose rate limits on how much data is read form its API in a single sync process. However, Mailchimp enforces a maximum of 10 simultaneous connections to its API. This means that Airbyte will not be able to run more than 10 concurrent syncs from Mailchimp using API keys generated from the same account.

Getting started

Requirements

For Apikey authorithation:
  • Mailchimp account
  • Mailchimp API key
For OAuth authorization:
  • Mailchimp registered app
  • Mailchimp client_id
  • Mailchimp client_secret

Setup guide

To start syncing Mailchimp data with Airbyte, you'll need two things:
  1. 1.
    Your Mailchimp username. Often this is just the email address or username you use to sign into Mailchimp.
  2. 2.
    A Mailchimp API Key. Follow the Mailchimp documentation for generating an API key.
OR
  1. 1.
    Register an app in Mailchimp.
  2. 2.
    Specify client_id and client_secret.

Changelog

Version
Date
Pull Request
Subject
0.2.11
2021-12-24
7159
Add oauth2.0 support
0.2.10
2021-12-21
9000
Update connector fields title/description
0.2.9
2021-12-13
7975
Updated JSON schemas
0.2.8
2021-08-17
5481
Remove date-time type from some fields
0.2.7
2021-08-03
5137
Source Mailchimp: fix primary key for email activities
0.2.6
2021-07-28
5024
Source Mailchimp: handle records with no no "activity" field in response
0.2.5
2021-07-08
4621
Mailchimp fix url-base
0.2.4
2021-06-09
4285
Use datacenter URL parameter from apikey
0.2.3
2021-06-08
3973
Add AIRBYTE_ENTRYPOINT for Kubernetes support
0.2.2
2021-06-08
3415
Get Members activities
0.2.1
2021-04-03
2726
Fix base connector versioning
0.2.0
2021-03-09
2238
Protocol allows future/unknown properties
0.1.4
2020-11-30
1046
Add connectors using an index YAML file
Last modified 8d ago