Small Powershell Script for MailChimp

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

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

Trigger:

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.

Powershell RESTful API

Project ID: #20452909

About the project

5 proposals Remote project Active 4 years ago

Awarded to:

khanicha

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)
0.0

5 freelancers are bidding on average $150 for this job

goodwork20k

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)
4.4
AhmadSameer

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)
3.3
brightstar928

⭐⭐⭐⭐⭐ 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)
0.0
SamratCh

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)
0.0