Sélectionnez votre langue

Documentation: installations_ts

Time Series data of individual devices
Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation API
Limite de débit : 300 requêtes par minute. Une fois la limite dépassée, toute requête ultérieure entraînera une réponse 429 (Trop de requêtes).
Vous pouvez également nous fournir des fichiers aux formats xlsx, csv ou json. -> Exemple CSV
Nom de la ligne Type Exemple

metered_at *

time the metric was measured (not time of query)

  • * requis
datetime

2022-01-01T13:00:00.000+00:00

serial_number *

Serial of the installed device

  • * requis
string

SHS/123

manufacturer *

The manufacturer of the device

  • * requis
string

Mobisol

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

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

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

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

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

  • généré automatiquement
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • généré automatiquement
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • généré automatiquement
integer

1

import_id

References Import of data

  • généré automatiquement
integer

1

organization_id

References Organization of data

  • généré automatiquement
integer

1

custom

Saves additional imported data out of standard structure

  • généré automatiquement
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • généré automatiquement
string

generic

last_import_id

Id of the last import which updated the record

  • généré automatiquement
integer

337

last_source_id

Id of the last Source which updated the record

  • généré automatiquement
integer

33

uid

device_uid + metered_at

  • généré automatiquement
string

a2ei-grid01_2022-01-01T13:00:00.000+00:00

device_uid

organization_id + manufacturer + serial_number

  • généré automatiquement
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