13 Nov’17

Dynamics 365, EnterpriseDynamics CRM Marketing list members sync with MailChimp- Part 1


This blog will depict an idea on how we can integrate the members of CRM Marketing List to MailChimp Marketing List.


We had a requirement to add all the members from CRM static marketing lists to Mail Chimp marketing list. There were many marketing lists in CRM and exporting/importing data for each marketing list was a repetitive process each time we add a member to the list.

Thus, we created some customizations in CRM with respect to the MailChimp API functionalities.

These customizations will help your organization to minimize the manual efforts of adding members to Mail Chimp marketing lists. Only thing you need to do is to click on the custom sync button present on the marketing list record.

CRM customizations are listed below:

  1. Provide a manual option on CRM marketing list to sync the list members to the MailChimp marketing list.

    These will work for members of type Contacts and Leads. Account members cannot be synched because it does not have an email address field. (MailChimp API main parameter for synching any member is the Email address of the member. It does not create duplicate records in MailChimp).

  2. Create a field on Marketing list which stores a unique marketing list ID from MailChimp. This value is important as this will help usl to link CRM and MailChimp lists.

  3. Create an configuration entity in CRM to store Mail chimp API key, MailChimp username, MailChimp URL.

    MailChimp URL for developer purpose is given below:


    The <dc> part of the URL corresponds to the data center for your account. For example, if the last part of your MailChimp API key is us6, all API endpoints for your account are available at https://us6.api.mailchimp.com/3.0/.

    Below is the link to get or create a API key in MailChimp.

    How to create/get API key

  4. Write a custom action which calls the MailChimp API. Below are the links for synching the members individually and to perform the sync operation in batches.
    Each Member Sync
    Sync Members In Batches
  5. Create a MailChimp sync entity to record the sync status. The sync takes place in background in MailChimp thus we need to create this entity and keep a sync check by calling the MailChimp API to retrieve the batch status. Once the status is finished, sync will complete and all the members will be synched to MailChimp Marketing list.

    Below is the screen shot which will show the below details:

    1. How many records completed
    2. How many records errored
    3. Submitted and Completed date
    4. Status of the sync process.

    You can see the status of the sync by opening the record.

    Status finished denotes the syncing process is completed. In the next blog, we will discuss on the MailChimp API call in action.

Written by

Krishna Bhanushali

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Commands to Import .bacpac file to D3FOE SQL Server

    14 May’ 2018

    Introduction: This blog article will explain how to import a .bacpac file to Microsoft SQL Server which is created from ...

    Read more
  • [Solved] – Backspace not working in HTML Web Resources

    11 May’ 2018

    Issue: When we use a HTML web resource in Dynamics 365 CRM forms or even as a separate navigation, we sometimes face is...

    Read more
  • Dynamics 365 Tip: Sending Emails using Unified Interface

    10 May’ 2018

    Introduction: The unified client which was released D365 V9 had a very refreshing UI and lots of features. One of the b...

    Read more
  • Filtering Records on BPF unlike on Form – D365

    10 May’ 2018

    Introduction: Working with D365 is best when you’re trying to use as much OOB stuff as possible. Simplest configurati...

    Read more
  • Filter records in gallery control based on value selected in other gallery control in PowerApps.

    10 May’ 2018

    Introduction: This blog explains how to Filter records in gallery control based on value selected in other gallery cont...

    Read more