PowerBuilder Requires Chilkat v11.0.0+
PowerBuilder
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.
Chilkat PowerBuilder Downloads
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