Help with Xpath expression or transformation of it

I’m a bit late to this party but I found it easier to first transform the entsoe XML to JSON and then parse that. See Control a water heater and ground source heat pump based on cheap hours of spot priced electricity - #13 by masipila