(Excel) SimpleTexting - Send SMS Message

Send a text message to an individual contact.

For more information, see https://simpletexting.com/api/docs/#operation/sendSmsPost

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl --request POST \
'   --url 'https://app2.simpletexting.com/v1/send?token=YOUR_API_TOKEN&phone=SOME_STRING_VALUE&message=SOME_STRING_VALUE' \
'   --header 'accept: application/json' \
'   --header 'content-type: application/x-www-form-urlencoded'

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

http.SetRequestHeader "accept","application/json"
http.SetRequestHeader "content-type","application/x-www-form-urlencoded"

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.AddParam "token","YOUR_API_TOKEN"
req.AddParam "phone","SOME_10_DIGIT_PHONE_NUMBER"
req.AddParam "message","Hello: This is a sample text message with some punctuation: &%$@,;."

req.AddHeader "Accept","application/json"


Set resp = http.PostUrlEncoded("https://app2.simpletexting.com/v1/send",req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
Dim success As Boolean
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "code": 1,
'   "message": "The request succeeded",
'   "smsid": "5bec5b9d0a975a238808ffb2"
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


code = jResp.IntOf("code")

message = jResp.StringOf("message")

smsid = jResp.StringOf("smsid")