Documentation: grids_ts
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
Required | Type | p14n | Blurred | Autogenerated | Example | |
---|---|---|---|---|---|---|
grid_name Name of of the (mini-)grid |
✓ | string | ⤫ | ⤫ | ⤫ |
SMU 12 Chinsanka |
grid_external_id ID for the specific (mini-)grid, used to build the grid_uid |
✓ | string | ⤫ | ⤫ | ⤫ |
X98679862w |
metered_at time the metrics apply to (not time of query) |
✓ | datetime | ⤫ | ⤫ | ⤫ |
2022-01-01 13:00:00.000Z |
grid_uid organization_id + data_origin + grid_external_id; FK from grids table |
⤫ | string | ⤫ | ⤫ | ✓ |
a2ei-X98679862w |
primary_source_to_customer_kwh PV to consumers in kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
5.234 |
primary_source_to_battery_kwh PV to battery in kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
0.0 |
secondary_source_to_customer_kwh genset to consumers in kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
1.1 |
secondary_source_to_battery_kwh genset to battery in kilowatt hour (will probably be 0) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
0.0 |
battery_to_customer_kwh battery to consumers in kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
10.234 |
battery_charge_state_percent battery charge level in percentage Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | float | ⤫ | ⤫ | ⤫ |
88.2 |
interval_seconds interval for kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | integer | ⤫ | ⤫ | ⤫ |
3600 |
households_connected statistic that is calculated based on separate raw data Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | integer | ⤫ | ⤫ | ⤫ |
245 |
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 |