(Excel) S3 List Bucket Objects (using Chilkat REST)

Demonstrates how to fetch a list of objects in an S3 bucket.

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

' Connect to the Amazon AWS REST server.

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("s3.amazonaws.com",port,bTls,bAutoReconnect)

' ----------------------------------------------------------------------------
' Important: For buckets created in regions outside us-east-1,
' there are three important changes that need to be made.
' See Working with S3 Buckets in Non-us-east-1 Regions for the details.
' ----------------------------------------------------------------------------

' 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)

'  Set the bucket name via the HOST header.
'  In this case, the bucket name is "chilkat100".
rest.Host = "chilkat100.s3.amazonaws.com"

Dim sbResponse As Chilkat.StringBuilder
Set sbResponse = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/",sbResponse)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If


statusCode = rest.ResponseStatusCode
Debug.Print "Response status code = "; statusCode

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
Dim success As Boolean
success = xml.LoadSb(sbResponse,True)
Debug.Print xml.GetXml()

If (statusCode <> 200) Then
    Debug.Print "Failed.  See error information in the XML."
    Exit Sub
End If

' Use this online tool to generate code from sample XML: 
' Generate Code to Create XML


Name = xml.GetChildContent("Name")

MaxKeys = xml.GetChildIntValue("MaxKeys")

IsTruncated = xml.GetChildContent("IsTruncated")

i = 0

count_i = xml.NumChildrenHavingTag("Contents")
Do While i < count_i
    xml.I = i
    Key = xml.GetChildContent("Contents[i]|Key")
    LastModified = xml.GetChildContent("Contents[i]|LastModified")
    ETag = xml.GetChildContent("Contents[i]|ETag")
    Size = xml.GetChildIntValue("Contents[i]|Size")
    ID = xml.GetChildContent("Contents[i]|Owner|ID")
    DisplayName = xml.GetChildContent("Contents[i]|Owner|DisplayName")
    StorageClass = xml.GetChildContent("Contents[i]|StorageClass")
    i = i + 1
Loop