troubleshooting Question

Code getting Timeout expired

Avatar of bfuchs
bfuchsFlag for United States of America asked on
Microsoft AccessVisual Basic Classic.NET Programming
5 Comments2 Solutions167 ViewsLast Modified:
Hi experts,

I have the following code exporting some records to a web site.
                Set objHTTP = New WinHttp.WinHttpRequest
                
                'url = "https://c0aco743.caspio.com/rest/v2/tables/" & sTable & "/records"
                objHTTP.Open "POST", url, False
                objHTTP.SetRequestHeader "Accept", "application/json"
                objHTTP.SetRequestHeader "Content-Type", "application/json"
                objHTTP.SetRequestHeader "Authorization", "Bearer " + access_token
                    objHTTP.Send JsonConverter.ConvertToJson(patient)
Sometimes things are getting stuck and then code execution stops...
See attached error message, generated when executing last line.
Since there is not a problem with the data being sent, rather just a timing issue.
As next time I run the code for same data it works perfectly fine.
wondering what is the right approach for that?

Thanks
Untitled.png
Untitled1.png
ASKER CERTIFIED SOLUTION
John Tsioumpris
IT Supervisor
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros