Bug 140784 - The WEBSERVICE function doesn't work on macOS
Summary: The WEBSERVICE function doesn't work on macOS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2021-03-03 20:10 UTC by Régis H
Modified: 2024-05-14 09:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc sheet (17.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-03-03 20:10 UTC, Régis H
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Régis H 2021-03-03 20:10:05 UTC
Created attachment 170202 [details]
Calc sheet

Hello,

With a Calc table I'm importing data from this web address : "api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd"

with this formula: =SERVICEWEB("api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd")

On my Windows and Linux pcs it's working unfortunately on Osx it's not working, the link is not able to download data. But with the same function and not on this web adress it's working.

Thanks for your help.
Comment 1 Roman Kuznetsov 2021-03-11 12:36:10 UTC
What macOS version do you use?
Comment 2 Alex Thurgood 2021-03-12 08:14:02 UTC
I can confirm that entering the formula

=SERVICEWEB("api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd")

 in cell A1 in a new Calc spreadsheet produces a VALUE! error

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

Apple Mac Silicon M1
Comment 3 Régis H 2021-03-12 08:21:28 UTC
@Roman Kuznetsov,

actually I tested the function on High Sierra, Catalina and Big, it's not working on all those version.

Thanks for your help
Comment 4 Roman Kuznetsov 2021-03-12 08:31:25 UTC
(In reply to Alex Thurgood from comment #2)
> I can confirm that entering the formula
> 
> =SERVICEWEB("api.coingecko.com/api/v3/simple/
> price?ids=bitcoin&vs_currencies=usd")
> 
>  in cell A1 in a new Calc spreadsheet produces a VALUE! error
> 
> Version: 7.1.1.2 / LibreOffice Community
> Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
> CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
> Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
> Calc: threaded
> 
> Apple Mac Silicon M1

Alex, a correct function name is WEBSERVICE, so a formula should be

=WEBSERVICE("api.coingecko.com/api/v3/simple/
> price?ids=bitcoin&vs_currencies=usd")

Are you sure it was a correct checking?
Comment 5 Alex Thurgood 2021-03-12 08:36:17 UTC
(In reply to Roman Kuznetsov from comment #4)
 
> Alex, a correct function name is WEBSERVICE, so a formula should be
> 
> =WEBSERVICE("api.coingecko.com/api/v3/simple/
> > price?ids=bitcoin&vs_currencies=usd")
> 
> Are you sure it was a correct checking?

Im using a FR version of LO, and the function is localized.

For example, using the link given as an example in the online help for Calc with this function :

=SERVICEWEB("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=10&action=feedrecentchanges&feedformat=rss")

displays in the cell </channel></rss>

so something in the URL parser on macOS is causing the problem ?
Comment 6 Alex Thurgood 2021-03-12 08:48:36 UTC
(In reply to Roman Kuznetsov from comment #4)


> Alex, a correct function name is WEBSERVICE, so a formula should be
> 
> =WEBSERVICE("api.coingecko.com/api/v3/simple/
> > price?ids=bitcoin&vs_currencies=usd")

There is no Calc function WEBSERVICE() in my French version of LO, only SERVICEWEB().
Comment 8 Alex Thurgood 2021-03-12 09:19:53 UTC
The only thing I can currently think of is that the underscore in the link in the vs_currencies expression is misinterpreted by our URL parser on macOS.

Unfortunately, I don't have another resource link to hand with which to test this hypothesis.
Comment 9 Alex Thurgood 2021-03-12 10:00:57 UTC
Most of the links provided here :

https://mixedanalytics.com/blog/list-actually-free-open-no-auth-needed-apis/

fail with the same #VALUE! error message.

Is the problem then that LO doesn't know how to interpret JSON data streams ?
Comment 10 Maurice 2021-05-20 14:11:46 UTC
Hello,
same problem here.
I have urls where I get back a json-string (mapbox-api, google-maps-api), other url (graphhopper) I get #value! message.

Using macOS 10.15.7 (Catalina)

Any solutions?
Comment 11 Ferdinand 2024-05-14 09:56:06 UTC
Entering the examples from the help raises an error
libreoffice 24.2 on Macbook M1 latest ios

https://help.libreoffice.org/24.2/en-GB/text/scalc/01/func_webservice.html?&DbPAR=SHARED&System=MAC

Example
=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")

To fix this, 
-> Edit -> Links to external files -> click Update

IMO instead of issuing an error - a popup should ask if the link should be updated

BTW the field "automatic" update can't be selected.