Small Powershell Script for MailChimp
$30-250 USD
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.
Project ID: #20452909
About the project
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
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
Hey there, I'm a System Engineer with coding skills. I had developed tons of scripts using PowerShell. I can help. Regards.
⭐⭐⭐⭐⭐ 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