LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

LibreOffice GetRest Plugin

The extension adds 2 new function to LibreOffice Calc.
Function GET(URL) offer you to get data from the internet by simple get request.
Function PARSEJSON(JSON,PATTERN) returns substructure of JSON
structure getting according to pattern.

★ ☆ ☆ ☆ ☆
Calc Extensions

Description

LibreOfficeGetRest plugin is Calc Add-Ins Extension which adds two functions to LibreOffice calc.

Added functions

1) Get

Get function allow user to perform get request to remote server end get data from it.

Syntax: =get(URL) Where URL is URL which to send a GET request.
Value of cell will be result of get request.
Example:
Cell content:
=get("http://api.openweathermap.org/data/2.5/weather?q=London,uk")
Cell value:
{ "coord":{ "lon":-0.13, "lat":51.51 }, "sys":{ "type":1, "id":5091, "message":0.1999, "country":"GB", "sunrise":1413008314, "sunset":1413047741 }, "weather":[ { "id":801, "main":"Clouds", "description":"few clouds", "icon":"02d" } ], "base":"cmc stations", "main":{ "temp":287.3, "pressure":1011, "humidity":62, "temp_min":285.15, "temp_max":289.15 }, "wind":{ "speed":5.1, "deg":230 }, "clouds":{ "all":20 }, "dt":1413046702, "id":2643743, "name":"London", "cod":200 }

 

2) Parse JSON

Parse JSON function allow u to get JSON substructure or direct value from JSON structure
Syntax: =PARSEJSON(JSON,Pattern) Where JSON is valid JSON structure. Pattern is a set of commands to parser splited by dote symbol '.' command.command.command.
There two different commands get(XXX) which return the XXX element of JSON array structure, and objectName command which get the value of json object by its name.
Value of cell will be result of parsing if JSON valid and pattern correct or error message otherwise
Example:
Cell content:
A1=
{

{
"firstName": "John",
"lastName": "Smith",
"isAlive": true,
"age": 25,
"height_cm": 167.6,
"address": {
"streetAddress": "21 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": "10021-3100"
},
"phoneNumbers": [ {
"type": "home",
"number": "212 555-1234"
},
{
"type": "office",
"number": "646 555-4567"
} ],
"children": [],
"spouse": null
}

A2: =parsejson(A1,"phoneNumbers.get(1).number")
Cell value:
646 555-4567

Additional documentation: https://github.com/BinnaryWolf/LibreOfficeGetRestPlugin/wiki

Feedback

★ ☆ ☆ ☆ ☆

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • Mario Crevato Oct 16, 2023, 4:49 PM (13 months ago)

    ☆ ☆ ☆ ☆ ☆

    How download the extension ?

  • Roland Giesler Feb 16, 2023, 11:04 AM (21 months ago)

    ☆ ☆ ☆ ☆ ☆

    What a brilliant site! It tells me all about the plugin, but there is no link to get it???

  • Giuseppe Gencarelli Sep 19, 2022, 5:55 PM (2 years ago)

    ☆ ☆ ☆ ☆ ☆

    How to get it?

  • Wayne Sexton Jul 9, 2022, 11:16 PM (2 years ago)

    ☆ ☆ ☆ ☆ ☆

    Where is the download links for this extension? They are not showing!

  • Jhani Coetzee Jun 22, 2022, 9:49 PM (2 years ago)

    ☆ ☆ ☆ ☆ ☆

    I finally got it working, but now I get the error: "Failed to set up connection Received fatal alert: protocol_version" if I connect to the Northwind demo service with this url:
    "https://services.odata.org/Northwind/Northwind.svc/Products?$format=json". Anyone know why this is happening?

  • Santiago Botta Jun 20, 2022, 9:28 PM (2 years ago)

    ☆ ☆ ☆ ☆ ☆

    I found it really helpful. Though I'm trying to fetch some data that contain numbers, which I want to use to evaluate calculations. Is there a way to cast string values from requests into numbers? The VALUE functions doesn't seem to work.

  • Thomas Gratier Oct 30, 2021, 8:44 PM (3 years ago)

    ☆ ☆ ☆ ☆ ☆

    Used it a while ago and happy with it. I was unable to download it because bintray now replaced. Using internet archive. If you go to it
    https://web.archive.org/web/*/http://dl.bintray.com/binnarywolf/LibreOfficeGetRestPlugin/LibreOfficeGetRestPlugin.oxt and wait for redirection, you will get the oxt file. I've also hosted a copy on a gist https://gist.github.com/ThomasG77/4ed97370af8355feabf50cb2909198a0

  • Søren Christensen Jul 29, 2021, 4:37 PM (3 years ago)

    ★ ★ ★ ☆ ☆

    There seems to be a zip-file you can extract it from here: https://github.com/arachan/getrest/releases/latest

  • Alex DeLarge Feb 18, 2021, 3:52 AM (4 years ago)

    ☆ ☆ ☆ ☆ ☆

    Download link?

  • shaman TAO Jan 12, 2021, 10:29 AM (4 years ago)

    ☆ ☆ ☆ ☆ ☆

    Hello, where is the download link please ?

1 2

RSS feed for reviews on this page | RSS feed for all reviews