(Excel) Send SMS Text Message to Phone Number

Uses Amazon SNS to send an SMS text message to a phone number.

See SNS Publish for more information.

For more information, see https://docs.aws.amazon.com/sns/latest/dg/sms_publish-to-phone.html

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://sns.us-west-2.amazonaws.com/

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("sns.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 = "sns"

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

success = rest.AddQueryParam("Action","Publish")
' ----------------------------------------------------
' Please use your own phone number here for testing...
' ----------------------------------------------------
success = rest.AddQueryParam("PhoneNumber","+15551239999")
success = rest.AddQueryParam("Message","This is a test message from Amazon SNS")


responseXml = rest.FullRequestNoBody("GET","/")
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()

' To get the MessageId
Debug.Print "MessageId: "; xml.ChilkatPath("PublishResult|MessageId|*")

' A sample successful response:
' <?xml version="1.0" encoding="utf-8"?>
' <PublishResponse xmlns="http://sns.amazonaws.com/doc/2010-03-31/">
'     <PublishResult>
'         <MessageId>5ffca506-6ff6-502c-bca3-f098971bcb9c</MessageId>
'     </PublishResult>
'     <ResponseMetadata>
'         <RequestId>6c815022-050e-5930-a7b4-05bcfde35280</RequestId>
'     </ResponseMetadata>
' </PublishResponse>