https://bugs.documentfoundation.org/show_bug.cgi?id=148341
Bug ID: 148341
Summary: Webservice in Macro not working reliably (More then 1
request per macro call)
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: vitus.hawkri...@gmail.com
Description:
When trying to use the Webservice in a macro it sends the http request to the
server multiple times which causes an error because of the many requests. Even
though the first response would be sufficient, it takes the last response, the
error message.
Example code:
sub main
svc = createUnoService( "com.sun.star.sheet.FunctionAccess" ) 'Create a service
to use Calc functions
XML_String =
svc.callFunction("WEBSERVICE",array("https://ndcdyn.interactivebrokers.com/Universal/servlet/FlexStatementService.SendRequest?t=280014687756071353099584&q=664945&v=3";))
print svc.callFunction(“FILTERXML”, array(XML_String,
“/FlexStatementResponse/Status” ))
end sub
When the link is used in any browser it returns an xml with Status = Success,
in the macro above it always returns fail, error 1018 (which is too many
requests in short time period)
Steps to Reproduce:
1.Execute the code, if the status is "fail", you reproduced the bug:
sub main
svc = createUnoService( "com.sun.star.sheet.FunctionAccess" ) 'Create a service
to use Calc functions
XML_String =
svc.callFunction("WEBSERVICE",array("https://ndcdyn.interactivebrokers.com/Universal/servlet/FlexStatementService.SendRequest?t=280014687756071353099584&q=664945&v=3";))
print svc.callFunction(“FILTERXML”, array(XML_String,
“/FlexStatementResponse/Status” ))
end sub
2.
3.
Actual Results:
Response from Server: <FlexStatementResponse timestamp="03 April, 2022 05:16 PM
EDT">
<Status>Warn</Status>
<ErrorCode>1018</ErrorCode>
<ErrorMessage>Too many requests have been made from this token. Please try
again shortly.</ErrorMessage>
</FlexStatementResponse>
Expected Results:
<FlexQueryResponse queryName="minimum" type="AF">
<FlexStatements count="1">
<FlexStatement accountId="U4234234" fromDate="20220401" toDate="20220401"
period="LastBusinessDay" whenGenerated="20220403;091110">
<AccountInformation currency="EUR"/>
</FlexStatement>
</FlexStatements>
</FlexQueryResponse>
Reproducible: Always
User Profile Reset: Yes
Additional Info:
You can try this yourself by clicking this link and open in the browser. If you
refresh once, you get the right result, if you refresh quickly you get the
fail.
https://ndcdyn.interactivebrokers.com/Universal/servlet/FlexStatementService.SendRequest?t=280014687756071353099584&q=664945&v=3";
--
You are receiving this mail because:
You are the assignee for the bug.
