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
Required Type p14n Blurred Autogenerated 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

device_uid

organization_id + manufacturer + serial_number; FK from shs table

 ⤫ 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

 ⤫ 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