Documentation: meter_events_ts
Cette table est obsolète et ne doit pas être utilisée pour les importations
Limite de débit : 300 requêtes par minute. Une fois la limite dépassée, toute requête ultérieure entraînera une réponse 429 (Trop de requêtes).
| Nom de la ligne | Type | Correspondance | Exemple |
|---|---|---|---|
|
manufacturer * Manufacturer of the device
|
string |
A2EI |
|
|
serial_number * Serial of the device
|
string |
ABC/123 |
|
|
start_at * time the event started
|
datetime |
2021-05-03 6:23:55 |
|
|
end_at * time the event ended
|
datetime |
2021-05-03 8:11:21 |
|
|
category * type of event
|
string |
cooking |
|
|
device_uid organization_id + manufacturer + serial_number; FK from meters table
|
string |
1_a2ei_ABC123 |
|
|
duration_sec time the event was lasting rounded to seconds Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
32443 |
|
|
energy_start_wh energy value at start time in watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1646.5 |
|
|
energy_end_wh energy value at end time in watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1758.9 |
|
|
energy_consumed_wh energy value used for the event watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
112.4 |
|
|
created_at Timestamp when row was inserted
|
datetime |
2021-05-03 6:23:55 |
|
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
|
source_id References Source of data
|
integer |
1 |
|
|
organization_id References Organization of data
|
integer |
1 |
|
|
custom Saves additional imported data out of standard structure
|
jsonb |
{ "some": "key" } |
|
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |