Documentation: meters_ts

Time Series data of individual meters

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	⤫	⤫	⤫
metered_at time the metrics apply to (not time of query)	✓	datetime	⤫	⤫	⤫
device_uid organization_id + manufacturer + serial_number; FK from meters table	⤫	string	⤫	⤫	✓
phase 1,2,3; default: 1	⤫	enum: 1, 2, 3	⤫	⤫	⤫
voltage_v voltage in volts	⤫	float	⤫	⤫	⤫
power_factor ratio of working power to the apparent power, value between from 0 and 1	⤫	float	⤫	⤫	⤫
power_w power in watts	⤫	float	⤫	⤫	⤫
energy_lifetime_wh cumulative energy reading in watt-hour	⤫	float	⤫	⤫	⤫
energy_interval_wh energy consumption at time interval in watt-hour	⤫	float	⤫	⤫	⤫
frequency_hz frequency in hertz	⤫	float	⤫	⤫	⤫
current_a current in ampere	⤫	float	⤫	⤫	⤫
interval_seconds for remotely monitored systems, interval between measurements	⤫	integer	⤫	⤫	⤫
billing_cycle_start_at timestamp on which the tariff cycle starts	⤫	datetime	⤫	⤫	⤫
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
import_id References Import 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	⤫	⤫	✓