(Excel) OSS List Bucket Objects (Alibaba Cloud)

See more Alibaba Cloud OSS Examples

Demonstrates how to list the objects in a bucket.

The Chilkat S3 functions in the HTTP class are compatible with Alibaba Cloud's OSS service.

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 AccessKey ID here:
http.AwsAccessKey = "access-key"

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

' To list objects in a bucket located in a different region, use the endpoint for that region, such as "oss-cn-hangzhou.aliyuncs.com 	"
' See Alibaba Object Storage Service Regions and Endpoints
http.AwsEndpoint = "oss-us-east-1.aliyuncs.com"


bucketName = "chilkat"


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>chilkat</Name>
'     <Prefix/>
'     <Marker/>
'     <MaxKeys>1000</MaxKeys>
'     <IsTruncated>false</IsTruncated>
'     <Contents>
'         <Key>orchard.json</Key>
'         <LastModified>2021-10-29T16:58:12.000Z</LastModified>
'         <ETag>"303FB46CF341094FEF6274B7789CD6AA"</ETag>
'         <Size>22</Size>
'         <StorageClass>STANDARD</StorageClass>
'         <Owner>
'             <ID>5035535379748121</ID>
'             <DisplayName>5035535379748121</DisplayName>
'         </Owner>
'     </Contents>
'     <Contents>
'         <Key>seahorse.jpg</Key>
'         <LastModified>2021-10-29T16:52:01.000Z</LastModified>
'         <ETag>"A8551F0A5437F43A796FCA7623EE9232"</ETag>
'         <Size>24388</Size>
'         <StorageClass>STANDARD</StorageClass>
'         <Owner>
'             <ID>5035535379748121</ID>
'             <DisplayName>5035535379748121</DisplayName>
'         </Owner>
' 
'     </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")
    StorageClass = xml.GetChildContent("Contents[i]|StorageClass")
    ID = xml.GetChildContent("Contents[i]|Owner|ID")
    DisplayName = xml.GetChildContent("Contents[i]|Owner|DisplayName")
    i = i + 1
Loop