Documentation: meters_ts
This table is deprecated and should not be used for imports
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
| Row Name | Type | Mapping | Example |
|---|---|---|---|
|
manufacturer * Manufacturer of the device
|
string | installations_ts => manufacturer |
A2EI |
|
serial_number * Serial of the device
|
string | installations_ts => serial_number |
ABC/123 |
|
metered_at * time the metrics apply to (not time of query)
|
datetime | installations_ts => metered_at |
2021-05-03 6:23:55 |
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |
|
|
custom Saves additional imported data out of standard structure
|
jsonb |
{ "some": "key" } |
|
|
organization_id References Organization of data
|
integer |
1 |
|
|
import_id References Import of data
|
integer |
1 |
|
|
source_id References Source of data
|
integer |
1 |
|
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
|
created_at Timestamp when row was inserted
|
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
|
string | installations_ts => device_uid |
1_a2ei_ABC123 |