# This Python script authenticates against the JUNE5 API and
# retrieves a PDF report
#
# Process:
# Step 1: Login and get token
# Step 2: Determine the measurement variable list, but only report objects (ObjectModelType 128) via GetListPaged (OData)
# Step 3: With a report UID, get the PDF stream (PrintReportExt) and save as file
#
# Notes:
# - OData query parameters are: $filter, $top, $skip, $orderby
# - In PowerShell, "$" was escaped; in Python we pass the parameters directly as keys
# - In addition to the header token, the token is also passed as a query parameter june5Token (as in PS)
import requests
Define base data
MyUser = "admin"
MyPwd = "admin"
MyBase = "https://portal.videc.info/api/v3.6/"
sess = requests.Session()
Step 1: Login and get token
print("Step 1: Login with token")
r = sess.post(
f"{MyBase}auth/authenticate",
data={"Logon": MyUser, "Password": MyPwd, "LoginType": 0},
timeout=30,
)
r.raise_for_status()
MyJUNE5 = r.json()
Token = MyJUNE5.get("Token")
if not Token:
raise RuntimeError("No token received (login failed or response unexpected)")
print("Token:", Token)
print()
headers = {"June5-Token": Token}
Step 2: GetListPaged -> only reports (ObjectModelType 128)
print("Step 2: Determine the measurement variable list, but only report objects of type 128")
params = {
"$filter": "ObjectModelType eq Videc.June5.Entities.ObjectModelType'128'",
"$top": "500",
"$skip": "0",
"$orderby": "DataSourceKey asc, Name asc",
}
r = sess.get(
f"{MyBase}ViewModel/GetListPaged",
params=params,
headers=headers,
timeout=60,
)
r.raise_for_status()
MyData = r.json()
items = MyData.get("Items") or []
print("Found report items:", len(items))
if not items:
raise RuntimeError("No report items found (Items is empty)")
UID of the first report (as in the PowerShell example)
MyPDFReportUID = items[0].get("ObjectModelItemUid")
if not MyPDFReportUID:
raise RuntimeError("First item has no ObjectModelItemUid")
print("Report UID (first item):", MyPDFReportUID)
print()
Step 3: PrintReportExt -> get PDF stream and save as file
print("Step 3: Get PDF stream and save as file")
For PrintReportExt, all parameters must be specified (like in PS)
params = {
"june5Token": Token,
"uid": MyPDFReportUID,
"from": "2022-05-01T00:00:00.000",
"to": "2022-06-01T00:00:00.000",
"widthIntervall": "60",
"filterName": "",
"isPlantFilter": "true",
}
r = sess.get(
f"{MyBase}ViewModel/PrintReportExt",
params=params,
headers=headers,
timeout=60,
)
r.raise_for_status()
out_file = "MyReport2.pdf"
with open(out_file, "wb") as f:
f.write(r.content)
print("PDF saved:", out_file)
print()
print("End")
|