Raw Values Database
Raw Values Database contains raw measuremenet data. User can request raw measurements over API but be avare of using this function to frequently becouse it can hardly reduce performance of the system and try to request values for all variable instances you need in one request since such requests can be executet much efficient on the server side than singe request for every variable instance.
1. Request Valeus
To request raw data send GetRawValuesRequest as JSON. Example of Request:
{
"from": "2022-01-04T16:00:00Z", // Request from timestamp. Use begin of recording if null.
"to": null, // Request to timestamp. Use begin of recording if null.
"instances": [ // List of Variable Instance IDs to get values
141,
142,
138
]
}
You can request either VarValues data stream or JSON array of Measured Values. Please notice that VarValues data stream is much more efficient to transport over ethernet connection.
// request VarValues data stream
rawvalues/db/varvalues/get
// request Measured Values JSON array
rawvalues/db/measured_values/get
Example output for VarValues data stream:
[
{
"instance_id": 138,
"data_stream": "AAAADgEABAMAAAF+JgSHEAAAAX4mBIr4wDQAAAAAAAA/8AAAAAAAAAAAAAAAAAAPoAAAAgMAAAF+JgTFkAAAAX4mBMl4wDUAAAAAAAA/8AAAAAAAAAAAAAAAAAAPoMA0AAAAAAAAAQACAwAAAX4mBOi4AAABfiYE7KDANAAAAAAAAD/wAAAAAAAAAAAAAAAAAA+gAAACAwAAAX4mBQf4AAABfiYFC+DANQAAAAAAAD/wAAAAAAAAAAAAAAAAAA+gwDQAAAAAAAAAAAIDAAABfiYFJzgAAAF+JgUrIMA0AAAAAAAAP/AAAAAAAAAAAAAAAAAAD6DANQAAAAAAAAEAAgMAAAF+JgVKYAAAAX4mBU5IwDUAAAAAAAA/8AAAAAAAAAAAAAAAAAAPoA\u003d\u003d"
},
{
"instance_id": 142,
"data_stream": "AAAADgAABgMAAAF+JgSHEAAAAX4mBIr4QMloAAAAAAA/8AAAAAAAAAAAAAAAAAAPoEDJTQAAAAAAQMj4gAAAAABAyX+AAAAAAEDIxwAAAAAAQMjCAAAAAAAAAAYDAAABfiYE6LgAAAF+JgTsoEDIq4AAAAAAP/AAAAAAAAAAAAAAAAAAD6BAyRoAAAAAAEDJQAAAAAAAQMjGgAAAAABAyLOAAAAAAEDJDQAAAAAAAAACAwAAAX4mBUpgAAABfiYFTkhAyNyAAAAAAD/wAAAAAAAAAAAAAAAAAA+gQMjngAAAAAA\u003d"
},
{
"instance_id": 141,
"data_stream": "AAAADgAABgMAAAF+JgSHEAAAAX4mBIr4QMEaAAAAAAA/8AAAAAAAAAAAAAAAAAAPoEDBJQAAAAAAQMEaAAAAAABAwRaAAAAAAEDBGgAAAAAAQMEiAAAAAAAAAAYDAAABfiYE6LgAAAF+JgTsoEDA5oAAAAAAP/AAAAAAAAAAAAAAAAAAD6BAwNwAAAAAAEDBmIAAAAAAQMHfgAAAAABAwlKAAAAAAEDCkIAAAAAAAAACAwAAAX4mBUpgAAABfiYFTkhAwhAAAAAAAD/wAAAAAAAAAAAAAAAAAA+gQMILAAAAAAA\u003d"
}
]
Example output for Measured Values JSON array:
[
{
"instance_id": 138,
"values": [
{
"start_timestamp": 1641315338000,
"end_timestamp": 1641315339000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315342000,
"end_timestamp": 1641315343000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315346000,
"end_timestamp": 1641315347000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315350000,
"end_timestamp": 1641315351000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315354000,
"end_timestamp": 1641315355000,
"value": -21.0,
"quality": 1.0
},
{
"start_timestamp": 1641315358000,
"end_timestamp": 1641315359000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315363000,
"end_timestamp": 1641315364000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315367000,
"end_timestamp": 1641315368000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315371000,
"end_timestamp": 1641315372000,
"value": -21.0,
"quality": 1.0
},
{
"start_timestamp": 1641315375000,
"end_timestamp": 1641315376000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315379000,
"end_timestamp": 1641315380000,
"value": -20.0,
"quality": 1.0
},
{
"start_timestamp": 1641315383000,
"end_timestamp": 1641315384000,
"value": -21.0,
"quality": 1.0
},
{
"start_timestamp": 1641315388000,
"end_timestamp": 1641315389000,
"value": -21.0,
"quality": 1.0
},
{
"start_timestamp": 1641315392000,
"end_timestamp": 1641315393000,
"value": -21.0,
"quality": 1.0
}
]
},
{
"instance_id": 142,
"values": [
{
"start_timestamp": 1641315338000,
"end_timestamp": 1641315339000,
"value": 13008.0,
"quality": 1.0
},
{
"start_timestamp": 1641315342000,
"end_timestamp": 1641315343000,
"value": 12954.0,
"quality": 1.0
},
{
"start_timestamp": 1641315346000,
"end_timestamp": 1641315347000,
"value": 12785.0,
"quality": 1.0
},
{
"start_timestamp": 1641315350000,
"end_timestamp": 1641315351000,
"value": 13055.0,
"quality": 1.0
},
{
"start_timestamp": 1641315354000,
"end_timestamp": 1641315355000,
"value": 12686.0,
"quality": 1.0
},
{
"start_timestamp": 1641315358000,
"end_timestamp": 1641315359000,
"value": 12676.0,
"quality": 1.0
},
{
"start_timestamp": 1641315363000,
"end_timestamp": 1641315364000,
"value": 12631.0,
"quality": 1.0
},
{
"start_timestamp": 1641315367000,
"end_timestamp": 1641315368000,
"value": 12852.0,
"quality": 1.0
},
{
"start_timestamp": 1641315371000,
"end_timestamp": 1641315372000,
"value": 12928.0,
"quality": 1.0
},
{
"start_timestamp": 1641315375000,
"end_timestamp": 1641315376000,
"value": 12685.0,
"quality": 1.0
},
{
"start_timestamp": 1641315379000,
"end_timestamp": 1641315380000,
"value": 12647.0,
"quality": 1.0
},
{
"start_timestamp": 1641315383000,
"end_timestamp": 1641315384000,
"value": 12826.0,
"quality": 1.0
},
{
"start_timestamp": 1641315388000,
"end_timestamp": 1641315389000,
"value": 12729.0,
"quality": 1.0
},
{
"start_timestamp": 1641315392000,
"end_timestamp": 1641315393000,
"value": 12751.0,
"quality": 1.0
}
]
},
{
"instance_id": 141,
"values": [
{
"start_timestamp": 1641315338000,
"end_timestamp": 1641315339000,
"value": 8756.0,
"quality": 1.0
},
{
"start_timestamp": 1641315342000,
"end_timestamp": 1641315343000,
"value": 8778.0,
"quality": 1.0
},
{
"start_timestamp": 1641315346000,
"end_timestamp": 1641315347000,
"value": 8756.0,
"quality": 1.0
},
{
"start_timestamp": 1641315350000,
"end_timestamp": 1641315351000,
"value": 8749.0,
"quality": 1.0
},
{
"start_timestamp": 1641315354000,
"end_timestamp": 1641315355000,
"value": 8756.0,
"quality": 1.0
},
{
"start_timestamp": 1641315358000,
"end_timestamp": 1641315359000,
"value": 8772.0,
"quality": 1.0
},
{
"start_timestamp": 1641315363000,
"end_timestamp": 1641315364000,
"value": 8653.0,
"quality": 1.0
},
{
"start_timestamp": 1641315367000,
"end_timestamp": 1641315368000,
"value": 8632.0,
"quality": 1.0
},
{
"start_timestamp": 1641315371000,
"end_timestamp": 1641315372000,
"value": 9009.0,
"quality": 1.0
},
{
"start_timestamp": 1641315375000,
"end_timestamp": 1641315376000,
"value": 9151.0,
"quality": 1.0
},
{
"start_timestamp": 1641315379000,
"end_timestamp": 1641315380000,
"value": 9381.0,
"quality": 1.0
},
{
"start_timestamp": 1641315383000,
"end_timestamp": 1641315384000,
"value": 9505.0,
"quality": 1.0
},
{
"start_timestamp": 1641315388000,
"end_timestamp": 1641315389000,
"value": 9248.0,
"quality": 1.0
},
{
"start_timestamp": 1641315392000,
"end_timestamp": 1641315393000,
"value": 9238.0,
"quality": 1.0
}
]
}
]