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"