Visual Basic 6.0 Requires Chilkat v11.0.0+
Visual Basic 6.0
SendGrid: Schedule a reminder and cancel it by batch ID
See more SendGrid Examples
Schedule a reminder one hour from now. Save its batch ID when it is allocated. If the appointment is canceled, use that saved ID in the cancellation branch. Mail Send accepts a Unix timestamp up to 72 hours ahead; cancel at least 10 minutes before the send time. Cancellation applies to the entire batch.
Create a batch ID ยท Cancel a batch
Chilkat Visual Basic 6.0 Downloads
Dim success As Long
success = 0
' Assumes Chilkat is unlocked. See Global Unlock Sample.
success = 0
Dim http As New ChilkatHttp
http.RequireSslCertVerify = 1
' Supply your API key from protected configuration; AuthToken adds the Bearer prefix.
http.AuthToken = "SENDGRID_API_KEY"
Dim resp As New ChilkatHttpResponse
' On cancellation, set this to the batch ID saved with the original appointment.
' This branch does not create a new batch or send another reminder.
Dim batchToCancel As String
batchToCancel = ""
If (batchToCancel <> "") Then
Dim cancellation As New ChilkatJsonObject
success = cancellation.UpdateString("batch_id",batchToCancel)
success = cancellation.UpdateString("status","cancel")
success = http.HttpJson("POST","https://api.sendgrid.com/v3/user/scheduled_sends",cancellation,"application/json",resp)
If (success <> 1) Then
If (resp.StatusCode = 0) Then
Debug.Print http.LastErrorText
Else
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
End If
Exit Sub
End If
If (resp.StatusCode <> 201) Then
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
Exit Sub
End If
Debug.Print "Batch cancellation accepted."
Exit Sub
End If
success = http.HttpNoBody("POST","https://api.sendgrid.com/v3/mail/batch",resp)
If (success <> 1) Then
If (resp.StatusCode = 0) Then
Debug.Print http.LastErrorText
Else
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
End If
Exit Sub
End If
If (resp.StatusCode <> 201) Then
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
Exit Sub
End If
Dim batch As New ChilkatJsonObject
success = batch.Load(resp.BodyStr)
If (success <> 1) Then
Debug.Print "Unexpected response: expected JSON."
Exit Sub
End If
Dim batchId As String
batchId = batch.StringOf("batch_id")
If (batch.HasMember("batch_id") <> 1) Then
Debug.Print "Missing batch_id in response."
Exit Sub
End If
' Allocate one batch per independently cancelable appointment.
Debug.Print "Save this batch ID with the appointment: " & batchId
Dim sendTime As New CkDateTime
success = sendTime.SetFromCurrentSystemTime()
success = sendTime.AddSeconds(3600)
Dim message As New ChilkatJsonObject
success = message.UpdateString("batch_id",batchId)
success = message.UpdateInt("send_at",sendTime.GetAsUnixTime(0))
success = message.UpdateString("from.email","sender@example.com")
success = message.UpdateString("personalizations[0].to[0].email","recipient@example.com")
success = message.UpdateString("subject","Appointment reminder")
success = message.UpdateString("content[0].type","text/plain")
success = message.UpdateString("content[0].value","Your appointment is tomorrow at 9:30 AM Central.")
success = http.HttpJson("POST","https://api.sendgrid.com/v3/mail/send",message,"application/json",resp)
If (success <> 1) Then
If (resp.StatusCode = 0) Then
Debug.Print http.LastErrorText
Else
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
End If
Exit Sub
End If
If (resp.StatusCode <> 202) Then
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
Exit Sub
End If
Debug.Print "Reminder scheduled for " & sendTime.GetAsTimestamp(0)