Calling an API from my VBA Access form

[newbie30]

Hi All,

I need to call an API that allows my Database to send data(date, name, reason,email) when the user keys it in the form. I also need to get the data from the URL and update my db with it.



A value of 0 indicates that details have been updated and -1 indicates some error.

I tried using this :

Dim httpReq AsNew MSXML2.ServerXMLHTTP
httpReq.Open "POST","my URL name",False
httpReq.send
Dim response AsString
response = httpReq.responseText
Debug.Print response

1. Do I require a Get and a POst operation as I need to both read and send data via the API?
2. Do you need to get the xml and pass any namespaces in the VBA code?

I have never done an API call via VBA access 2010, kindlyyy help.

If you require more details, am happy to provide.

Thanks
Newbie

[orange]

Can you provide more info?
Can you show us the url of the site?

You might get some ideas from this post.
You could also try Google or Bing and search for sample code.

I found this on youtube (It has a download sample).