Xbase++ Requires Chilkat v11.0.0+
Xbase++
PayPal - Find Authorizations
See more PayPal Examples
Finds previously created authorizations.Chilkat Xbase++ Downloads
LOCAL nSuccess
LOCAL oJsonToken
LOCAL oSbAuth
LOCAL oRest
LOCAL nBAutoReconnect
LOCAL oSbJsonResponse
LOCAL oJson
LOCAL oSbTemp
LOCAL oJsonAuth
LOCAL nNumPayments
LOCAL i
LOCAL j
LOCAL nNumTransactions
LOCAL nNumRelatedResources
LOCAL k
nSuccess := 0
// This requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
// Load our previously obtained access token. (see PayPal OAuth2 Access Token)
oJsonToken := CreateObject("Chilkat.JsonObject")
oJsonToken:LoadFile("qa_data/tokens/paypal.json")
// Build the Authorization request header field value.
oSbAuth := CreateObject("Chilkat.StringBuilder")
// token_type should be "Bearer"
oSbAuth:Append(oJsonToken:StringOf("token_type"))
oSbAuth:Append(" ")
oSbAuth:Append(oJsonToken:StringOf("access_token"))
// Make the initial connection.
// A single REST object, once connected, can be used for many PayPal REST API calls.
// The auto-reconnect indicates that if the already-established HTTPS connection is closed,
// then it will be automatically re-established as needed.
oRest := CreateObject("Chilkat.Rest")
nBAutoReconnect := 1
nSuccess := oRest:Connect("api.sandbox.paypal.com", 443, 1, nBAutoReconnect)
IF (nSuccess == 0)
? oRest:LastErrorText
oJsonToken:destroy()
oSbAuth:destroy()
oRest:destroy()
RETURN
ENDIF
// ----------------------------------------------------------------------------------------------
// The code above this comment could be placed inside a function/subroutine within the application
// because the connection does not need to be made for every request. Once the connection is made
// the app may send many requests..
// ----------------------------------------------------------------------------------------------
// Clear the REST object of any headers or query params from previous requests.
oRest:ClearAllHeaders()
oRest:ClearAllQueryParams()
oRest:AddHeader("Authorization", oSbAuth:GetAsString())
// To find authoriaztions, we list payments and look for those
// containing "authorization" transactions
oRest:AddQueryParam("count", "100")
oRest:AddQueryParam("start_index", "0")
oRest:AddQueryParam("sort_by", "update_time")
oRest:AddQueryParam("sort_order", "asc")
// Send the GET request and get the JSON response.
oSbJsonResponse := CreateObject("Chilkat.StringBuilder")
nSuccess := oRest:FullRequestNoBodySb("GET", "/v1/payments/payment", oSbJsonResponse)
IF (nSuccess == 0)
? oRest:LastErrorText
oJsonToken:destroy()
oSbAuth:destroy()
oRest:destroy()
oSbJsonResponse:destroy()
RETURN
ENDIF
oJson := CreateObject("Chilkat.JsonObject")
oJson:EmitCompact := 0
oJson:LoadSb(oSbJsonResponse)
// (optional) Save the entire JSON response to a file to examine if desired..
oSbTemp := CreateObject("Chilkat.StringBuilder")
oJson:EmitSb(oSbTemp)
oSbTemp:WriteFile("qa_output/paypal_payments.json", "utf-8", 0)
? "Response Status Code = " + Str(oRest:ResponseStatusCode)
// Did we get a 200 success response?
IF (oRest:ResponseStatusCode != 200)
? oJson:Emit()
? "Failed."
oJsonToken:destroy()
oSbAuth:destroy()
oRest:destroy()
oSbJsonResponse:destroy()
oJson:destroy()
oSbTemp:destroy()
RETURN
ENDIF
// We are looking for "authorization" transactions .
// As shown below, we are looking in the "transactions" for "related_resources"
// containing "authorization" JSON objects.
// {
// "payments": [
// {
// "id": "PAY-3SL8976592063093RLA3DMAY",
// "create_time": "2016-11-24T00:36:19Z",
// "update_time": "2016-11-24T00:36:24Z",
// "state": "approved",
// "intent": "authorize",
// "payer": {
// "payment_method": "credit_card",
// "funding_instruments": [
// {
// "credit_card_token": {
// "credit_card_id": "CARD-52W84623JH8043102LA3CLGA",
// "payer_id": "user12345",
// "last4": "9974",
// "type": "visa",
// "expire_month": "9",
// "expire_year": "2021"
// }
// }
// ]
// },
// "transactions": [
// {
// "amount": {
// "total": "6.70",
// "currency": "USD",
// "details": {
// "subtotal": "6.70"
// }
// },
// "description": "This is the payment transaction description.",
// "related_resources": [
// {
// "authorization": {
// "id": "6HG91590AX913463C",
// "create_time": "2016-11-24T00:36:19Z",
// "update_time": "2016-11-24T00:36:24Z",
// "amount": {
// ...
// }
// },
// "state": "authorized",
// "parent_payment": "PAY-3SL8976592063093RLA3DMAY",
// "valid_until": "2016-12-23T00:36:19Z",
// ...
//
// Iterate over the payments and show each authorization
oJsonAuth := CreateObject("Chilkat.JsonObject")
nNumPayments := oJson:SizeOfArray("payments")
i := 0
DO WHILE i < nNumPayments
oJson:I := i
j := 0
nNumTransactions := oJson:SizeOfArray("payments[i].transactions")
DO WHILE j < nNumTransactions
oJson:J := j
nNumRelatedResources := oJson:SizeOfArray("payments[i].transactions[j].related_resources")
k := 0
DO WHILE k < nNumRelatedResources
oJson:K := k
IF (oJson:HasMember("payments[i].transactions[j].related_resources[k].authorization") == 1)
oJson:ObjectOf2("payments[i].transactions[j].related_resources[k].authorization", oJsonAuth)
? "authorization id: " + oJsonAuth:StringOf("id")
? "state: " + oJsonAuth:StringOf("state")
? "total: " + oJsonAuth:StringOf("amount.total")
? "----"
ENDIF
k := k + 1
ENDDO
j := j + 1
ENDDO
i := i + 1
ENDDO
? "success"
oJsonToken:destroy()
oSbAuth:destroy()
oRest:destroy()
oSbJsonResponse:destroy()
oJson:destroy()
oSbTemp:destroy()
oJsonAuth:destroy()