Visual Basic 6.0 Requires Chilkat v11.0.0+
Visual Basic 6.0
SendGrid: Create a newsletter draft, then schedule the reviewed draft
See more SendGrid Examples
Prepare a Marketing Campaigns design with a subject, content, and an unsubscribe module. Supply the design and list UUIDs, a verified marketing sender ID, and the unsubscribe group ID. The first run creates only a draft. After reviewing the audience and content, run the scheduling branch with that same ID. Single Sends use an ISO 8601 UTC string, unlike Mail Send’s numeric Unix timestamp.
Create a Single Send · Schedule a Single Send
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
' Leave this empty to create a draft. To schedule, supply the ID of an already reviewed draft.
Dim reviewedDraftId As String
reviewedDraftId = ""
If (reviewedDraftId = "") Then
Dim draft As New ChilkatJsonObject
success = draft.UpdateString("name","November newsletter")
success = draft.UpdateString("send_to.list_ids[0]","YOUR_LIST_UUID")
success = draft.UpdateInt("email_config.sender_id",12345)
success = draft.UpdateInt("email_config.suppression_group_id",67890)
success = draft.UpdateString("email_config.design_id","YOUR_NEWSLETTER_DESIGN_UUID")
success = http.HttpJson("POST","https://api.sendgrid.com/v3/marketing/singlesends",draft,"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
Dim created As New ChilkatJsonObject
success = created.Load(resp.BodyStr)
If (success <> 1) Then
Debug.Print "Unexpected response: expected JSON."
Exit Sub
End If
Dim draftId As String
draftId = created.StringOf("id")
If (created.HasMember("id") <> 1) Then
Debug.Print "Missing id in response."
Exit Sub
End If
Debug.Print "Draft created: " & draftId & ". Review it in Marketing Campaigns before scheduling."
Exit Sub
End If
' The example selects tomorrow at the current UTC time. Use your approved send time.
Dim releaseTime As New CkDateTime
success = releaseTime.SetFromCurrentSystemTime()
success = releaseTime.AddDays(1)
Dim schedule As New ChilkatJsonObject
success = schedule.UpdateString("send_at",releaseTime.GetAsTimestamp(0))
success = http.SetUrlVar("draft",reviewedDraftId)
success = http.HttpJson("PUT","https://api.sendgrid.com/v3/marketing/singlesends/{$draft}/schedule",schedule,"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
Dim scheduled As New ChilkatJsonObject
success = scheduled.Load(resp.BodyStr)
If (success <> 1) Then
Debug.Print "Unexpected response: expected JSON."
Exit Sub
End If
Debug.Print scheduled.StringOf("status") & ": " & scheduled.StringOf("send_at")