Documentation: shs_ts

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 Example

manufacturer

Manufacturer of the device

 ✓ string ⤫ ⤫ ⤫

A2EI

serial_number

Serial of the device

 ✓ string ⤫ ⤫ ⤫

ABC/123

metered_at

time the metrics apply to (not time of query)

 ✓ datetime ⤫ ⤫ ⤫

2021-05-03 6:23:55

device_uid

organization_id + manufacturer + serial_number; FK from shs table

 ⤫ string ⤫ ⤫ ✓

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

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

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

212.7

battery_v

battery voltage in volts

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

 ⤫ float ⤫ ⤫ ⤫

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

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

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

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

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

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

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

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

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

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

paygo_is_paid_off

system is permanently unlocked

 ⤫ boolean ⤫ ⤫ ⤫

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

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