(Excel) REST through SSH Tunnel

Demonstrates how to connect through an SSH Tunnel (via port-forwarding) 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.

Dim tunnel As Chilkat.Socket
Set tunnel = Chilkat.NewSocket


sshHostname = "sftp.example.com"

sshPort = 22

' Connect to an SSH server and establish the SSH tunnel:

success = tunnel.SshOpenTunnel(sshHostname,sshPort)
If (success <> True) Then
    Debug.Print tunnel.LastErrorText
    Exit Sub
End If

' Authenticate with the SSH server via a login/password
' or with a public key.
' This example demonstrates SSH password authentication.
success = tunnel.SshAuthenticatePw("mySshLogin","mySshPassword")
If (success <> True) Then
    Debug.Print tunnel.LastErrorText
    Exit Sub
End If

'  OK, the SSH tunnel is setup.  Now open a channel within the tunnel.
'  (Any number of channels may be created from the same SSH tunnel.
'  Multiple channels may coexist at the same time.)

' This example connects to a REST server through the SSH tunnel.
' It will connect to the Amazon AWS service for this example.
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest


bTls = True

port = 443

maxWaitMs = 5000

' This returns a socket object that is a single channel within the SSH tunnel.
Set channel = tunnel.SshOpenChannel("s3.amazonaws.com",port,bTls,maxWaitMs)
If (tunnel.LastMethodSuccess <> True) Then
    Debug.Print tunnel.LastErrorText
    Exit Sub
End If

' Use the connection.  (This connection is a TLS running on an SSH channel through an SSH tunnel.
' In other words, TLS is wrapped within the SSH tunnel.)
success = rest.UseConnection(channel,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