Querying a web service using vbscript (virtual XML file)
There are lots of different ways people are building "web services" and "integration apis". This is one of many articles we have written to document that different types of vbscript code we have written for clients over the years.
In this example, we used vbscript to call an integration api by sending the integration api website an xml post. We don't literally create an XML file -- instead, we create an in memory a string that is formatted like an XML file, and then we send that "virtual XML" file to the integration web site.
xml = "<?xml version='1.0' encoding='utf-8' standalone='yes'?>" _
& "<update>" _
& "<orderid>" & theirorderid & "</orderid>" _
& "<status>Received</status>" _
& "<message></message>" _
& "<laborderid>" & ourorderid & "</laborderid>" _
url = "https://api.integrationwebsite.com/roes/order/mycustomer"
set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.open "POST", url, FALSE
xmlhttp.setRequestHeader "Content-type", "application/atom+xml"
'Now handle the response
response = xmlhttp.responseText