how to do http request using libreoffice basic macros

Question

I want to write a macro on a LibreOffice spreadsheet, to send an HTTP request to an web URL and receive a JSON like response. Can i do it with LibreOffice basic macro programming? Where can i get information about the API.

I really appreciate any tips.

Thanks

Does [WEBSERVICE and FILTERXML](https://help.libreoffice.org/index.php?title=Calc/WEBSERVICE&Language=en-US&System=WIN&Version=5.3#bm_id3150028) do what you need? — Jim K, Jun 26 '17 at 14:49
I don't know. When i put that on the basic macro, it says that the routine WEBSERVICE is not defined — Antonio Fernandes, Jun 27 '17 at 20:17
They are Calc formulas, not Basic functions. Enter them in the spreadsheet. — Jim K, Jun 27 '17 at 20:19
Ho i see. But the intention is to write a macro in basic to do some tasks via webservices. — Antonio Fernandes, Jun 29 '17 at 00:21

score 7 · Answer 1 · answered Sep 08 '19 at 16:45

I'm too late to help Antonio, but for posterity...

You can call spreadsheet functions from Basic, as explained in the open office docs. Here's a simple example that invokes the WEBSERVICE() function:

Function GetWebContent(url As string) As String
    On Error GoTo ErrorHandler

    Dim funtionAccess As Object
    functionAccess = createUnoService("com.sun.star.sheet.FunctionAccess")

    GetWebContent = functionAccess.callFunction("WEBSERVICE",Array(url))

    Exit Function
ErrorHandler:
    GetWebContent = "Error " & Err
End Function


Function Test

    Dim url As String
    url = "http://www.google.com"

    Dim response As String
    response = GetWebContent(url)

End Function

I'm getting an IllegalArgumentException when I use an "https" address instead of an "http" address - is that just not allowed?? — Erhannis, Mar 21 '21 at 00:07

how to do http request using libreoffice basic macros

1 Answers1