(Excel) Backblaze S3 List Bucket Objects

See more Backblaze S3 Examples

Demonstrates how to list the objects in a bucket.

The Chilkat S3 functions in the HTTP class are compatible with the Backblaze service. However, because of some specific issues, Chilkat v9.5.0.89 or later is needed.

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

' keyID = Access Key ID or Access Key
http.AwsAccessKey = "access-key"

' applicationKey = Secret Access Key or Secret Key
http.AwsSecretKey = "secret-key"

' Region is the 2nd part of your S3 Endpoint
http.AwsEndpoint = "s3.us-west-002.backblazeb2.com"


bucketName = "chilkat-test"


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" standalone="yes"?>
' <ListBucketResult xmlns="http://s3.amazonaws.com/doc/2006-03-01/">
'     <Contents>
'         <ETag>"303fb46cf341094fef6274b7789cd6aa"</ETag>
'         <Key>orchard.json</Key>
'         <LastModified>2021-10-30T14:45:52.000Z</LastModified>
'         <Owner>
'             <ID>f2ebbc5f792c</ID>
'             <DisplayName/>
'         </Owner>
'         <Size>22</Size>
'         <StorageClass>STANDARD</StorageClass>
'     </Contents>
'     <Contents>
'         <ETag>"a8551f0a5437f43a796fca7623ee9232"</ETag>
'         <Key>seahorse.jpg</Key>
'         <LastModified>2021-10-30T14:38:53.000Z</LastModified>
'         <Owner>
'             <ID>f2ebbc5f792c</ID>
'             <DisplayName/>
'         </Owner>
'         <Size>24388</Size>
'         <StorageClass>STANDARD</StorageClass>
'     </Contents>
'     <IsTruncated>false</IsTruncated>
'     <MaxKeys>1000</MaxKeys>
'     <Name>chilkat-test</Name>
'     <Prefix/>
'     <Marker/>
' </ListBucketResult>


ListBucketResult_xmlns = xml.GetAttrValue("xmlns")

i = 0

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

IsTruncated = xml.GetChildContent("IsTruncated")

MaxKeys = xml.GetChildIntValue("MaxKeys")

Name = xml.GetChildContent("Name")