(Excel) Twilio: Send SMS using Basic Authentication

Demonstrates how to use Twilio to send an SMS message using Basic authentication.

For more information, see https://www.twilio.com/docs/sms/send-messages

Download Excel Class Modules Chilkat Excel Class Modules

' Demonstrates how to use Basic Authentication in a REST API call for Twilio.
' Sends an SMS text message..

' 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

' Use Basic Authentication.
' Your Twilio Account SID is the username.
' Your Twilio Auth Token is the password.

success = rest.SetAuthBasic("TWILIO_ACCOUNT_SID","TWILIO_AUTH_TOKEN")

' Make the initial connection (without sending a request yet) to Twilio.

bTls = True

port = 443

bAutoReconnect = True
success = rest.Connect("api.twilio.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Provide the information for the SMS text message:
success = rest.AddQueryParam("To","+16518675309")
success = rest.AddQueryParam("From","+15005550006")
success = rest.AddQueryParam("Body","Hey Jenny! Good luck on the bar exam!")
success = rest.AddQueryParam("MediaUrl","http://farm2.static.flickr.com/1075/1404618563_3ed9a44a3a.jpg")

' Send the SMS text message.
' Your Twilio Account SID is part of the URI path:

responseJson = rest.FullRequestFormUrlEncoded("POST","/2010-04-01/Accounts/TWILIO_ACCOUNT_SID/Messages.json")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' When successful, the response status code will equal 201.
If (rest.ResponseStatusCode <> 201) Then
    ' Examine the request/response to see what happened.
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body (if any): "; responseJson
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
    Exit Sub
End If

' The response is JSON.  We'll show how to get a few bits of information from it.
' A full sample JSON response is shown below..

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
success = json.Load(responseJson)

' First show the entire JSON.
Debug.Print json.Emit()

' Now get some individual pieces of information:
Debug.Print "sid: "; json.StringOf("sid")
Debug.Print "body: "; json.StringOf("body")
Debug.Print "media: "; json.StringOf("subresource_uris.media")

Debug.Print "Success."

' Sample JSON response:

' {
'   "sid": "MM97ecfd43e9f24e99b0c2c6ee016949e3",
'   "date_created": null,
'   "date_updated": null,
'   "date_sent": null,
'   "account_sid": "112e1111e0151133d11112101111d1111",
'   "to": "+16518675309",
'   "from": "+15005550006",
'   "messaging_service_sid": null,
'   "body": "Sent from your Twilio trial account - Hey Jenny! Good luck on the bar exam!",
'   "status": "queued",
'   "num_segments": "1",
'   "num_media": "0",
'   "direction": "outbound-api",
'   "api_version": "2010-04-01",
'   "price": null,
'   "price_unit": "USD",
'   "error_code": null,
'   "error_message": null,
'   "uri": "/2010-04-01/Accounts/AC2e9b6bc0f51133df24926f07341d3824/Messages/MM97ecfd43e9f24e99b0c2c6ee016949e3.json",
'   "subresource_uris": {
'     "media": "/2010-04-01/Accounts/AC2e9b6bc0f51133df24926f07341d3824/Messages/MM97ecfd43e9f24e99b0c2c6ee016949e3/Media.json"
'   }
' }