REST api POST method

**irade92** · 08-30-2013, 03:46 PM

hi
I am trying to "POST" data to a server but with no result
Here is my code

Private Sub POST_PRIMER()
Dim XMLHTTP
Dim Rezult As String
Dim ArgumentString
ArgumentString = "prescription_code=oz10763&exemp_from_participatio n=false&pharmacist_facsimile=913189&drug_fund_code =965421"
Set XMLHTTP = CreateObject("msxml2.xmlhttp.6.0")
XMLHTTP.Open "post", "https://api.zdravstvo.gov.mk/rest/prescriptions/realize", False

XMLHTTP.setRequestHeader "Content-Type", "application/xml"
XMLHTTP.send ArgumentString
result = XMLHTTP.responseText
Set XMLHTTP = Nothing
End Sub

where I am making mistake? Please help

Thanks

**ssanfu** · 08-30-2013, 04:53 PM

Dim Rezult As String

Spelling error

**June7** · 08-30-2013, 05:30 PM

Unless Option Explicit is declared, spelling should not be an issue, and if declared the compiler should bug on the unDimmed 'result'. The code doesn't do anything with result or Rezult.

**ItsMe** · 08-30-2013, 09:41 PM

API is an application interface, your application and their interface. I would start with combing through the server’s interface parameters for your POST command. They develop the API and you need to follow their (the server’s rules). I would double check the XML version they accept. They may not be set up for MS6.0. Double check your argument and make sure all characters are in order. Also, the .setRequestHeader seems more relative to a GET command than a POST command.

Once you match the correct MSXML version, make sure you have it installed on your OS and referenced in Access. Those are the questions I have after reading your post.

**ssanfu** · 09-01-2013, 02:01 AM

Read your PM, but I really don't understand what you are trying to accomplish; plus I have never tried writing to a server the way you are attempting to.

Why aren't you using ODBC to conned to the server and write the data?
What server are you connecting to?

**irade92** · 02-03-2015, 03:04 PM

????????????????????

**orange** · 02-03-2015, 03:18 PM

Just ran your code, you get this response

Code:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>403 Forbidden</title>
</head><body>
<h1>Forbidden</h1>
<p>You don't have permission to access /rest/prescriptions/realize
on this server.</p>
<hr>
<address>Apache/2.2.22 (Debian) Server at api.zdravstvo.gov.mk Port 443</address>
</body></html>

The code runs from my PC once I corrected the spelling error.

It says you DO NOT HAVE PERMISSION to access the server.

But we don't know what you are trying to accomplish. You probably need an account and password to be known to their system.
A little background and context would be helpful to readers.

**June7** · 02-03-2015, 03:21 PM

Do you have a response the questions in post 5? And to the comment in post3 that the code does nothing with variable result after it is populated with value.

What about the spelling of Rezult and result noted in post 2?

What is XMLHTTP? You want to post data to what application?

REST api POST method

Thread Tools

REST api POST method

Similar Threads

My post was deleted.

having one text area unlocked while the rest are locked on form

Remove first 5 characters from field, display the rest?

Help with subforms (and the rest)

Combox not filling the rest of the form

Posting Permissions