Sample code for 30+ languages & platforms
DataFlex 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 DataFlex Downloads

DataFlex
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