Trouble downloading orders to MS Access via API

Trouble downloading orders to MS Access via API

enargins
New Member
5 0 0

I'm using MS Access to download new orders from our store. The orders are stored in an Access table and the API call is set to look for all orders with Order ID greater than the last Order ID that was downloaded. We typically get less than 10 orders a day. 

 

The MS Access application uses a timer to query Shopify once per minute. It seems to work fine. No errors. And we're well below our rate limit.

 

Still, we find that after a while, it stops downloading orders, even though the application says that it connected but that there were no new orders to download. But then, if we close and reopen the MS Access application, then it gets the new orders, some of which may be several hours old already.

 

So it's not clear why it stops working after a while. There are no error messages. And looking at the logged JSON responses, everything seems normal.

 

Any ideas what might be going on? 

 

Thanks!

Reply 1 (1)

enargins
New Member
5 0 0

Note: this has been resolved, thanks for help from ChatGPT. It suggested using WinHttp.WinHttpRequest.5.1 to connect instead of MSXML2.XMLHTTP, and that resolved the issue.