(Excel) S3 Delete Multiple Objects

Demonstrates how to delete multiple objects in a single HTTP request.

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 http As Chilkat.Http
Set http = Chilkat.NewHttp

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

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


bucketName = "chilkattestbucket"


objectName1 = "starfish.jpg"
' Delete a particular version of this object:

objectName2 = "conch.jpg; VersionId=""3/L4kqtJlcpXroDTDmJ+rmSpXd3dIbrHY+MTRCxf3vjVBH40Nr8X8gdRQBpUMLUo"""

objectName3 = "seaUrchin.jpg"

Dim sa As Chilkat.StringArray
Set sa = Chilkat.NewStringArray
Dim success As Boolean
success = sa.Append(objectName1)
success = sa.Append(objectName2)
success = sa.Append(objectName3)


Set resp = http.S3_DeleteMultipleObjects(bucketName,sa)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Display the JSON response.
Debug.Print resp.BodyStr