Using powershell with UptimeRobots API

I got a chance to test Uptimerobots API with Powershell and I used it with a csv-list of urls with keywords to update my uptimerobot account.
Pretty good stuff where you also can output all your monitors with uptimelogs directly to PowerBI or equivalent.

Code:

	$APIKeyWrite = "<insertYourWriteAPIKeyHere" #API Write Key from uptimerobot
	$scriptPath = split-path $MyInvocation.MyCommand.Definition -Parent
	$csvPath = "$($scriptPath)\MonitorList.csv"
	$monitorList = import-csv -Path $csvPath -Delimiter ";"
	$APIUrl = "https://api.uptimerobot.com/v2/"
	$contentType = "application/x-www-form-urlencoded"
	$headers = @{"cache-control"="no-cache"}
	$getMonitorParams = @{"api_key"=$APIKeyWrite;"format"="json";}
	$existingMonitors = ((Invoke-WebRequest -Uri $($apiUrl+"getMonitors") -Method POST -Headers $headers -body $getMonitorParams).content |convertFrom-json)|select -ExpandProperty monitors |select friendly_name,url,keyword_value,id
	foreach ($monitor in $monitorList) {
	Remove-Variable currentMonitor -ErrorAction SilentlyContinue
	$currentMonitor = $existingMonitors | where-object {$_.url -like "https://$($monitor.url)"}
	if ($existingMOnitors.url -notcontains "https://$($monitor.url)") {
	write-output "Doesn't exists, creating $($monitor.url)..."
	$params = @{"api_key"=$APIKeyWrite;"format"="json";"type"="2";"url"="https://$($monitor.url)";"friendly_name"="$($monitor.friendlyName)";"keyword_type"="2";"keyword_value"="$($monitor.keyword)"}
	$contentWrite = (Invoke-WebRequest -Uri $($apiUrl+"newMonitor") -Method POST -Headers $headers -body $params).content |convertFrom-json
	$contentWrite
	}
	else {
	if ($currentMonitor.keyword_value -notlike $monitor.Keyword) {
	write-warning "$($monitor.url): Updating keyword..."
	$editParams = @{"api_key"=$APIKeyWrite;"format"="json";"type"="2";"id"=$currentMonitor.id;"keyword_value"="$($monitor.keyword)"}
	$contentWrite = (Invoke-WebRequest -Uri $($apiUrl+"editMonitor") -Method POST -Headers $headers -body $editParams).content |convertFrom-json
	$contentWrite
	}
	else {
	write-output "$($monitor.url) settings is matched. Skipping..."
	}
	}
	}

view raw addMonitorsFromFile.ps1 hosted with ❤ by GitHub

We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.

	url;friendlyName;Keyword
	site1.company.com;site1;Hello
	site2.company.com;site2;Hello

view raw monitorList.csv hosted with ❤ by GitHub

To get UptimeRobot status from PowerBI the following queries can be used:

Example 1 - Simple query

let

   body = Text.ToBinary("api_key=#myAPIKey#&format=json&logs=1"),

   url= "https://api.uptimerobot.com/v2/getMonitors",

   Options = [

   Headers=[#"Content-type"="application/x-www-form-urlencoded", #"cache-control"="no-cache"],

   Content=body

   ],

   result = Web.Contents(url, Options)

in

    result


Example 2 - Query using records

let

   content= [

      #"api_key"="#myAPIKey#",

      #"format" = "json",

      #"logs" = "1"

   ],

   query = Text.ToBinary(Uri.BuildQueryString(content)),

   Url= "https://api.uptimerobot.com/v2/getMonitors",

   Options = [

   Headers=[

      #"Content-type"="application/x-www-form-urlencoded",

      #"cache-control"="no-cache"],

      Content=query

   ],

   result = Web.Contents(Url, Options)

in

    result

 

Example 3 - Query using json
 

let

   content = "{

  ""api_key"": ""#myAPIKey#"",

  ""format"": ""json"",

      ""logs"": ""1""        

    }",

   query = Text.ToBinary(Uri.BuildQueryString(Json.Document(content))),

   Url = "https://api.uptimerobot.com/v2/getMonitors",

   Options = [

   Headers=[

      #"Content-type"="application/x-www-form-urlencoded",

      #"cache-control"="no-cache"],

      Content=query

   ],

   result = Web.Contents(Url, Options)  

in

    result

SelfService sitecollections in Sharepoint 2019

With Sharepoint 2019 we now have the ability to allow users to create site collections outside their own mysite themselves. This allows for less administration.
The drawback of this solution is that you can only create managed path sites on primary Alternate Access for webapplication. 
Microsofts documentation leaves some holes in regards to how to activate selfservicing functions with powershell in Sharepoint 2019 so I digged for the related values and found settings below. Most are obvious, one wasn't.


Script below

	Add-PSSnapin microsoft.sharepoint.powershell
	$WebApp = Get-SPWebApplication "https://mysite.company.com/"
	$webApp.ShowStartASiteMenuItem = $false
	$webApp.SelfServiceSiteCreationEnabled = $false
	$webApp.Update()

view raw DisableSelfService.ps1 hosted with ❤ by GitHub

	Add-PSSnapin microsoft.sharepoint.powershell
	$WebApp = Get-SPWebApplication "https://mysite.company.com/"
	$webApp.SelfServiceSiteCreationEnabled = $true
	$webApp.ShowStartASiteMenuItem = $true
	$webApp.SelfServiceCreationAlternateUrl = "https://workspace.company.com"
	$webApp.Update()

view raw EnableSelfService.ps1 hosted with ❤ by GitHub

References:
https://docs.microsoft.com/en-us/sharepoint/sites/configure-self-service-site-creation-in-sharepoint-server-2019