Documentation: meter_events_ts

Time Series data of events processed from meters_ts
To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
You can also supply us with files in xlsx, csv or json format. -> Example CSV
type p14n blurred autogenerated required
device_uid string ⤫ ⤫ ✓ ⤫
organization_id + manufacturer + serial_number; FK from meters table
manufacturer string ⤫ ⤫ ⤫ ✓
Manufacturer of the device
serial_number string ⤫ ⤫ ⤫ ✓
Serial of the device
start_at datetime ⤫ ⤫ ⤫ ✓
time the event started
end_at datetime ⤫ ⤫ ⤫ ✓
time the event ended
duration_sec integer ⤫ ⤫ ⤫ ⤫
time the event was lasting rounded to seconds
energy_start_wh float ⤫ ⤫ ⤫ ⤫
energy value at start time in watt-hour
energy_end_wh float ⤫ ⤫ ⤫ ⤫
energy value at end time in watt-hour
energy_consumed_wh float ⤫ ⤫ ⤫ ⤫
energy value used for the event watt-hour
category string ⤫ ⤫ ⤫ ✓
type of event
created_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was inserted
updated_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was updated
source_id integer ⤫ ⤫ ✓ ⤫
References Source of data
organization_id integer ⤫ ⤫ ✓ ⤫
References Organization of data
custom jsonb ⤫ ⤫ ✓ ⤫
Saves additional imported data out of standard structure
data_origin string ⤫ ⤫ ✓ ⤫
Origin of the data, generic or name of the api