I'm trying to use ServerXMLHTTP
I used it before to Download files from WEB servers and it works fine (Using the "GET" method)
Now I need to send data over to WS server using XML text
this is the XML text I send
Using the "POST" method I get a "Bad Request" response
Replacing the "POST" with "OPEN" I get some long reply that I can't understand
I used it before to Download files from WEB servers and it works fine (Using the "GET" method)
Now I need to send data over to WS server using XML text
this is the XML text I send
Code:
strHTTP = <CreateOrUpdateTaskRequest xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>
<UserName>USER_Name</UserName>
<Password>USER_PASS</Password>
<Operation>AutoSelect</Operation>
<TaskNumber>22788</TaskNumber>
<CustomerNumber>12969</CustomerNumber>
<EmployeeNumber>59</EmployeeNumber>
<DueDateAsYYYYMMDDHHMMSS>20181212000000</DueDateAsYYYYMMDDHHMMSS>
<Description>DESCRIPTION</Description>
<Notes>NOTES</Notes>
<Status>1</Status>
<Phone1></Phone1>
<CustomerName>CUST_NAME</CustomerName>
<Location>
<Address>CUST_ADRESS</Address>
</Location>
<Data1>DATA_1</Data1>
<Data2>DATA_2</Data2>
<Data3>DATA_3</Data3>
</CreateOrUpdateTaskRequest>Using the "POST" method I get a "Bad Request" response
Code:
Set xmlHTTP = CreateObject("MSXML2.ServerXMLHTTP")
With xmlHTTP
.Open "POST", strHTTP, False, strUserName, strPassword
.setRequestHeader "Content-Type", "text/xml"
.setRequestHeader "Content-Length", Len(strXML)
.send (strXML)
End With
Debug.Print vbCrLf & xmlHTTP.responseTextReplacing the "POST" with "OPEN" I get some long reply that I can't understand
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>405 - HTTP verb used to access this page is not allowed.</title>
<style type="text/css">
<!--
body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}
fieldset{padding:0 15px 10px 15px;}
h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0;color:#CC0000;}
h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;}
#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
background-color:#555555;}
#content{margin:0 0 0 2%;position:relative;}
.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}
-->
</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
<div class="content-container"><fieldset>
<h2>405 - HTTP verb used to access this page is not allowed.</h2>
<h3>The page you are looking for cannot be displayed because an invalid method (HTTP verb) was used to attempt access.</h3>
</fieldset></div>
</div>
</body>
</html>
