We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-05 09:56:59.832423


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

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


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

Question Tools



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

Seen: 13,753 times

Last updated: May 20 '16