fetch Belgium generation

[peterdudfield]

Fetch Belgium generation data

You'll need to add a new method to belgium to save generation data.

You can data using
/api/explore/v2.1/catalog/datasets/ods087/records?select=datetime%2Crealtime&where=region%3D'Belgium'&order_by=datetime%20asc&limit=100 which gets the National level data. You'll need to get all regional data too.

The code here, might also help

This can be don eroughly like this

1. Add method to get belgium generation data to [here]. Need to return pandas dataframe with columns 'target_datetime_utc', 'solar_generation_kw', 'region', (https://github.com/openclimatefix/solar-consumer/blob/main/solar_consumer/data/fetch_be_data.py). The method could be called fetch_be_data_generation
2. Add unit test (mocking API)
3. Add intgergation test
4. run app locall (saving to csv)

[CodeVishal-17]

Hi @peterdudfield 👋

I’d like to work on this issue.

Plan:

1. Add a new method fetch_be_data_generation in fetch_be_data.py to fetch Belgium generation data and return a pandas DataFrame with:
   • target_datetime_utc
   • solar_generation_kw
   • region
2. Fetch both national and regional data from the ODS API.
3. Add unit tests with mocked API responses.
4. Add an integration test.
5. Verify locally by running the app and saving output to CSV.

I’ll open a draft PR once the initial implementation is ready.
Let me know if this approach works for you.

[peterdudfield]

Hi @CodeVishal-17

@pavankulkarni007 is actually going to take this

[CodeVishal-17]

Thanks for the update @peterdudfield 👍
All good — I’ll step back from this one.

Happy to help review or pick up another issue if needed.