[Libreoffice-bugs] [Bug 144276] WEBSERVICE function to certain external URL results in #VALUE! error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144276

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Calc                        |framework

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
Might be a timing problem of the requests issued or the web server not wanting
to let have us access otherwise. Effectively we're getting a HTTP status code
403 Forbidden. Deep down at
https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#2235
the GET() call fails, or if retried already the getResourceOptions() call at
https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#2225
both with the 403. The latter for the OPTIONS() call at
https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#3928

It was successful twice when single stepping through that sequence in the
debugger, which doesn't make things easier, so I believe it is some (too fast)
timing problem and the server thinking bad of us thus denying with 403. Or we
issue some request between that isn't on its access-control-allow-methods list,
but it doesn't look like from the first glance (list with curl -i for that URL
is GET, HEAD, POST, PUT, PATCH, DELETE, OPTIONS).

On the other hand, using
curl -I
'http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN'
to issue a HEAD request I also get a 403 error. Which makes me believe the
server has a broken implementation anyway.

Nothing that could be solved at the Calc level and I'm not familiar with that
code. Setting 'framework' component. Not even sure this is a bug, given the
curl -I behaviour.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210903/e035e7c3/attachment.htm>