Sample code for 30+ languages & platforms
Xbase++ Requires Chilkat v11.0.0+

SendGrid: Report daily requests, deliveries, bounces, and blocks

See more SendGrid Examples

Retrieve seven completed UTC dates and print one row per date. The counts are account-level aggregates; a day’s delivered count does not identify which messages sent that day were delivered.

Global email statistics

Chilkat Xbase++ Downloads

Xbase++
LOCAL nSuccess
LOCAL oHttp
LOCAL oResp
LOCAL oDay
LOCAL oDays
LOCAL oRow
LOCAL i

nSuccess := 0

//  Assumes Chilkat is unlocked. See Global Unlock Sample.
nSuccess := 0
oHttp := CreateObject("Chilkat.Http")
oHttp:RequireSslCertVerify := 1
//  Supply your API key from protected configuration; AuthToken adds the Bearer prefix.
oHttp:AuthToken := "SENDGRID_API_KEY"
oResp := CreateObject("Chilkat.HttpResponse")

oDay := CreateObject("Chilkat.CkDateTime")
oDay:SetFromCurrentSystemTime()
oDay:AddDays(-1)
oHttp:SetUrlVar("end", oDay:GetAsIso8601("YYYY-MM-DD", 0))
oDay:AddDays(-6)
oHttp:SetUrlVar("start", oDay:GetAsIso8601("YYYY-MM-DD", 0))

nSuccess := oHttp:HttpNoBody("GET", "https://api.sendgrid.com/v3/stats?start_date={$start}&end_date={$end}&aggregated_by=day", oResp)
IF (nSuccess != 1)
    IF (oResp:StatusCode == 0)
        ? oHttp:LastErrorText
    ELSE
        ? "HTTP " + Str(oResp:StatusCode) + ": " + oResp:BodyStr
    ENDIF

    oHttp:destroy()
    oResp:destroy()
    oDay:destroy()
    RETURN
ENDIF

IF (oResp:StatusCode != 200)
    ? "HTTP " + Str(oResp:StatusCode) + ": " + oResp:BodyStr
    oHttp:destroy()
    oResp:destroy()
    oDay:destroy()
    RETURN
ENDIF

oDays := CreateObject("Chilkat.JsonArray")
nSuccess := oDays:Load(oResp:BodyStr)
IF (nSuccess != 1)
    ? "Unexpected response: expected JSON."
    oHttp:destroy()
    oResp:destroy()
    oDay:destroy()
    oDays:destroy()
    RETURN
ENDIF

? "Date,Requests,Delivered,Bounces,Blocks"
oRow := CreateObject("Chilkat.JsonObject")
i := 0
DO WHILE (i < oDays:Size)
    oDays:ObjectAt2(i, oRow)
    ? oRow:StringOf("date") + "," + Str(oRow:IntOf("stats[0].metrics.requests")) + "," + Str(oRow:IntOf("stats[0].metrics.delivered")) + "," + Str(oRow:IntOf("stats[0].metrics.bounces")) + "," + Str(oRow:IntOf("stats[0].metrics.blocks"))
    i := i + 1
ENDDO

oHttp:destroy()
oResp:destroy()
oDay:destroy()
oDays:destroy()
oRow:destroy()