Convert CURL command line to VBA

Question

In CURL, I can use this line

curl --data 'DataToBeSent' https://example.com/resource.cgi

I am struggling to convert such line to be used in VBA and this is my try till now

Sub POST_Method_Example()
Dim myMessage As String

myMessage = "DataToBeSent"

With CreateObject("MSXML2.ServerXMLHTTP")
    .Open "POST", "https://example.com/resource.cgi"

    .setRequestHeader "Content-Type", "multipart/form-data; boundary==------------------------d74496d66958873e"
    .send sData(myMessage)
    Debug.Print .ResponseText
End With
End Sub

But this throws an error at the json response. How can I make this works for VBA?

I can get it work on postman by assigning the url and in Body tab I selected "form-data" and assign KEY: text and VALUE: DataToBeSent This returns a successful response.

@QHarr Welcome back. Waiting for your experience.

YasserKhalil
– YasserKhalil

2020-03-29 08:15:20 +00:00
Commented Mar 29, 2020 at 8:15 — YasserKhalil
– YasserKhalil, Commented Mar 29, 2020 at 8:15

CDP1802 · Accepted Answer · 2020-03-29 15:32:17Z

2

See multipart/form-data for when to use.

Sub POST_Method_Example()

    With CreateObject("MSXML2.ServerXMLHTTP")
        .Open "POST", "https://example.com/resource.cgi"
        .setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
        .send "text=Data to be sent"
        Debug.Print .ResponseText
    End With

End Sub

answered Mar 29, 2020 at 15:32

CDP1802

17.3k2 gold badges10 silver badges19 bronze badges

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

1 Comment

YasserKhalil Over a year ago

Thank you very much for great help. Can you have a look at this link, please? stackoverflow.com/questions/60890492/…

Collectives™ on Stack Overflow

Convert CURL command line to VBA

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related