Documentation: grids_ts

Time Series data of individual grids

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
grid_name * Name of of the (mini-)grid * requis	string	SMU 12 Chinsanka
grid_external_id * ID for the specific (mini-)grid, used to build the grid_uid * requis	string	X98679862w
metered_at * time the metrics apply to (not time of query) * requis	datetime	2022-01-01 13:00:00.000Z
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
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
interval_seconds interval for kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	integer	3600
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
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
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
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
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
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
grid_uid organization_id + data_origin + grid_external_id; FK from grids table généré automatiquement	string	a2ei-X98679862w