link libre base to API on a website,

I need to be able to link the API on a website to either calc or base so that I can analyze data from the website.
The data is constantly changing so I need a dynamic link; and the link needs to be able to drill down to a second page on the site.
Can this be done?
If so, how?
I am not a programmer.

Thank you very much
Tom Markham

Hello @tommm,

The type of question has been asked a few times. Must be done with macros.

There are so many ways people want to access data and each has different requirements. One thing in common is they all need macro coding. For a couple of example requests see this post - Link to External data from website not working and another variant Import from REST API to Calc.

Not API but somewhat related - Use of WEBSERVICE within a macro in LibreOffice 6.0.1.1.