Documentation: shs_ts

This table is deprecated and should not be used for imports

Time Series data of individual Solar Home Systems
To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
You can also supply us with files in xlsx, csv or json format. -> Example CSV
Row Name Type Mapping Example

manufacturer *

Manufacturer of the device

  • * required
string installations_ts => manufacturer

A2EI

serial_number *

Serial of the device

  • * required
string installations_ts => serial_number

ABC/123

metered_at *

time the metrics apply to (not time of query)

  • * required
datetime installations_ts => metered_at

2021-05-03 6:23:55

device_uid

organization_id + manufacturer + serial_number; FK from shs table

  • auto-generated
string installations_ts => device_uid

1-a2ei-ABC123

pv_input_w

PV to system in watts

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

 float installations_ts => dc_input_power_w

123.456

grid_input_w

grid to system in watts

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

 float installations_ts => ac_input_power_w

123.456

grid_input_v

grid input voltage in volts

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

 float installations_ts => ac_input_voltage_v

212.7

battery_v

battery voltage in volts

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

 float installations_ts => battery_voltage_v

23.6

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 installations_ts => battery_power_io_w

-37.58

battery_charge_percent

battery charge level in percentage

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

 float installations_ts => battery_state_of_charge_percent

76.8

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 installations_ts => output_power_w

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 installations_ts => ac_input_energy_cumulative_wh

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 installations_ts => ac_input_energy_interval_wh

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 installations_ts => dc_input_energy_cumulative_wh

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 installations_ts => dc_input_energy_interval_wh

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 installations_ts => output_energy_cumulative_wh

123.456

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 installations_ts => output_energy_interval_wh

123.456

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

paygo_is_paid_off

system is permanently unlocked

 boolean installations_ts => custom

true

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 installations_ts => paygo_days_left

7

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • auto-generated
integer

1

import_id

References Import of data

  • auto-generated
integer

1

organization_id

References Organization of data

  • auto-generated
integer

1

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic