Documentation: grids_ts

Cette table est obsolète et ne doit pas être utilisée pour les importations de données.

Time Series data of individual grids

Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation de l'API
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

Vous pouvez également nous fournir des fichiers au format xlsx, csv ou json. -> Exemple CSV

Nom de la ligne	Type	Mappage	Exemple
grid_name * Name of of the (mini-)grid * requis	string	installations_ts => site_name	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	installations_ts => metered_at	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	installations_ts => custom	245
interval_seconds interval for kilowatt hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	integer	installations_ts => interval_seconds	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	installations_ts => battery_state_of_charge_percent	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	installations_ts => custom	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	installations_ts => custom	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	installations_ts => custom	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	installations_ts => custom	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	installations_ts => custom	5.234
grid_uid organization_id + data_origin + grid_external_id; FK from grids table Généré automatiquement	string	installations_ts => device_uid	a2ei-X98679862w