How do I send POST NVP api request in VBA?

Question

Dim req As New MSXML2.XMLHTTP60
req.Open "POST", "https://somewebsite.com/vpc"
req.setRequestHeader "Content-Type", "text/plain"
req.setRequestHeader "Accept", "application/xml"
req.send "Code=12345&Amount=100&Account=user......."
Debug.Print req.responseText

I get Account was+not+present+in+the+request in responseText

Updated questions: What is the format or syntax where you can send POST NVP in VBA?

Without access to the docs for the API in question, how could we know what's the correct format? — Tim Williams, Feb 27 '23 at 19:23
are you able to successfully make the same request in postman or curl etc.? — cyboashu, Feb 27 '23 at 19:42
Yes, the command worked in postman. I want to how to do it in VBA. — DNguyen, Feb 27 '23 at 20:09

DNguyen · Answer 1 · 2023-02-27T21:20:26.317

0

Thanks Cyboashu, I looked at the header in postman, copy it and got it to worked in VBA. Here is code in case anyone is wondering

Dim req As New MSXML2.XMLHTTP60
req.Open "POST", "https://somewebsite.com/vpc"
req.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
req.send "Code=12345&Amount=100&Account=user......."
Debug.Print req.responseText

edited Feb 27 '23 at 21:20

answered Feb 27 '23 at 21:13

DNguyen

7
3

How do I send POST NVP api request in VBA?

1 Answers1