🔔 Scheduled Maintenance Notification

Due to scheduled maintenance, the website will be temporarily unavailable tonight, the 06/11, from 21:00 to 23:59 CET. During this time, Prospect will not be accessible. We apologize for any inconvenience and appreciate your understanding. If you have any questions, please contact us at: support@prospect.energy The PROSPECT Team
06.11.2025 14:47

Documentation: reports

This table saves data from Ascent reports submitted by PIUs for both connections and non-connections based metrics. It saves them in the same level of granularity as the submitted report, allowing for validation checks and data ingestion.
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
Row Name Type Example

external_id *

external identifier generated by concatenating and hashing five of the submitted field values [country, report_start, report_end, category, breakdown, reporting_phase, unit_of_measurement, program, reported_source]. This ensures that identical records always produce the same UID, to enable upsert, deduplication operations.

  • * required
string

c782c9d4731f26d3d040d6a4a24ebd66

country *

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

  • * required
string

RW

reporting_phase *

Unique identifier for the reporting phase, typically a sequential alpha-numeric code. It helps us identify the ASCENT phase or project that the reported data belongs to.

  • * required
string

P001

report_start *

Start date of the reporting period.

  • * required
date

2023-01-01

report_end *

End date of the reporting period.

  • * required
date

2023-01-31

category *

Category of the report, indicating whether it pertains to connections or non-connections metrics.

  • * required
enum: connections, non-connections

connections

unit_of_measurement *

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

  • * required
string

number

breakdown *

JSON object providing the breakdown of the reported record. Includes details such as connection type, end-user type, and the gender of the household head or business owner.

  • * required
jsonb

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

value *

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

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

  • * required
float

100.0

reported_source *

The source of the value, indicating where the value was obtained from, example: Utility, company, contractor, etc or Odyssey. This helps in identifying the origin of the data and ensuring its validity.

  • * required
string

Utility

program *

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

  • * required
string

ASCENT

uid

Unique identifier of a single reported metric for a given period, generated by concatenating the following fields: [organization_id, source_id and external_id].

  • auto-generated
string

123_12_c782c9d4731f26d3d040d6a4a24ebd66

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • auto-generated
integer

1

import_id

References Import of data

  • auto-generated
integer

1

organization_id

References Organization of data

  • auto-generated
integer

1

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic

last_import_id

Id of the last import which updated the record

  • auto-generated
integer

337

last_source_id

Id of the last Source which updated the record

  • auto-generated
integer

33