(Excel) SQS Receive Message

Retrieves one or more messages from an Amazon SQS queue, with a maximum limit of 10 messages, from the specified queue.

See SQS ReceiveMessage 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","ReceiveMessage")
success = rest.AddQueryParam("MaxNumberOfMessages","5")
success = rest.AddQueryParam("VisibilityTimeout","15")
success = rest.AddQueryParam("AttributeName","All")
success = rest.AddQueryParam("MessageAttributeName","All")

' 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()
Debug.Print "----"

' A successful response looks like this:
' <?xml version="1.0" encoding="utf-8" ?>
' <ReceiveMessageResponse xmlns="http://queue.amazonaws.com/doc/2012-11-05/">
'     <ReceiveMessageResult>
'         <Message>
'             <Body>this is a test</Body>
'             <MD5OfBody>54b0c58c7ce9f2a8b551351102ee0938</MD5OfBody>
'             <ReceiptHandle>AQEBMyLof...UbKBTvHtEg==</ReceiptHandle>
'             <Attribute>
'                 <Name>SenderId</Name>
'                 <Value>957491831129</Value>
'             </Attribute>
'             <Attribute>
'                 <Name>ApproximateFirstReceiveTimestamp</Name>
'                 <Value>1475013283557</Value>
'             </Attribute>
'             <Attribute>
'                 <Name>ApproximateReceiveCount</Name>
'                 <Value>4</Value>
'             </Attribute>
'             <Attribute>
'                 <Name>SentTimestamp</Name>
'                 <Value>1475013283557</Value>
'             </Attribute>
'             <MessageId>52882c65-5e21-4450-9024-93a3b01e61d3</MessageId>
'             <MD5OfMessageAttributes>2ff68603f4239272bd03f543254ed040</MD5OfMessageAttributes>
'         </Message>
'     </ReceiveMessageResult>
'     <ResponseMetadata>
'         <RequestId>05ba5c92-80ee-5f87-be76-0cf67b7475d6</RequestId>
'     </ResponseMetadata>
' </ReceiveMessageResponse>

' Get some values from the XML:
Debug.Print "Body: "; xml.ChilkatPath("ReceiveMessageResult|Message|Body|*")
Debug.Print "MessageId: "; xml.ChilkatPath("ReceiveMessageResult|Message|MessageId|*")


unused = xml.ChilkatPath("ReceiveMessageResult|Message[0]|Attribute|$")


Set rec = xml.FindNextRecord("Name","SenderId")
Debug.Print "SenderId: "; rec.GetChildContent("Value")

Set rec = xml.FindNextRecord("Name","ApproximateFirstReceiveTimestamp")
Debug.Print "ApproximateFirstReceiveTimestamp: "; rec.GetChildContent("Value")

Set rec = xml.FindNextRecord("Name","ApproximateReceiveCount")
Debug.Print "ApproximateReceiveCount: "; rec.GetChildContent("Value")

Set rec = xml.FindNextRecord("Name","SentTimestamp")
Debug.Print "SentTimestamp: "; rec.GetChildContent("Value")

xml.GetRoot2