(Excel) Wasabi List Bucket Objects

See more Wasabi Examples

Demonstrates how to download and parse XML for the list of objects in a bucket.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Insert your access key here:
http.AwsAccessKey = "access-key"

' Insert your secret key here:
http.AwsSecretKey = "secret-key"

' Use the endpoint matching the bucket's region.
http.AwsEndpoint = "s3.us-west-1.wasabisys.com"


bucketName = "chilkattest"


strXml = http.S3_ListBucketObjects(bucketName)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; http.LastStatus

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml

success = xml.LoadXml(strXml)
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

' If the response status code was not 200, then the XML response is not a 
' listing of objects, but instead contains error information.
If (http.LastStatus <> 200) Then
    Debug.Print xml.GetXml()
    Debug.Print "Failed."
    Exit Sub
End If

' A sample response is shown below.
Debug.Print xml.GetXml()
Debug.Print "----"

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

' <?xml version="1.0" encoding="UTF-8"?>
' <ListBucketResult xmlns="http://s3.amazonaws.com/doc/2006-03-01/">
'     <Name>chilkattest</Name>
'     <Prefix/>
'     <Marker/>
'     <MaxKeys>1000</MaxKeys>
'     <IsTruncated>false</IsTruncated>
'     <Contents>
'         <Key>orchard.json</Key>
'         <LastModified>2021-10-27T22:58:49.000Z</LastModified>
'         <ETag>&quot;303fb46cf341094fef6274b7789cd6aa&quot;</ETag>
'         <Size>22</Size>
'         <Owner>
'             <ID>1039F31570DBC320E89D391632FCA06FE6D10CBB2ADBD0BF6439BB1DA0C3FAD6</ID>
'             <DisplayName>admin</DisplayName>
'         </Owner>
'         <StorageClass>STANDARD</StorageClass>
'     </Contents>
'     <Contents>
'         <Key>seahorse.jpg</Key>
'         <LastModified>2021-10-27T22:35:29.000Z</LastModified>
'         <ETag>&quot;a8551f0a5437f43a796fca7623ee9232&quot;</ETag>
'         <Size>24388</Size>
'         <Owner>
'             <ID>1039F31570DBC320E89D391632FCA06FE6D10CBB2ADBD0BF6439BB1DA0C3FAD6</ID>
'             <DisplayName>admin</DisplayName>
'         </Owner>
'         <StorageClass>STANDARD</StorageClass>
'     </Contents>
'     <Contents>
'         <Key>seahorse2.jpg</Key>
'         <LastModified>2021-10-27T22:03:51.000Z</LastModified>
'         <ETag>&quot;a8551f0a5437f43a796fca7623ee9232&quot;</ETag>
'         <Size>24388</Size>
'         <Owner>
'             <ID>1039F31570DBC320E89D391632FCA06FE6D10CBB2ADBD0BF6439BB1DA0C3FAD6</ID>
'             <DisplayName>admin</DisplayName>
'         </Owner>
'         <StorageClass>STANDARD</StorageClass>
'     </Contents>
' </ListBucketResult>


ListBucketResult_xmlns = xml.GetAttrValue("xmlns")

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")
    Debug.Print i; ": "; Key
    i = i + 1
Loop