Documentation: meters_ts

Cette table est obsolète et ne doit pas être utilisée pour les importations de données.

Time Series data of individual meters

Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation de l'API
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

Vous pouvez également nous fournir des fichiers au format xlsx, csv ou json. -> Exemple CSV

Nom de la ligne	Type	Mappage	Exemple
manufacturer * Manufacturer of the device * requis	string	installations_ts => manufacturer	A2EI
serial_number * Serial of the device * requis	string	installations_ts => serial_number	ABC/123
metered_at * time the metrics apply to (not time of query) * requis	datetime	installations_ts => metered_at	2021-05-03 6:23:55
data_origin Origin of the data, generic or name of the api Généré automatiquement	string		generic
custom Saves additional imported data out of standard structure Généré automatiquement	jsonb		{ "some": "key" }
organization_id References Organization of data Généré automatiquement	integer		1
import_id References Import of data Généré automatiquement	integer		1
source_id References Source of data Généré automatiquement	integer		1
updated_at Timestamp when row was updated Généré automatiquement	datetime		2021-05-03 6:23:55
created_at Timestamp when row was inserted Généré automatiquement	datetime		2021-05-03 6:23:55
billing_cycle_start_at timestamp on which the tariff cycle starts	datetime	installations_ts => custom	2021-04-05
interval_seconds for remotely monitored systems, interval between measurements Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	integer	installations_ts => interval_seconds	360
current_a current in ampere Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_current_a	22.61
frequency_hz frequency in hertz Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_frequency_hz	58.93
energy_interval_wh energy consumption at time interval in watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_energy_interval_wh	51.04
energy_lifetime_wh cumulative energy reading in watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_energy_cumulative_wh	12473.02
power_w power in watts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_power_w	1489.6
power_factor ratio of working power to the apparent power, value between from 0 and 1 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => custom	0.45
voltage_v voltage in volts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	float	installations_ts => output_voltage_v	164.65
phase Specifies the phase used for reporting ac_input_* metric values. For one-phase metering, the value is 1, or None. For multi-phase, it is 1, 2, 3 (phase reported) or "agg" (aggregate of all phases)	enum: 1, 2, 3, agg	installations_ts => ac_input_phase	2
device_uid organization_id + manufacturer + serial_number; FK from meters table Généré automatiquement	string	installations_ts => device_uid	1_a2ei_ABC123