# This script authenticates against the JUNE5 API and retrieves the measurement data of multiple measurement variables
Define base data
$MyUser = 'admin'
$MyPassword = 'admin'
$Base = "https://portal.videc.info/api/v3.6/"
Login and get token
Write-Host -ForegroundColor Yellow "Login"
$MyJUNE5 = Invoke-RestMethod -Uri "$Base/auth/authenticate" -Method Post -Body @{"Logon" = $MyUser; "Password" = $MyPassword}
$MyJUNE5.Token
" "
Write-Host -ForegroundColor Yellow "Wait 2 seconds"
Start-Sleep -Seconds 2
" "
Define request payload
$ReqPay = @{
Parameters = @(
@{
DataSourceKey = 'J5001DE.TA'
From = '2025-01-01T00:00:00.000'
To = '2025-01-04T00:00:00.000'
DataKind = '0' # 0=Pro, 1=Int1, 2=Int2, ...,20=Day, 50=Week, 51=Month, 52=Year, 300=Manual
ValueKind = '0' # 0=VAL, 5=PMIN, 6=PMAX...
Resolution = '2000'
IgnoreNullValues = 'true'}
@{
DataSourceKey = 'J5001DE.LD'
From = '2025-02-01T00:00:00.000'
To = '2025-02-04T00:00:00.000'
DataKind = '0' # 0=Pro, 1=Int1, 2=Int2, ...,20=Day, 50=Week, 51=Month, 52=Year, 300=Manual
ValueKind = '0' # 0=VAL, 5=PMIN, 6=PMAX...
Resolution = '2000'}
)}
$JSON = $ReqPay | ConvertTo-Json
Write-Host -ForegroundColor Yellow "This is what the JSON object of the request looks like"
$JSON
" "
#"Execute query"
$MyData = Invoke-RestMethod -Uri "$Base/ViewModel/GetProcessVariableListValuesByDataSourceKey" -Method Post -Headers @{"June5-Token" = $MyJUNE5.Token} -Body $JSON -ContentType 'application/json'
Write-Host -ForegroundColor Yellow "Output of all variables and the data TimeStamp, Value"
Outer loop for the variables
foreach($Var in $MyData.ObjectList){
$Var.DataSourceKey + " (" + $Var.Name + ") [" + $Var.ProcessUnit + "]"
Inner loop for the values
foreach($Item in $Var.Values){
$Item.TimeStamp + ";" + $Item.Value
}
" "
}
Write-Host -ForegroundColor Yellow "Number of values of all variables"
$MyData.ObjectList.Values.Count
|