PowerBuilder Requires Chilkat v11.0.0+
PowerBuilder
PayPal: Read an invoice and its outstanding balance
See more PayPal Examples
Use the PayPal invoice ID to retrieve its number, status, total and balance due. A partial external payment can reduce the balance without settling the whole invoice.
Chilkat PowerBuilder Downloads
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_ErrorInfo
oleobject loo_Result
long li_Parsed
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")
// The original total and the balance still due may differ after a payment.
loo_Http.SetUrlVar("id","INVOICE_ID")
li_Success = loo_Http.HttpNoBody("GET","https://api-m.sandbox.paypal.com/v2/invoicing/invoices/{$id}",loo_Resp)
if li_Success <> 1 then
Write-Debug "No HTTP response: " + loo_Http.LastErrorText
destroy loo_Http
destroy loo_Resp
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_ErrorInfo
return
end if
loo_Result = create oleobject
li_rc = loo_Result.ConnectToNewObject("Chilkat.JsonObject")
li_Parsed = loo_Result.Load(loo_Resp.BodyStr)
if li_Parsed <> 1 then
Write-Debug "Expected a JSON response; HTTP " + string(loo_Resp.StatusCode)
destroy loo_Http
destroy loo_Resp
destroy loo_ErrorInfo
destroy loo_Result
return
end if
Write-Debug "ID: " + loo_Result.StringOf("id")
Write-Debug "Status: " + loo_Result.StringOf("status")
Write-Debug "Number: " + loo_Result.StringOf("detail.invoice_number")
Write-Debug "Total: " + loo_Result.StringOf("amount.value")
Write-Debug "Currency: " + loo_Result.StringOf("amount.currency_code")
Write-Debug "Balance due: " + loo_Result.StringOf("due_amount.value")
destroy loo_Http
destroy loo_Resp
destroy loo_ErrorInfo
destroy loo_Result