(Excel) Load XML Object from HTTP Response Body

Demonstrates how to load the HTTP response body directly into an XML object.

Note: This example requires Chilkat v9.5.0.89 or greater because it uses the GetBodyXml method. Prior to v9.5.0.89, and application would need to first copy the HTTP response body to a Chilkat StringBuilder object by calling GetBodySb, and then load the Xml object by calling Xml.LoadSb.

Download Excel Class Modules Chilkat Excel Class Modules

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


Set resp = http.PText("GET","https://www.chilkatsoft.com/exampledata/inventory.xml","","","",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml

' If we wish to transfer (instead of copy) the XML from the HttpResponse to the Xml, then add the keyword "TakeResponseBody" to UncommonOptions
' This could save memory for extremely large XML responses.
resp.UncommonOptions = "TakeResponseBody"

Dim success As Boolean
success = resp.GetBodyXml(xml)

Debug.Print xml.GetXml()

' Note: If UncommonOptions contained "TakeResponseBody", then the response BodyStr will now be empty:
Debug.Print "----"
Debug.Print resp.BodyStr