Sélectionnez votre langue

Data Protection Update - July 2026

We’ve upgraded how sensitive data is protected. Prospect now uses a personal vault instead of the previous encryption key. Your vault gives you secure, private access to protected organization data. Click the Vault icon in the top menu to complete the setup. Nous avons amélioré la protection des données sensibles. Prospect utilise désormais un coffre personnel au lieu de l’ancienne clé de chiffrement. Votre coffre vous donne un accès sécurisé et privé aux données protégées de votre organisation. Cliquez sur l’icône Coffre dans le menu supérieur pour finaliser la configuration.
08.07.2026 10:35

Dashboard Update - July 2026

We’ve updated the dashboards. If you experience loading or display issues, please clear your cookies and browser cache. Nous avons mis à jour les tableaux de bord. Si vous constatez des problèmes d’affichage, veuillez vidervos cookies et le cache de votre navigateur.
08.07.2026 10:34

Documentation: yearly_reports

This tables aggregates the data from the reports table into yearly summaries. It allows for simplification of queries on Grafana.
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

year *

The year for which the aggregate data is calculated.

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

  • * requis
integer

2023

category *

Category of the metric, indicating whether it pertains to connections or non-connections data.

  • * requis
enum: connections, non-connections

connections

country *

Two-letter country code as per ISO 3166-1 alpha-2 standard representing the country of the metric.

  • * requis
string

RW

breakdown *

JSON object providing the breakdown of the metric. Includes details such as connection type, end-user type, etc.

  • * requis
jsonb

{"type": "Grid", "end_user_type": "residential", "primary_responsible_person_gender": "M"}

unit_of_measurement *

Unit of measurement for the metrics reported, such as kWh, number of connections, people etc.

  • * requis
string

number

value *

The aggregate value of the metric being reported, such as the total number of connections, total energy consumed, or any other relevant metric aggregated for the year.

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

  • * requis
float

1000.0

program *

This helps us extend the use cases for this table by linking it to the program under which the aggregated report was submitted, helping to categorize the data and link it to specific programs.

  • * requis
string

ASCENT

last_source_id

Id of the last Source which updated the record

  • généré automatiquement
integer

33

last_import_id

Id of the last import which updated the record

  • généré automatiquement
integer

337

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

reporting_phase

The specific project for which the aggregate is calculated for. It helps us identify the ASCENT phase or project that the aggregate reported data belongs to.

string

P0001

external_id

external identifier for each yearly aggregate entry. Derived by concatenating and hashing the following fields: [year, category, country, breakdown, reporting_phase,program, unit_of_measurement]

  • généré automatiquement
string

c782c9d4731f26d3d040d6a4a24ebd66

uid

unique identifier for each yearly aggregate entry. Derived by concatenating the following fields: [organization_id and external_id].

  • généré automatiquement
string

123_12_c782c9d4731f26d3d040d6a4a24ebd66

Progression