PureBasic Requires Chilkat v11.0.0+
PureBasic
PayPal: Reconcile a transaction ID in a reporting window
See more PayPal Examples
Supply the reporting transaction ID and a window containing the activity. Return all matches: transaction IDs are not necessarily unique in the report. Include non-balance-affecting records when reconciling an event.
Chilkat PureBasic Downloads
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)
CkJsonObject::ckUpdateString(query,"transaction_id","REPORT_TRANSACTION_ID")
CkJsonObject::ckUpdateString(query,"balance_affecting_records_only","N")
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