(Excel) SQS Purge Queue

Deletes all the messages in an SQS queue.

See SQS PurgeQueue or detailed information.

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.
' such as https://sqs.us-west-2.amazonaws.com/

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("sqs.us-west-2.amazonaws.com",port,bTls,bAutoReconnect)

' 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"
' the region should match our URL above..
authAws.Region = "us-west-2"
authAws.ServiceName = "sqs"

Dim success As Boolean
success = rest.SetAuthAws(authAws)

success = rest.AddQueryParam("Action","PurgeQueue")

' Use the actual path part of your SQS queue URL here:

responseXml = rest.FullRequestNoBody("GET","/123456789123/chilkatTest")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body: "; responseXml
    Exit Sub
End If

' Examine the successful XML response.
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(responseXml)
Debug.Print xml.GetXml()

' A sample PurgeQueue response:
' <PurgeQueueResponse>
'     <ResponseMetadata>
'         <RequestId>
'             6fde8d1e-52cd-4581-8cd9-c512f4c64223
'         </RequestId>
'     </ResponseMetadata>
' </PurgeQueueResponse>