Bug 95009 - libreoffice calc does't complete a WebQuerry of specific URL, errors does not exist
Summary: libreoffice calc does't complete a WebQuerry of specific URL, errors does not...
Status: CLOSED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-13 12:35 UTC by trumn
Modified: 2015-11-05 00:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Insert external data - WebQuerry error (17.16 KB, image/png)
2015-10-13 13:48 UTC, V Stuart Foote 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description trumn 2015-10-13 12:35:34 UTC 
I tried to insert the data/table from this site

(http://www.eurexchange.com/exchange-de/produkte/idx/dax/17254!quotesSingleViewOption?callPut=Call&maturityDate=201512)

to calc via "Link to External Data". But it reported that no it is not existed, s. attachment.
Comment 1 V Stuart Foote 2015-10-13 13:42:29 UTC 
To NEEDINFO, and correcting Product/Component

As per help https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery

Did queries to this site ever produce OOo/LO/AOO WebQuerry parseable returns?

The tables are there once the site composes the query, so they can be copied and pasted into the Calc table. So data can be used--just not convenience of the WebQuerry mechanism.
Comment 2 V Stuart Foote 2015-10-13 13:43:47 UTC 
And little QA touch up, please provide OS and version of LibreOffice working with Calc from.
Comment 3 V Stuart Foote 2015-10-13 13:48:12 UTC 
Created attachment 119555 [details]
Insert external data - WebQuerry error
Comment 4 m_a_riosv 2015-10-13 21:29:21 UTC 
Seems that the query without "!quotesSingleViewOptionin" works fine.

http://www.eurexchange.com/exchange-en/products/idx/dax/17254?callPut=Put&maturityDate=201510
Comment 5 Eike Rathke 2015-10-26 17:48:22 UTC 
I broke this down to ucb/source/ucp/webdav-neon/NeonSession.cxx NeonSession::HEAD() where the NeonHeadRequest for inPath="/exchange-de/produkte/idx/dax/17254!quotesSingleViewOption?callPut=Call&maturityDate=201512" gets a "404 Not Found".

I also get 404 with
curl --head 'http://www.eurexchange.com/exchange-de/produkte/idx/dax/17254!quotesSingleViewOption?callPut=Call&maturityDate=201512'

also for
curl --head 'http://www.eurexchange.com/exchange-de/produkte/idx/dax/17254!quotesSingleViewOption'

also for
curl --head 'http://www.eurexchange.com/exchange-de/produkte/idx/dax/17254?callPut=Call&maturityDate=201512'

and for
curl --head 'http://www.eurexchange.com/exchange-de/produkte/idx/dax/17254'

The first successful HEAD is for
curl --head 'http://www.eurexchange.com/exchange-de/produkte/idx/dax/'

This smells like a rotten server side..

And OOPS,
curl --head 'http://www.eurexchange.com/exchange-en/products/idx/dax/17254?callPut=Put&maturityDate=201510'

indeed works, now note the working "exchange-en" vs the not working "exchange-de" AND "201510" vs "201512" AND omitted "!quotesSingleViewOption".
However, fiddling with those and trying
curl --head 'http://www.eurexchange.com/exchange-en/products/idx/dax/17254!quotesSingleViewOption?callPut=Put&maturityDate=201510'
or
curl --head 'http://www.eurexchange.com/exchange-de/products/idx/dax/17254!quotesSingleViewOption?callPut=Put&maturityDate=201510'

still gives 404.
Comment 6 Eike Rathke 2015-10-26 18:23:38 UTC 
Go and ask eurexchange.com, I'm resolving this as NOTOURBUG.

Specifically, the response to a HEAD request should be identical to a GET request, except the body and payload, see https://tools.ietf.org/html/rfc7231#section-4.3.2 or obsoleted https://tools.ietf.org/html/rfc2616#section-9.4