Sample code for 30+ languages & platforms
Visual Basic 6.0 Requires Chilkat v11.0.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

Visual Basic 6.0
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