(Excel) HTTP Download to Stream

Demonstrates how to stream the response body directly to a stream, which in this case is to a file stream.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' The URL we want to download is: 
' https://github.com/chilkatsoft/OAuth2-CSharp-Desktop/archive/master.zip
Dim url As Chilkat.Url
Set url = Chilkat.NewUrl
Dim success As Boolean
success = url.ParseUrl("https://github.com/chilkatsoft/OAuth2-CSharp-Desktop/archive/master.zip")

' Connect to the web server

bAutoReconnect = True

success = rest.Connect(url.Host,url.Port,url.Ssl,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

success = rest.SendReqNoBody("GET",url.Path)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Read the response header.

responseStatusCode = rest.ReadResponseHeader()
If (responseStatusCode < 0) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; responseStatusCode

' We expect a 200 response status if the file data is coming.
' Otherwise, we'll get a string response body with an error message(or no response body).
If (responseStatusCode = 200) Then

    Dim bodyStream As Chilkat.Stream
    Set bodyStream = Chilkat.NewStream

    ' The stream's sink will be a file.
    bodyStream.SinkFile = "qa_output/OAuth2-CSharp-Desktop/archive/master.zip"

    ' Read the response body to the stream.  Given that we've
    ' set the stream's sink to a file, it will stream directly
    ' to the file.
    success = rest.ReadRespBodyStream(bodyStream,True)
    If (success <> True) Then
        Debug.Print rest.LastErrorText
        Exit Sub
    End If

    Debug.Print "Successfully downloaded the file."

Else

    errResponse = rest.ReadRespBodyString()
    If (rest.LastMethodSuccess <> True) Then
        Debug.Print rest.LastErrorText
    Else
        Debug.Print errResponse
    End If

End If