I have a webpage with data from our sun powerplant on webpage http://www.solar-cybro.com/p/alpod-plant/540/.
I am trying to get Output power value to Powershell once every hour with idea to send me email if powerplant doesn't output power during the day.
I tried with Invoke-WebRequest and ParsedHtml.body.getElementsByTagName but didn't get far. I just can't get the number out.
Ideas?
For powershell v5, I think your best option is to request the historical timeplot data (basically just hitting the download link on one of the graphs):
$DataNames = 'c11356.plant_dc_power','c11356.plant_ac_power' -join '+'
$UnitType = 'day'
$Units = 1
$StartDate = '2021:7:7:15'
$RequestID = [long]([double](Get-Date (Get-Date).ToUniversalTime() -UFormat %s)*1000)
$TimeplotURL = "http://www.solar-cybro.com/service/download_timeplot_data/t=$DataNames,p=$UnitType,s=$StartDate,sc=$Units,cum=0,res=24,dec=1,page=540/?rand=$RequestID"
# Get Data
$csv = Invoke-WebRequest -Uri $TimeplotURL -ContentType text/csv |
ConvertFrom-Csv -Delimiter ';'
# Optionally save to file
$csv | Export-Csv C:\temp\test.csv
# Display data
$csv
And it nicely outputs the data:
date time c11356.plant_dc_power c11356.plant_ac_power
---- ---- --------------------- ---------------------
2021-07-07 08:00:01 906 887
2021-07-07 08:10:01 1002 983
2021-07-07 08:20:01 1084 1062
You'll have to find the specific names/IDs for the data you want, but it should be pretty simple.
I-WRcmdlet. ///// is there an API that you can call?