Equivalent cURL in VBA?

Question

I have an API for my application which allows me to make cURL requests to it. I need to implement this into VBA so my desktop database can fire CURL requests to my web app.

curl -i --user [email protected]:password -X PUT -d "test=testing" https://mywebsite.com/api

How can i implement this in Access VBA? Can i use WinHttp.WinHttpRequest.5.1 ? Any examples? Thanks Adam,

adam Kearsley · Accepted Answer · 2013-06-12 10:57:40Z

30

Solved it now guys, works well. For other peoples convenience.

TargetURL = "https://www.mysite.co.uk/app/api/v1/test"
Set HTTPReq = CreateObject("WinHttp.WinHttpRequest.5.1")
HTTPReq.Option(4) = 13056 '
HTTPReq.Open "PUT", TargetURL, False
HTTPReq.SetCredentials "user", "password", 0
HTTPReq.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
HTTPReq.send ("test[status]=" & Forms!curl!Text0.Value & "&test2[status]=" & Text2.Value)
MsgBox (HTTPReq.responseText)

answered Jun 12, 2013 at 10:57

adam Kearsley

1,0192 gold badges14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

StockB Over a year ago

What is the significance of Option(4)? The WinHttpRequest documentation doesn't specify.

rodedo Over a year ago

I know it is 3 years ago, but I also wondered what this Option(4) is there fore and I found some useful information under this link johankanngard.net/2005/11/11/…

livefree75 Over a year ago

According to the WHR Option docs, the 4 is the enumeration value "WinHttpRequestOption_SslErrorIgnoreFlags". If you convert the 13056 to hex, you get 0x3300, which if you look further down to the SslErrorIgnoreFlags description, you can see that this ignores all the errors.

Juan Joya Over a year ago

Thank u a lot. I used a Get method, so I didn't use parameters, only url, but it worked just fine. Thank you again

Collectives™ on Stack Overflow

Equivalent cURL in VBA?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related