(Excel) REST through HTTP Proxy

Demonstrates how to connect through an HTTP proxy to make REST API calls.

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.

' This example connects to a REST server through an HTTP proxy.
' It will connect to the Amazon AWS service for this example.
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest
Dim socket As Chilkat.Socket
Set socket = Chilkat.NewSocket

' Set the HTTP proxy domain or IP address, and port.
socket.HttpProxyHostname = "192.168.1.100"
socket.HttpProxyPort = 8088

' We want to tell the socket object that we're doing HTTP over the proxy connection.
' This is because an HTTP proxy used for other protocols (IMAP, SMTP, SSH, FTP, etc.) 
' can require some internal differences in behavior (i.e. how we do things).
socket.HttpProxyForHttp = True

' Other properties exist for specifying a proxy login, password, and authentication method (such as NTLM),
' but these are not used in this example.

' Connect through the HTTP proxy to the Amazon AWS server for the S3 service.

bTls = True

port = 443

maxWaitMs = 5000

success = socket.Connect("s3.amazonaws.com",port,bTls,maxWaitMs)
If (success <> True) Then
    Debug.Print "Connect Failure Error Code: "; socket.ConnectFailReason
    Debug.Print socket.LastErrorText
    Exit Sub
End If

' Use the proxied TLS connection:
success = rest.UseConnection(socket,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Provide AWS credentials for the REST call.
Dim authAws As Chilkat.AuthAws
Set authAws = Chilkat.NewAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
authAws.ServiceName = "s3"
success = rest.SetAuthAws(authAws)

' List all buckets for the account...

responseXml = rest.FullRequestNoBody("GET","/")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(responseXml)

' Show the full XML returned.
Debug.Print xml.GetXml()

' Iterate over the buckets, showing each bucket name.
success = xml.FindChild2("Buckets")
If (xml.FirstChild2() = True) Then
    Debug.Print xml.GetChildContent("Name")
    Do While (xml.NextSibling2() = True)
        Debug.Print xml.GetChildContent("Name")
    Loop
End If

' Move the internal pointer back to the root node.
xml.GetRoot2