Batch Subscibe/Unsubscribe using MailChimp API v3.0

Question

I am building an SSIS package to communicate with the Mailchimp API and batch subscribe/unsubscribe emails to certain lists. The calls are sent fine and the job is started, every response I sent returns an error with a message of

<email> is already a list member.  Use PUT to insert or update list members

My problem is I am sending the request with a PUT Method, my sample call body is below.

{
    "operations": 
    [
        {
            "method": "PUT",
            "path":"lists/d09d88d1bd/members/71743C40CBFB64DC556CB4457DA012AE",
            "body":"{\"email_address\":\"email\",\"status\":\"unsubscribed\"}"
        }
    ]
}

I am getting the same error whether I make the API call straight from my SSIS package or if I use Postman REST Client.

Answer 1

I had the same issue as well and it was because I did not convert the email address to lowercase before applying md5 to get the subscriber_hash.

The update method takes a subscriber id which is the md5 hash of the lowercase version of the email address.

According to the documentation, subscriber_hash refers to 'The MD5 hash of the lowercase version of the list member’s email address.'

http://developer.mailchimp.com/documentation/mailchimp/reference/lists/members/