Xbase++ Requires Chilkat v11.0.0+
Xbase++
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.
Chilkat Xbase++ Downloads
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()