Get (external?) data from a website

I want to get data once a day from the table shown at this website:
https://www.epexspot.com/en/market-results?market_area=DE&auction=&delivery_date=2025-01-19&underlying_year=&modality=Continuous&sub_modality=&technology=&data_mode=table&period=&production_period=&product=60
but the content of the table isn't part of the html code.
Is there any possibility to get and store this table content locally?

There is ALWAYS a possibility. :smile:

However, in this particular case, that possibility is more than a little convoluted. Looking at the data on-page, the "table" is not actually a single table and I expect it is dynamically generated anyway.

As such, you would need a full headless browser such as puppet. There are nodes that wrap such tools available in the flows library.

But even so, I suspect that getting the data in a meaningful way will be complex.

You could use something like node-html-parser to parse the retuned HTML and then build the proper structure by querying DOM elements.

Edit: I also found this flow, perhaps you'll find it helpful.
https://flows.nodered.org/flow/bd2cefe5cf8f36233b3b736deb256788

Thanks for the contributions, I found another and better way to get the epex data of the last years
Spot Market Prices | Energy-Charts