Hi there everyone!
I am trying to make powershell run commands through an external management site (wordpress multi-site-management dashboard), and i cant seem to be able to retrieve the response from the website.
The foreach loop which is not returning any response (even though it runs the exact same call) is found here:
Can someone tell me what i’m missing?
If i run this, i get the write response back by default (running Powershell ISE):
$pluginpath = “forminator/forminator.php”
$cosandsec = “consumer_key=ck_df&consumer_secret=cs_8f745gd”
$siteid =“977”
$Url = “https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id=$($siteid)&type=plugin&slug=$($pluginpath)&$($cosandsec)”
Invoke-RestMethod -Method ‘Put’ -Uri $url
I would greatly appreciate some feedback!
The reponse is in JSON format, perhaps this is why my error-catch attempts are failing?
My first guess would be this:
$FileList = (Get-ChildItem 'C:\Users\Dern\Desktop\PS2020\MainWP\PUT-Pluginupdate\updatelist\updateme.txt').fullname
It is referencing a specific file, which would be Get-Item. Also, here is a better way to build the string, imho:
$Url = "https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id={0}&type=plugin&slug={1}&{2}" -f $websiteid,$pluginpath,$cosandsec
and getting results from the the for loop, everything should roll up (no +=) …
$myOutput = foreach ($blah in $blahs) {
foreach ($foo in $foos) {
}
}
$myOutput #| Export-Csv ...
Hi Rob!
Thank you for your swift response 
Regarding the $Filelist ( i forgot to mention that ) - It is supposed to take one ID, going on a list in the txt file:
1232
6543
4563
Each of the ID’s represent a site to have this specific plugin updated, mentioned in $pluginpath.
So i want it to loop each line inside the file, which seems to work.
The call itself, also seems to work now. ( I tried to use your replacement for $Url, but for some reason that broke the call, and i actually did get an error message saying the request failed ).
I just cant seem to figure out, if i make a simple call, without looping, i get the response i want (just printet out in the console), but i cant seem to catch it in this loop 
When there is a “normal error” it does get reported back to me, if the URL does not match for an example, but when i am supposed to get a “succes response” in JSON format, i just get nothing.
Maybe i am not supposed to try and get a JSON response with Exception.message?
The response error i do get, to clarify, are not from any JSON format. These are just 404, 403 etc.
If i launch this code in a seperate file:
$pluginpath = "forminator/forminator.php"
$cosandsec = "consumer_key=ck_5939575f46dd2cb401b1183e8b8&consumer_secret=cs_8f7452d67154e056"
$siteid ="977"
$Url = "https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id=$($siteid)&type=plugin&slug=$($pluginpath)&$($cosandsec)"
Invoke-RestMethod -Method 'Put' -Uri $url
write-host $url
I get this response:
https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id=977&type=plugin&slug=forminator/forminator.php&consumer_key=ck_52f401b1183e8b8&consumer_secret=cs_8f7452
SUCCESS
-------
Process ran.
And its the same thing i’m doing in the loop, pretty much.
Just to simplify things, look at this structure. First you need to have ErrorAction set to capture errors from Invoke-RunBook. Next, in the try block, you are going to parse $updateprocess, not the exception:
$pluginpath = "forminator/forminator.php"
$cosandsec = "consumer_key=ck_5daadfa8&consumer_secret=cs_8adfa97b10d1b8056"
$list = Get-Content -Path 'C:\Users\Dern\Desktop\PS2020\MainWP\PUT-Pluginupdate\updatelist\updateme.txt'
$myOutput = foreach ($listedid in $FileList) {
foreach ($websiteid in (Get-Content $listedid)) {
try {
$Url = "https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id={0}&type=plugin&slug={1}&{2}" -f $websiteid, $pluginpath, $cosandsec
$updateprocess = Invoke-RestMethod -Method 'Put' -Uri $url - ErrorAction Stop
write-host "dette er url $url"
# create custom objects and run API call
[PSCustomObject]@{
websiteid = $websiteid
Exceptionmessage = $updateProcess.success
Exceptionresponse = $updateProcess.success
StatusdescriptionValue = '200'
Statusdescription = 'SUCCESS'
}
} catch {
# catcherrors
[PSCustomObject]@{
websiteid = $websiteid
Exceptionmessage = $_.Exception.Message
Exceptionresponse = $_.Exception.Response
StatusdescriptionValue = $_.Exception.Response.StatusCode.value__
Statusdescription = $_.Exception.Response.StatusDescription
}
}
}
}
Hi again Rob!
Thank you so much for you details!
It works perfectly now
This is the final structure:
My CSV output now looks like this:
“websiteid”,“Exceptionmessage”,“Exceptionresponse”,“StatusdescriptionValue”,“Statusdescription”
“977”,“Process ran.”,“200”,“SUCCESS”
Have a fantastic day
As a sidenote, i could not make the script work with your suggested section:
$Url = “https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id={0}&type=plugin&slug={1}&{2}” -f $websiteid, $pluginpath, $cosandsec
- so i just the one from the prior version which seems to do the trick
That is just a string format. The curly brackets represent array position for the passed arguments:
$websiteId = 1234
$pluginPath = 'myPluginPath'
$cosandsec = 'myCosAndSec'
“https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id={0}&type=plugin&slug={1}&{2}” -f $websiteid, $pluginpath, $cosandsec
https://test.dk/wp-json/mainwp/v1/site/site-update-item?site_id=1234&type=plugin&slug=myPluginPath&myCosAndSec
Personal preference over concatenating by putting variables or $($var) in a string.
Ah, i see
I have tested it a couple of times now this script, and it works, however i was hoping i could ask for some input on the next issue i am fighting aswell.
The script runs, but it runs very slowly, as it awaits response before initiating the next foreach loop.
I have tried using PoshRSJob and ForEach-Object (which i have never used before) to allow the function to loop in parallel, testing with 5 parallel processes.
I keep getting "Parameter set cannot be resolved using the specified named parameters. " just filling up the CSV output sheet.
I have looked at alot of examples and syntax but i cant figure out how to get this error fixed.
Im guessing it have something to do with do with the $Targets not being readable in this manner?
$Targets is just supposed to be the ID’s used already.
As far as i can read up on there is no available parallel function simply for “foreach” which is why i am including ForEach-Object and Posh, or atleast trying.
Here is the modified code:
Take a look at examples like this:
The loop is in the wrong place. You want to process each website in it’s own thread. To emulate the updates taking different time, the WebSite id is used as milliseconds, so 2000 would be 2 seconds.
#Emulate Get-Content
$webSiteIds = @"
1232
6543
4563
8567
9564
3542
1784
6743
3244
8567
9564
"@ -split [environment]::NewLine
$pluginpath = "forminator/forminator.php"
$cosandsec = "consumer_key=ck_5daadfa8&consumer_secret=cs_8adfa97b10d1b8056"
$origin = @{}
$webSiteIds | Foreach-Object {$origin.($_) = @{}}
# Create synced hashtable
$sync = [System.Collections.Hashtable]::Synchronized($origin)
$job = $webSiteIds | Foreach-Object -ThrottleLimit 3 -AsJob -Parallel {
$syncCopy = $using:sync
$process = $syncCopy.$($PSItem)
$process.Id = $PSItem
$process.Activity = "Update of WebSiteId $($PSItem) starting"
$process.Status = "Updating"
$Url = "https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=$($PSItem)&$($cosandsec)"
try {
#$updateprocess = Invoke-RestMethod -Method 'Put' -Uri $url
#Emulate long Invoke-RestMethod
#Start-Sleep -Milliseconds ($PSItem * 2)
Start-Sleep -Milliseconds $PSItem
[PSCustomObject]@{
url = $url
websiteid = $PSItem
Exceptionmessage = $updateProcess.success
StatusdescriptionValue = '200'
Statusdescription = 'SUCCESS'
}
}
catch {
[PSCustomObject]@{
url = $url
websiteid = $PSItem
Exceptionmessage = $_.Exception.Message
StatusdescriptionValue = $_.Exception.Response.StatusCode.value__
Statusdescription = $_.Exception.Response.StatusDescription
}
}
$process.Completed = $true
}
while($job.State -eq 'Running')
{
$sync.Keys | Foreach-Object {
# If key is not defined, ignore
if(![string]::IsNullOrEmpty($sync.$_.keys))
{
# Create parameter hashtable to splat
$param = $sync.$_
# Execute Write-Progress
Write-Progress @param
}
}
# Wait to refresh to not overload gui
Start-Sleep -Seconds 0.1
}
This is executed as a job, so you need to understand how to work with jobs. For instance, testing this code a couple of times I have multiple jobs. The results can only be retrieved one time unless you use the -Keep switch.
PS C:\Users\rasim> Get-Job #old job from testing
Id Name PSJobTypeName State HasMoreData Location Command
-- ---- ------------- ----- ----------- -------- -------
67 Job67 PSTaskJob Completed False PowerShell …
PS C:\Users\rasim> c:\Users\rasim\Desktop\temp.ps1 #rerun script
PS C:\Users\rasim> Get-Job #get the jobs again
Id Name PSJobTypeName State HasMoreData Location Command
-- ---- ------------- ----- ----------- -------- -------
67 Job67 PSTaskJob Completed False PowerShell …
103 Job103 PSTaskJob Completed True PowerShell …
PS C:\Users\rasim> $results = Receive-Job -Id 103 -Keep
PS C:\Users\rasim> $results | Select -First 5
url : https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=1232&
websiteid : 1232
Exceptionmessage :
StatusdescriptionValue : 200
Statusdescription : SUCCESS
url : https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=6543&
websiteid : 6543
Exceptionmessage :
StatusdescriptionValue : 200
Statusdescription : SUCCESS
url : https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=4563&
websiteid : 4563
Exceptionmessage :
StatusdescriptionValue : 200
Statusdescription : SUCCESS
url : https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=8567&
websiteid : 8567
Exceptionmessage :
StatusdescriptionValue : 200
Statusdescription : SUCCESS
url : https://test.dk/wp-json/mainwp/v1/site/site-update-wordpress?site_id=9564&
websiteid : 9564
Exceptionmessage :
StatusdescriptionValue : 200
Statusdescription : SUCCESS