Documentation: meter_events_ts

This table is deprecated and should not be used for imports

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	Example
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