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

PayPal: Export a day of balance activity to CSV

See more PayPal Examples

Create a UTF-8 ledger export for the previous UTC day. Preserve signed amounts and separate currencies, and leave absent fees blank. The file is written after all pages have been read. Transaction Search can lag by several hours.

PayPal documentation

Chilkat PowerBuilder Downloads

PowerBuilder
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_Day
string ls_UtcDate
oleobject loo_StartTime
oleobject loo_EndTime
oleobject loo_Query
oleobject loo_Csv
long li_Row
long li_Page
long li_LastPage
oleobject loo_ErrorInfo
oleobject loo_Result
long li_ParsedResult
long i
long li_Count
oleobject loo_Filename
long li_Saved

li_Success = 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.
loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Http.AuthToken = "SANDBOX_ACCESS_TOKEN"
loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

//  Export yesterday in UTC; choose an earlier date if the report is still refreshing.
loo_Day = create oleobject
li_rc = loo_Day.ConnectToNewObject("Chilkat.CkDateTime")

loo_Day.SetFromCurrentSystemTime()
loo_Day.AddDays(-1)
ls_UtcDate = loo_Day.GetAsIso8601("YYYY-MM-DD",0)
loo_StartTime = create oleobject
li_rc = loo_StartTime.ConnectToNewObject("Chilkat.StringBuilder")

loo_StartTime.Append(ls_UtcDate)
loo_StartTime.Append("T00:00:00Z")
loo_EndTime = create oleobject
li_rc = loo_EndTime.ConnectToNewObject("Chilkat.StringBuilder")

loo_EndTime.Append(ls_UtcDate)
loo_EndTime.Append("T23:59:59.999Z")
loo_Query = create oleobject
li_rc = loo_Query.ConnectToNewObject("Chilkat.JsonObject")

loo_Query.UpdateString("start_date",loo_StartTime.GetAsString())
loo_Query.UpdateString("end_date",loo_EndTime.GetAsString())
loo_Query.UpdateString("balance_affecting_records_only","Y")
loo_Query.UpdateString("fields","transaction_info")
loo_Query.UpdateInt("page_size",100)
loo_Csv = create oleobject
li_rc = loo_Csv.ConnectToNewObject("Chilkat.Csv")

loo_Csv.HasColumnNames = 1
loo_Csv.SetColumnName(0,"transaction_id")
loo_Csv.SetColumnName(1,"event_code")
loo_Csv.SetColumnName(2,"status")
loo_Csv.SetColumnName(3,"currency")
loo_Csv.SetColumnName(4,"amount")
loo_Csv.SetColumnName(5,"fee_currency")
loo_Csv.SetColumnName(6,"fee")
li_Row = 0
li_Page = 1
li_LastPage = 1
do while (li_Page <= li_LastPage)
    loo_Query.UpdateInt("page",li_Page)
    li_Success = loo_Http.HttpParams("GET","https://api-m.sandbox.paypal.com/v1/reporting/transactions",loo_Query,loo_Resp)
    if li_Success <> 1 then
        Write-Debug "No HTTP response: " + loo_Http.LastErrorText
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Day
        destroy loo_StartTime
        destroy loo_EndTime
        destroy loo_Query
        destroy loo_Csv
        return
    end if

    if (loo_Resp.StatusCode < 200) OR (loo_Resp.StatusCode >= 300) then
        loo_ErrorInfo = create oleobject
        li_rc = loo_ErrorInfo.ConnectToNewObject("Chilkat.JsonObject")

        loo_ErrorInfo.Load(loo_Resp.BodyStr)
        Write-Debug "HTTP " + string(loo_Resp.StatusCode) + " " + loo_ErrorInfo.StringOf("name") + " " + loo_ErrorInfo.StringOf("details[0].issue")
        Write-Debug "PayPal debug ID: " + loo_ErrorInfo.StringOf("debug_id")
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Day
        destroy loo_StartTime
        destroy loo_EndTime
        destroy loo_Query
        destroy loo_Csv
        destroy loo_ErrorInfo
        return
    end if

    loo_Result = create oleobject
    li_rc = loo_Result.ConnectToNewObject("Chilkat.JsonObject")

    li_ParsedResult = loo_Result.Load(loo_Resp.BodyStr)
    if li_ParsedResult <> 1 then
        Write-Debug "Expected a JSON response; HTTP " + string(loo_Resp.StatusCode)
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Day
        destroy loo_StartTime
        destroy loo_EndTime
        destroy loo_Query
        destroy loo_Csv
        destroy loo_ErrorInfo
        destroy loo_Result
        return
    end if

    i = 0
    li_Count = loo_Result.SizeOfArray("transaction_details")
    do while (i < li_Count)
        loo_Result.I = i
        loo_Csv.SetCell(li_Row,0,loo_Result.StringOf("transaction_details[i].transaction_info.transaction_id"))
        loo_Csv.SetCell(li_Row,1,loo_Result.StringOf("transaction_details[i].transaction_info.transaction_event_code"))
        loo_Csv.SetCell(li_Row,2,loo_Result.StringOf("transaction_details[i].transaction_info.transaction_status"))
        loo_Csv.SetCell(li_Row,3,loo_Result.StringOf("transaction_details[i].transaction_info.transaction_amount.currency_code"))
        loo_Csv.SetCell(li_Row,4,loo_Result.StringOf("transaction_details[i].transaction_info.transaction_amount.value"))
        loo_Csv.SetCell(li_Row,5,loo_Result.StringOf("transaction_details[i].transaction_info.fee_amount.currency_code"))
        loo_Csv.SetCell(li_Row,6,loo_Result.StringOf("transaction_details[i].transaction_info.fee_amount.value"))
        li_Row = li_Row + 1
        i = i + 1
    loop
    li_LastPage = loo_Result.IntOf("total_pages")
    li_Page = li_Page + 1
loop
loo_Filename = create oleobject
li_rc = loo_Filename.ConnectToNewObject("Chilkat.StringBuilder")

loo_Filename.Append("paypal-activity-")
loo_Filename.Append(ls_UtcDate)
loo_Filename.Append(".csv")
li_Saved = loo_Csv.SaveFile2(loo_Filename.GetAsString(),"utf-8")
if li_Saved <> 1 then
    Write-Debug loo_Csv.LastErrorText
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Day
    destroy loo_StartTime
    destroy loo_EndTime
    destroy loo_Query
    destroy loo_Csv
    destroy loo_ErrorInfo
    destroy loo_Result
    destroy loo_Filename
    return
end if

Write-Debug "Exported " + string(li_Row) + " rows to " + loo_Filename.GetAsString()


destroy loo_Http
destroy loo_Resp
destroy loo_Day
destroy loo_StartTime
destroy loo_EndTime
destroy loo_Query
destroy loo_Csv
destroy loo_ErrorInfo
destroy loo_Result
destroy loo_Filename