Visual Basic 6.0 Requires Chilkat v11.0.0+
Visual Basic 6.0
SendGrid: Add or update list contacts and check the import job
See more SendGrid Examples
Use a Marketing Campaigns API key with contact access and the ID of an existing list. A 202 response queues the upsert; it does not confirm that the contacts were saved. Save the job ID and use it to recheck a pending import without submitting the contacts again. The error report may contain contact data; handle it privately.
Add or update contacts ยท Import job status
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
Dim jobId As String
jobId = ""
If (jobId = "") Then
Dim contacts As New ChilkatJsonObject
success = contacts.UpdateString("list_ids[0]","YOUR_LIST_UUID")
success = contacts.UpdateString("contacts[0].email","avery@example.com")
success = contacts.UpdateString("contacts[0].first_name","Avery")
success = contacts.UpdateString("contacts[1].email","robin@example.com")
success = contacts.UpdateString("contacts[1].first_name","Robin")
success = http.HttpJson("PUT","https://api.sendgrid.com/v3/marketing/contacts",contacts,"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
Dim queued As New ChilkatJsonObject
success = queued.Load(resp.BodyStr)
If (success <> 1) Then
Debug.Print "Unexpected response: expected JSON."
Exit Sub
End If
If (queued.HasMember("job_id") <> 1) Then
Debug.Print "No job ID returned."
Exit Sub
End If
jobId = queued.StringOf("job_id")
Debug.Print "Save this import job ID: " & jobId
End If
success = http.SetUrlVar("job",jobId)
success = http.HttpNoBody("GET","https://api.sendgrid.com/v3/marketing/contacts/imports/{$job}",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 <> 200) Then
Debug.Print "HTTP " & resp.StatusCode & ": " & resp.BodyStr
Exit Sub
End If
Dim job As New ChilkatJsonObject
success = job.Load(resp.BodyStr)
If (success <> 1) Then
Debug.Print "Unexpected response: expected JSON."
Exit Sub
End If
Dim state As String
state = job.StringOf("status")
If (state = "pending") Then
Debug.Print "Still pending. Check again later with jobId = " & jobId
Exit Sub
End If
Debug.Print "Job status: " & state
Debug.Print "Created: " & job.IntOf("results.created_count") & ", updated: " & job.IntOf("results.updated_count") & ", errors: " & job.IntOf("results.errored_count")
If ((state = "errored") Or (state = "failed")) Then
Debug.Print "Review the job before retrying. If present, results.errors_url identifies the private error report."
End If