Ask Your Question
1

How do I insert JSON API (GET) data into a Calc spreadsheet?

asked 2016-05-20 13:58:42 +0200

Piano gravatar image

I'd like to insert data from a JSON API (GET method) into a LibeOffice Calc spreadsheet and have it updated after certain intervals. I have a URL and the JSON output is simple text. The information about this is very scarce online and the methods described no longer work.

https://wiki.documentfoundation.org/F... - This wiki site described the "Insert" -> "Link to external data" method. The problem is that in LibreOffice 5, this option is no longer even there. In LO4, it's there, but it doesn't work with the JSON output (I could set the separator symbols, but after finishing, there is no response, and the "OK" button is grayed out).

https://help.libreoffice.org/Calc/Ins... - This site speaks of an import filter called Web Page Query, but it doesn't handle URLs.

http://extensions.libreoffice.org/ext... - This is supposedly an LibreOffice extension to do achieve something similar, but there is no release available and the code on GitHub hasn't been touched for 2 years.

Could anyone help me out? It would be highly appreciated.

edit retag flag offensive close merge delete

Comments

LibreCalc should support modern REST APIs, which return JSON, by implementing a "FILTERJSON" function similar to FILTERXML. Here's the feature request.

dandv gravatar imagedandv ( 2017-11-21 17:06:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2016-05-20 17:38:27 +0200

Ratslinger gravatar image

There is not method in LO to handle JSON files directly. I have done it using macros and external utilities ( see this link ).

edit flag offensive delete link more

Comments

Is it possible to JSON API calls now, is there any news, dev updates?

creativeflower gravatar imagecreativeflower ( 2017-04-29 11:53:35 +0200 )edit

Not familiar with it myself, but you may want to look at Python.

Ratslinger gravatar imageRatslinger ( 2017-04-30 01:24:38 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-05-20 13:58:42 +0200

Seen: 8,487 times

Last updated: May 20 '16