Ask Your Question
0

How to Link An API into a Spreadsheet

asked 2017-11-19 01:24:08 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

Comments

1

Also asked here

robleyd gravatar imagerobleyd ( 2017-11-19 06:55:53 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-06-04 01:28:19 +0200

tarmog gravatar image

Please see my answer here, working sample file incuded: https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more
0

answered 2017-11-19 14:55:28 +0200

Ratslinger gravatar image

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 ✔ (upper left area of answer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-19 01:24:08 +0200

Seen: 2,201 times

Last updated: Jun 04