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

PayPal: Look up a subscription and its recent payments

See more PayPal Examples

Start with the PayPal subscription ID saved with the local customer. Display its status and next billing time, then list transactions for the previous 30 days with each gross amount and currency.

PayPal documentation

Chilkat PowerBuilder Downloads

PowerBuilder
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_ErrorInfo
oleobject loo_Result
long li_ParsedResult
oleobject loo_Now
oleobject loo_Query
oleobject loo_HistoryError
oleobject loo_History
long li_ParsedHistory
long i

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")

loo_Http.SetUrlVar("id","SUBSCRIPTION_ID")

li_Success = loo_Http.HttpNoBody("GET","https://api-m.sandbox.paypal.com/v1/billing/subscriptions/{$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_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_ErrorInfo
    destroy loo_Result
    return
end if

Write-Debug "Status: " + loo_Result.StringOf("status")
Write-Debug "Next billing: " + loo_Result.StringOf("billing_info.next_billing_time")
loo_Now = create oleobject
li_rc = loo_Now.ConnectToNewObject("Chilkat.CkDateTime")

loo_Now.SetFromCurrentSystemTime()
loo_Query = create oleobject
li_rc = loo_Query.ConnectToNewObject("Chilkat.JsonObject")

loo_Query.UpdateString("end_time",loo_Now.GetAsTimestamp(0))
loo_Now.AddDays(-30)
loo_Query.UpdateString("start_time",loo_Now.GetAsTimestamp(0))
li_Success = loo_Http.HttpParams("GET","https://api-m.sandbox.paypal.com/v1/billing/subscriptions/{$id}/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_ErrorInfo
    destroy loo_Result
    destroy loo_Now
    destroy loo_Query
    return
end if

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

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

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

li_ParsedHistory = loo_History.Load(loo_Resp.BodyStr)
if li_ParsedHistory <> 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
    destroy loo_Now
    destroy loo_Query
    destroy loo_HistoryError
    destroy loo_History
    return
end if

i = 0
do while (i < loo_History.SizeOfArray("transactions"))
    loo_History.I = i
    Write-Debug loo_History.StringOf("transactions[i].time") + "  " + loo_History.StringOf("transactions[i].id") + "  " + loo_History.StringOf("transactions[i].status") + "  " + loo_History.StringOf("transactions[i].amount_with_breakdown.gross_amount.value") + " " + loo_History.StringOf("transactions[i].amount_with_breakdown.gross_amount.currency_code")
    i = i + 1
loop


destroy loo_Http
destroy loo_Resp
destroy loo_ErrorInfo
destroy loo_Result
destroy loo_Now
destroy loo_Query
destroy loo_HistoryError
destroy loo_History