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

	Required	Type	p14n	Blurred	Autogenerated
manufacturer Manufacturer of the device	✓	string	⤫	⤫	⤫
serial_number Serial of the device	✓	string	⤫	⤫	⤫
start_at time the event started	✓	datetime	⤫	⤫	⤫
end_at time the event ended	✓	datetime	⤫	⤫	⤫
category type of event	✓	string	⤫	⤫	⤫
device_uid organization_id + manufacturer + serial_number; FK from meters table	⤫	string	⤫	⤫	✓
duration_sec time the event was lasting rounded to seconds	⤫	integer	⤫	⤫	⤫
energy_start_wh energy value at start time in watt-hour	⤫	float	⤫	⤫	⤫
energy_end_wh energy value at end time in watt-hour	⤫	float	⤫	⤫	⤫
energy_consumed_wh energy value used for the event watt-hour	⤫	float	⤫	⤫	⤫
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
organization_id References Organization of data	⤫	integer	⤫	⤫	✓
custom Saves additional imported data out of standard structure	⤫	jsonb	⤫	⤫	✓
data_origin Origin of the data, generic or name of the api	⤫	string	⤫	⤫	✓