PoshCode Archive  Artifact [8d10187a85]

Artifact 8d10187a859f91b60654dd774360bd9bc4637f294dd5a5feffb3f6e50af76e19:

  • File MailChimp.ps1 — part of check-in [3c7382350d] at 2018-06-10 13:24:17 on branch trunk — A PoSh script to batch feed email address, firstname and lastname to the MailChimp API (MCAPI) (user: Ant B 2012 size: 2516)

# encoding: ascii
# api: powershell
# title: MailChimp 
# description: A PoSh script to batch feed email address, firstname and lastname to the MailChimp API (MCAPI)
# version: 1.3
# type: module
# author: Ant B 2012
# license: CC0
# x-poshcode-id: 3351
# x-archived: 2016-06-02T02:19:55
# x-published: 2012-04-12T08:12:00
#
# The script reads members from an AD group and fires them off to MCAPI to be added to the specified list, base functionality for removals is provided although there is a glitch with MCAPI’s removesubscription method, if this ever gets resolved I’ll update and repost.
# The script requires 3 parameters, Your MailChimp API Key, List ID and an AD group to read from, this has been tested with 1500+ subscriptions with no issue, it’s possible to batch these even further but I had no real need :)
#
#Author: Ant B 2012
#Purpose: Batch feed recipients to MailChimp

# Check for ActiveDirectory Module and load if it isn't already.
if ( (Get-Module -Name ActiveDirectory -ErrorAction SilentlyContinue) -eq $null )
{
    Import-Module ActiveDirectory
}

$ie = new-object -com "InternetExplorer.Application"

# Vars for building the URL
$apikey = "<Your API Key>"
$listid = "<Your list ID>"
$URL = "https://us4.api.mailchimp.com/1.3/?output=xml&method=listBatchSubscribe&apikey=$apikey"
$URLOpts = "&id=$($listid)&double_optin=False&Update_existing=True"
$Header = "surname","givenanme","mail"

# Get members of the group
$DGMembers = Get-AdGroupMember -Identity "<Full path to AD Group>" | ForEach {Get-ADUser $_.samaccountname -Properties mail} | Select GivenName, Surname, mail

# Copy the array contents to a CSV for comparison on the next run, we'll use it to look for removals
if (test-path "submitted.csv") {Clear-Content submitted.csv}
$DGMembers | select mail | export-csv submitted.csv

# Check for the CSV created above and dump it to an array for comparison
if (test-path "submitted.csv") {$list = Import-CSV -delimiter "," -Path submitted.csv -Header $Header}
$Removals = compare-object $DGMembers $list | Where {$_.SideIndicator -eq "=>"}

# Loop through the array of group members and submit to the MailChimp API
ForEach ($ObjItem in $DGMembers)
{
$batch = "&batch[0][EMAIL]=$($ObjItem.mail)&batch[0][FNAME]=$($ObjItem.givenname)&batch[0][LNAME]=$($ObjItem.surname)"
$MailOpts = "&batch[0][EMAIL_TYPE]html"
$FURL = $URL + $batch + $MailOpts + $URLOpts
Write-Host $FURL
$ie.navigate($FURL)
Start-Sleep -MilliSeconds 300
}