For UK data, take a look at Elexon's Insights Solution, it has an API that supports XML, JSON and CSV. https://developer.data.elexon.co.uk/

This will replace the older BMRS next year. That also has an API - https://bscdocs.elexon.co.uk/guidance-notes/bmrs-api-and-dat...