(Excel) S3 List Buckets (using Chilkat REST)

Demonstrates how to fetch a list of S3 buckets.

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)

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


i = 0

count_i = xml.NumChildrenHavingTag("Buckets|Bucket")
Do While i < count_i
    xml.I = i
    Name = xml.GetChildContent("Buckets|Bucket[i]|Name")
    CreationDate = xml.GetChildContent("Buckets|Bucket[i]|CreationDate")
    Debug.Print Name
    Debug.Print CreationDate
    Debug.Print "--"
    i = i + 1
Loop