Hi guys,
I'm trying to get a detailed history of device statistics out of the PRTG API. I'm using this query to pull channel values by datetime:
/api/table.json?content=values&output=json&columns=datetime,value_,coverage&id=14129
I'd like to do that, but for all channels of a device. I'd like to specify a list of sensors, then have data returned in something along the lines of the following:
/api/table.json?content=values&output=json&columns=datetime,value_,coverage&id=14130,14131,14132 sensorID / datetime / value / downtime / coverage
This would result in a long json object, but the software I'm using (PowerBI) is then able to slice that file up by a given object ID (in this case, the sensor identifier). Currently I'm doing this by doing a lot of the former query (single sensor values) and merging those tables, but this is becoming unwieldy - I have 50+ sensors we're pulling data from.
Thanks!
Cameron
Add comment