Sélectionnez votre langue

Documentation: shs_ts

Time Series data of individual Solar Home Systems
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

manufacturer *

Manufacturer of the device

  • * requis
string

A2EI

serial_number *

Serial of the device

  • * requis
string

ABC/123

metered_at *

time the metrics apply to (not time of query)

  • * requis
datetime

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

paygo_days_left

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

paygo_is_paid_off

system is permanently unlocked

boolean

true

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

360

output_energy_interval_wh

energy consumption at 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_lifetime_wh

cumulative energy reading system to customer in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

pv_energy_interval_wh

energy production at time interval PV to system in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

pv_energy_lifetime_wh

cumulative energy reading PV to system in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

grid_energy_interval_wh

energy consumption at time interval grid to system in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

grid_energy_lifetime_wh

cumulative energy reading grid to system in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

system_output_w

system output to customer in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

battery_charge_percent

battery charge level in percentage

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

76.8

battery_io_w

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_v

battery voltage in volts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

23.6

grid_input_v

grid input voltage in volts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

212.7

grid_input_w

grid to system in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

pv_input_w

PV to system in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

float

123.456

device_uid

organization_id + manufacturer + serial_number; FK from shs table

  • généré automatiquement
string

1-a2ei-ABC123