I've been retrieving BBO data to score club games since March 2020 using Excel. The code (VBA) is largely unchanged since those times and certainly the overarching method: submit a cookie, retrieve traveller data from MyHands, score in a spreadsheet, export to club website.
I invoke a MSXML2.ServerXMLHTTP60 object and first GET the list of travellers via https://www.bridgeba...8489-&offset=0. But that now fails (on 6.35.2) having worked last week (6.34.?). The response headers returned are,
Cache-Control: no-store, no-cache, must-revalidate
Date: Fri, 07 Feb 2025 18:36:06 GMT
Pragma: no-cache
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Server: nginx
Set-Cookie: myhands_token=deleted; expires=Thu, 01 Jan 1970 00:00:01 GMT; Max-Age=0
All this is from my personal login - which I've used for years. Curiously, if I switch to the Virtual Club username (discovering and submitting its cookie in the request), it *does* work. The return is then,
Cache-Control: private
Date: Fri, 07 Feb 2025 18:20:01 GMT
Pragma: no-cache
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Server: nginx
Yet, aside from the cookie string, the same call is used. It's as if my cookie is no longer valid. My access in a browser is unaffected and I have checked the storage internals and the cookie is as used. I've done all manner of refreshes and reloads but am a loss to explain. I did wonder about changing my password but I thought I'd ask here first...
Any ideas?
Page 1 of 1
ServerXMLHTTP60 retrieval of MyHands data Working for years, now fails with cookie rejection
Page 1 of 1