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.
What macOS version do you use?
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
@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
(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?
(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 ?
(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().
seems so... > SERVICEWEB in french version https://opengrok.libreoffice.org/xref/core/formula/inc/core_resource.hrc?r=71665582#2702 https://opengrok.libreoffice.org/xref/translations/source/fr/formula/messages.po?r=cbe7554c#2454
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.
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 ?
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?
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.