How to Link An API into a Spreadsheet

I am wanting to link an API from a website for live data feed to a spreadsheet in LibreOffice

this is the link from the site. https://api.coinmarketcap.com/v1/ticker/

Is there a method to do this
And if so how to do Please

Also asked here

Hello,

What you are looking for is not directly built into LibreOffice. In some cases someone else may have written code to cover a specific task or function not yet in LO. These are extensions to LO and can be found on this post.

Your specific request for a specific site is probably not among those extensions. When this occurs the only recourse is to write your own code to fill the required needs. A brief look at the info indicates this is probably better done using Python for coding. You would send a request every X minutes (site asks for no more than 10 per min & it updates every 5 min) and parse the returned JSON data. Then with the info which you want, update your spreadsheet.

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).

Please see my answer here, working sample file incuded: