Documentation: installations_ts
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 | Example |
|---|---|---|
|
metered_at * time the metric was measured (not time of query)
|
datetime |
2022-01-01T13:00:00.000+00:00 |
|
serial_number * Serial of the installed device
|
string |
SHS/123 |
|
manufacturer * The manufacturer of the device
|
string |
Mobisol |
|
uid device_uid + metered_at
|
string |
a2ei-grid01_2022-01-01T13:00:00.000+00:00 |
|
device_uid organization_id + manufacturer + serial_number
|
string |
a2ei-grid01 |
|
interval_seconds The interval between measurements in seconds Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
3600 |
|
output_energy_interval_wh The energy consumption in the specified time interval, system to customer (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
output_energy_cumulative_wh The cumulative energy consumption, system to customer (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
ac_input_power_factor The 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 |
0.45 |
|
ac_input_power_factor_phase1 The ratio of working power to the apparent power for phase 1, value between from 0 and 1 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_phase2 The ratio of working power to the apparent power for phase 2, value between from 0 and 1 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
ac_input_power_factor_phase3 The ratio of working power to the apparent power for phase 3, value between from 0 and 1 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
0.45 |
|
output_power_w The power output of the device in Watts (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
output_voltage_v The voltage output of the device in Volts (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
output_current_a The current output of the device in Ampere (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
output_frequency_hz The frequency of the device in Hertz (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
58.93 |
|
ac_input_energy_interval_wh The AC input into the system in the specified time interval, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
ac_input_energy_cumulative_wh The cumulative AC input into the system, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
ac_input_energy_cumulative_phase1_wh The cumulative AC input into the system's first phase, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
61.65 |
|
ac_input_energy_cumulative_phase2_wh The cumulative AC input into the system's second phase, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
61.65 |
|
ac_input_energy_cumulative_phase3_wh The cumulative AC input into the system's third phase, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.61 |
|
ac_input_power_w The electrical power consumed by the device from the AC supply (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
ac_input_voltage_v The voltage level of the alternating current (AC) being supplied to the device (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase1_v The voltage level of the alternating current (AC) being supplied to the device's first phase (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase2_v The voltage level of the alternating current (AC) being supplied to the device's second phase (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_voltage_phase3_v The voltage level of the alternating current (AC) being supplied to the device's third phase (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
ac_input_current_a The amount of alternating current (AC) being drawn by the device in amperes (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
ac_input_current_phase1_a The amount of alternating current (AC) being drawn by the device's first phase in amperes (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
61.65 |
|
ac_input_current_phase2_a The amount of alternating current (AC) being drawn by the device's second phase in amperes (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
61.65 |
|
ac_input_current_phase3_a The amount of alternating current (AC) being drawn by the device's third phase in amperes (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.61 |
|
ac_input_frequency_hz The frequency (Hz), of the alternating current (AC) supplied Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
58.93 |
|
ac_input_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 |
2 |
|
dc_input_energy_interval_wh The DC input into the system in the specified time interval, ex. from a solar panel (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
dc_input_energy_cumulative_wh The cumulative energy input into the system from the DC source(s), ex. from a solar panel (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
dc_input_power_w The power input reading in watts (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1489.6 |
|
dc_input_voltage_v The voltage input reading in volts (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
164.65 |
|
dc_input_current_a The current input reading in ampere (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
22.61 |
|
battery_energy_charged_interval_wh The energy production in battery in time interval (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
123.456 |
|
battery_energy_charged_cumulative_wh The cumulative energy charged in battery (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
12473.02 |
|
battery_energy_discharged_interval_wh The amount of energy discharged over a specific time interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
14.5 |
|
battery_energy_discharged_cumulative_wh The cumulative energy discharged from battery (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
14.5 |
|
battery_power_io_w The battery input / output in watts (>0 = charging) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
-37.58 |
|
battery_voltage_v The battery voltage in volts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
23.6 |
|
battery_current_io_a The input or output current flowing into or out of the battery (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
10.1 |
|
battery_state_of_charge_percent The battery charge level in percentage Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
76.8 |
|
battery_temperature_celsius The battery temperature in celsius Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
76.8 |
|
paygo_account_status active, completed, defaulted, cancelled, locked, returned |
string |
active |
|
paygo_unlocked_until The date the paygo account will be locked |
datetime |
2022-01-01T00:03:00.585+00:00 |
|
paygo_days_left The days left until next payment (only used until system is paid off) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
7 |
|
is_locked No energy coming through, locked due to missing payments |
boolean |
FALSE |
|
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 |
|
import_id References Import 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 |
|
last_import_id Id of the last import which updated the record
|
integer |
337 |
|
last_source_id Id of the last Source which updated the record
|
integer |
33 |