(Excel) SQS Send Message

Note: This example requires a patch to work properly. It requires Chilkat v9.5.0.61, which can be obtained upon request to support@chilkatsoft.com

Delivers a message to the specified queue. With Amazon SQS, you now have the ability to send large payload messages that are up to 256KB (262,144 bytes) in size.

See SQS SendMessage or detailed information.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: This example requires a patch to work properly.  
' It requires Chilkat v9.5.0.61, which can be obtained upon request to support@chilkatsoft.com

' 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","SendMessage")
success = rest.AddQueryParam("MessageBody","This is the message body which can be up to 256K in size.")
success = rest.AddQueryParam("MessageAttribute.1.Name","test_attribute_name_1")
success = rest.AddQueryParam("MessageAttribute.1.Value.StringValue","test_attribute_value_1")
success = rest.AddQueryParam("MessageAttribute.1.Value.DataType","String")
success = rest.AddQueryParam("MessageAttribute.2.Name","test_attribute_name_2")
success = rest.AddQueryParam("MessageAttribute.2.Value.StringValue","test_attribute_value_2")
success = rest.AddQueryParam("MessageAttribute.2.Value.DataType","String")

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

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

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

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

' Examine the successful XML response.
success = xml.LoadXml(responseXml)
Debug.Print xml.GetXml()
Debug.Print "----"

' A successful response looks like this:
' <?xml version="1.0" encoding="utf-8" ?>
' <SendMessageResponse>
'     <SendMessageResult>
'         <MD5OfMessageBody>
'             fafb00f5732ab283681e124bf8747ed1
'         </MD5OfMessageBody>
'         <MD5OfMessageAttributes>
' 	    3ae8f24a165a8cedc005670c81a27295
'         </MD5OfMessageAttributes>
'         <MessageId>
'             5fea7756-0ea4-451a-a703-a558b933e274
'         </MessageId>
'     </SendMessageResult>
'     <ResponseMetadata>
'         <RequestId>
'             27daac76-34dd-47df-bd01-1f6e873584a0
'         </RequestId>
'     </ResponseMetadata>
' </SendMessageResponse>

' Get some values from the response XML:
Debug.Print "Body: "; xml.ChilkatPath("SendMessageResult|MD5OfMessageBody|*")
Debug.Print "MessageId: "; xml.ChilkatPath("SendMessageResult|MessageId|*")
Debug.Print "RequestId: "; xml.ChilkatPath("ResponseMetadata|RequestId|*")