(Excel) Send XMLHttpRequest and Get Response

Demonstrates how to send an HTTP XML request and retrieve the response.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' The XML sent in the body of the request is application
' specified -- it should contain whatever the server-side
' application is expecting..

xmlStr = "<?xml version=""1.0"" encoding=""UTF-8""?><appXml><something>123</something></appXml>"

' The PostXml method may be called to send the XMLHttpRequest
' using the "POST" HTTP method (also known as "verb").

urlEndpoint = "http://www.chilkatsoft.com/xmlEcho.asp"

xmlCharset = "utf-8"

Set resp = http.PostXml(urlEndpoint,xmlStr,xmlCharset)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' The raw HTTP request sent by the above call is:

' POST /xmlEcho.asp HTTP/1.1
' Content-Type: text/xml
' Host: www.chilkatsoft.com
' Accept: */*
' Accept-Charset: ISO-8859-1,utf-8;q=0.7,*; q=0.7
' Accept-Language: en-us,en;q=0.5
' Accept-Encoding: gzip
' Content-Length: 81
' 
' <?xml version="1.0" encoding="UTF-8"?><appXml><something>123</something></appXml>

' Examine the Body of the HTTP response
' This would be the XML response sent by the server.
Debug.Print resp.BodyStr