Small Powershell Script for MailChimp

I need to send a trigger on MailChimp to send an email to someone when criteria ismet from my database. I can handle the querying of the database and looping. I just do not have any experience with RESTFUL APIs and posting the ID to the endpoint


A subscriber's email ID is posted to the endpoint [login to view URL]

I have managed to cut and paste this from various sources

$id = "463453122973a5e9ea60ddf34594c246dcd"

$user = "anythingGoesHere"

$apiKey = "apikeyhere"

$pair = "${user}:${apiKey}"

$bytes = [[login to view URL]]::[login to view URL]($pair)

$base64 = [[login to view URL]]::ToBase64String($bytes)

$basicAuthValue = "Basic $base64"

$Headers = @{

Authorization = $basicAuthValue


$baseUri = "[login to view URL]"

$body = @{Id = $id}

Invoke-RestMethod -Uri $baseUri -Method Post -Headers $Headers -Body $body

This is the error:

Invoke-RestMethod : {"type":"[login to view URL]","title":"Invalid Resource","status":400,"detail":"The resource submitted could not be

validated. For field-specific details, see the 'errors' array.","instance":"ebb27e6b-4648-4e54-9b54-b900d2c3c901","errors":[{"field":"","message":"Schema describes object, NULL found instead"}]}

At C:\Data\Powershell\[login to view URL] char:1

+ Invoke-RestMethod -Uri $baseUri -Method Post -Headers $Headers -Body ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: ([login to view URL]:HttpWebRequest) [Invoke-RestMethod], WebException

+ FullyQualifiedErrorId : WebCmdletWebResponseException,[login to view URL]

I am ready to pay someone that knows what they are doing because I am banging my head against a wall.

Skills: Powershell, RESTful API

See more: php script read pop3 email message mysql database, small upload script, small perl script, small php script, small community script, small comment script, script public folder copy message, set smpt instead smtp need fix, powershell script add users excel file, small gallery script, small comments script, exchange 2007 powershell script, powershell script users creation, powershell script create multiple users, powershell script create account, need small fix script, need powershell script roaming profile

About the Employer:
( 0 reviews ) United States

Project ID: #20452909

Awarded to:


The error seems on the body format you pass on the request. It must be in json format instead of plain you did currently

$111 USD in 1 day
(0 Reviews)

5 freelancers are bidding on average $150 for this job


I am good in powershell along with automation and development, please let me know if you are good to award this project to me

$150 USD in 1 day
(10 Reviews)

Hey there, I'm a System Engineer with coding skills. I had developed tons of scripts using PowerShell. I can help. Regards.

$250 USD in 7 days
(6 Reviews)

⭐⭐⭐⭐⭐ Hi I read your job description carefully. I have developed a lot of websites. I will do my best for your project until you are satisfied. If you hire me, I will finish your job ASAP with the highest quality. Lo More

$140 USD in 7 days
(0 Reviews)

Hello there, I am working as a Sr. Software Engineer in a multinational product company. Among other responsibilities Azure Linux Server maintainance is one of my major responsibility for quite long. I believe I c More

$100 USD in 5 days
(0 Reviews)