DataFlex Requires Chilkat v11.0.0+
DataFlex
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 DataFlex Downloads
Use ChilkatAx-win32.pkg
Procedure Test
Boolean iSuccess
Handle hoHttp
Variant vResp
Handle hoResp
Handle hoDay
Handle hoDays
Variant vRow
Handle hoRow
Integer i
String sTemp1
Integer iTemp1
Integer iTemp2
Integer iTemp3
Integer iTemp4
Move False To iSuccess
// Assumes Chilkat is unlocked. See Global Unlock Sample.
Move False To iSuccess
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
Set ComRequireSslCertVerify Of hoHttp To True
// Supply your API key from protected configuration; AuthToken adds the Bearer prefix.
Set ComAuthToken Of hoHttp To "SENDGRID_API_KEY"
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
If (Not(IsComObjectCreated(hoResp))) Begin
Send CreateComObject of hoResp
End
Get Create (RefClass(cComCkDateTime)) To hoDay
If (Not(IsComObjectCreated(hoDay))) Begin
Send CreateComObject of hoDay
End
Get ComSetFromCurrentSystemTime Of hoDay To iSuccess
Get ComAddDays Of hoDay -1 To iSuccess
Get ComGetAsIso8601 Of hoDay "YYYY-MM-DD" False To sTemp1
Get ComSetUrlVar Of hoHttp "end" sTemp1 To iSuccess
Get ComAddDays Of hoDay -6 To iSuccess
Get ComGetAsIso8601 Of hoDay "YYYY-MM-DD" False To sTemp1
Get ComSetUrlVar Of hoHttp "start" sTemp1 To iSuccess
Get pvComObject of hoResp to vResp
Get ComHttpNoBody Of hoHttp "GET" "https://api.sendgrid.com/v3/stats?start_date={$start}&end_date={$end}&aggregated_by=day" vResp To iSuccess
If (iSuccess <> True) Begin
Get ComStatusCode Of hoResp To iTemp1
If (iTemp1 = 0) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
End
Else Begin
Get ComStatusCode Of hoResp To iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln "HTTP " iTemp1 ": " sTemp1
End
Procedure_Return
End
Get ComStatusCode Of hoResp To iTemp1
If (iTemp1 <> 200) Begin
Get ComStatusCode Of hoResp To iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln "HTTP " iTemp1 ": " sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatJsonArray)) To hoDays
If (Not(IsComObjectCreated(hoDays))) Begin
Send CreateComObject of hoDays
End
Get ComBodyStr Of hoResp To sTemp1
Get ComLoad Of hoDays sTemp1 To iSuccess
If (iSuccess <> True) Begin
Showln "Unexpected response: expected JSON."
Procedure_Return
End
Showln "Date,Requests,Delivered,Bounces,Blocks"
Get Create (RefClass(cComChilkatJsonObject)) To hoRow
If (Not(IsComObjectCreated(hoRow))) Begin
Send CreateComObject of hoRow
End
Move 0 To i
While (i < (ComSize(hoDays)))
Get pvComObject of hoRow to vRow
Get ComObjectAt2 Of hoDays i vRow To iSuccess
Get ComStringOf Of hoRow "date" To sTemp1
Get ComIntOf Of hoRow "stats[0].metrics.requests" To iTemp1
Get ComIntOf Of hoRow "stats[0].metrics.delivered" To iTemp2
Get ComIntOf Of hoRow "stats[0].metrics.bounces" To iTemp3
Get ComIntOf Of hoRow "stats[0].metrics.blocks" To iTemp4
Showln sTemp1 "," iTemp1 "," iTemp2 "," iTemp3 "," iTemp4
Move (i + 1) To i
Loop
End_Procedure