Ask Your Question
0

How to Link An API into a Spreadsheet

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

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

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 +0100

Seen: 1,913 times

Last updated: Nov 19 '17