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

PayPal: Page through merchant transactions

See more PayPal Examples

Read yesterday-to-now account activity one page at a time. Enable Transaction Search for the REST app and obtain a token with reporting access. Data can lag by up to three hours; use order or capture lookup for a checkout in progress.

PayPal documentation

Chilkat PureBasic Downloads

PureBasic
IncludeFile "CkHttpResponse.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkJsonObject.pb"
IncludeFile "CkDateTime.pb"

Procedure ChilkatExample()

    success.i = 0

    ;  See Unlock Chilkat before making requests.
    ;  For the merchant's internal backoffice application. Load the sandbox token
    ;  from the merchant's credential store. Keep it out of publicly distributed apps.
    ;  See Get a PayPal access token.
    http.i = CkHttp::ckCreate()
    If http.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkHttp::setCkAuthToken(http, "SANDBOX_ACCESS_TOKEN")
    resp.i = CkHttpResponse::ckCreate()
    If resp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    ;  Use the UTC window containing the transaction (at most 31 days per request).
    dt.i = CkDateTime::ckCreate()
    If dt.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkDateTime::ckSetFromCurrentSystemTime(dt)
    query.i = CkJsonObject::ckCreate()
    If query.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckUpdateString(query,"end_date",CkDateTime::ckGetAsTimestamp(dt,0))
    CkDateTime::ckAddDays(dt,-1)
    CkJsonObject::ckUpdateString(query,"start_date",CkDateTime::ckGetAsTimestamp(dt,0))
    CkJsonObject::ckUpdateString(query,"fields","transaction_info")
    CkJsonObject::ckUpdateInt(query,"page_size",100)
    page.i = 1
    lastPage.i = 1
    While (page <= lastPage)
        CkJsonObject::ckUpdateInt(query,"page",page)
        success = CkHttp::ckHttpParams(http,"GET","https://api-m.sandbox.paypal.com/v1/reporting/transactions",query,resp)
        If success <> 1
            Debug "No HTTP response: " + CkHttp::ckLastErrorText(http)
            CkHttp::ckDispose(http)
            CkHttpResponse::ckDispose(resp)
            CkDateTime::ckDispose(dt)
            CkJsonObject::ckDispose(query)
            ProcedureReturn
        EndIf

        If (CkHttpResponse::ckStatusCode(resp) < 200) OR (CkHttpResponse::ckStatusCode(resp) >= 300)
            errorInfo.i = CkJsonObject::ckCreate()
            If errorInfo.i = 0
                Debug "Failed to create object."
                ProcedureReturn
            EndIf

            CkJsonObject::ckLoad(errorInfo,CkHttpResponse::ckBodyStr(resp))
            Debug "HTTP " + Str(CkHttpResponse::ckStatusCode(resp)) + " " + CkJsonObject::ckStringOf(errorInfo,"name") + " " + CkJsonObject::ckStringOf(errorInfo,"details[0].issue")
            Debug "PayPal debug ID: " + CkJsonObject::ckStringOf(errorInfo,"debug_id")
            CkHttp::ckDispose(http)
            CkHttpResponse::ckDispose(resp)
            CkDateTime::ckDispose(dt)
            CkJsonObject::ckDispose(query)
            CkJsonObject::ckDispose(errorInfo)
            ProcedureReturn
        EndIf

        result.i = CkJsonObject::ckCreate()
        If result.i = 0
            Debug "Failed to create object."
            ProcedureReturn
        EndIf

        parsed.i = CkJsonObject::ckLoad(result,CkHttpResponse::ckBodyStr(resp))
        If parsed <> 1
            Debug "Expected a JSON response; HTTP " + Str(CkHttpResponse::ckStatusCode(resp))
            CkHttp::ckDispose(http)
            CkHttpResponse::ckDispose(resp)
            CkDateTime::ckDispose(dt)
            CkJsonObject::ckDispose(query)
            CkJsonObject::ckDispose(errorInfo)
            CkJsonObject::ckDispose(result)
            ProcedureReturn
        EndIf

        i.i = 0
        count.i = CkJsonObject::ckSizeOfArray(result,"transaction_details")
        While (i < count)
            CkJsonObject::setCkI(result, i)
            Debug CkJsonObject::ckStringOf(result,"transaction_details[i].transaction_info.transaction_id") + "  " + CkJsonObject::ckStringOf(result,"transaction_details[i].transaction_info.transaction_event_code") + "  " + CkJsonObject::ckStringOf(result,"transaction_details[i].transaction_info.transaction_status")
            Debug "  " + CkJsonObject::ckStringOf(result,"transaction_details[i].transaction_info.transaction_amount.value") + " " + CkJsonObject::ckStringOf(result,"transaction_details[i].transaction_info.transaction_amount.currency_code")
            i = i + 1
        Wend
        lastPage = CkJsonObject::ckIntOf(result,"total_pages")
        page = page + 1
    Wend


    CkHttp::ckDispose(http)
    CkHttpResponse::ckDispose(resp)
    CkDateTime::ckDispose(dt)
    CkJsonObject::ckDispose(query)
    CkJsonObject::ckDispose(errorInfo)
    CkJsonObject::ckDispose(result)


    ProcedureReturn
EndProcedure