(Visual FoxPro) PayPal - Get Sale Details

Shows details for a sale transaction, by ID.

Note: This example requires Chilkat v9.5.0.65 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loJsonToken
LOCAL loSbAuth
LOCAL loRest
LOCAL lnBAutoReconnect
LOCAL lnSuccess
LOCAL loSbPath
LOCAL lnNumReplaced
LOCAL loSbJsonResponse
LOCAL loJson
LOCAL loDateTime
LOCAL loDtUtc

* Note: Requires Chilkat v9.5.0.65 or greater.

* 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)
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonToken = CreateObject('Chilkat.JsonObject')
loJsonToken.LoadFile("qa_data/tokens/paypal.json")

* Build the Authorization request header field value.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbAuth = CreateObject('Chilkat.StringBuilder')
* token_type should be "Bearer"
loSbAuth.Append(loJsonToken.StringOf("token_type"))
loSbAuth.Append(" ")
loSbAuth.Append(loJsonToken.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.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Rest')
loRest = CreateObject('Chilkat.Rest')
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("api.sandbox.paypal.com",443,1,lnBAutoReconnect)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loJsonToken
    RELEASE loSbAuth
    RELEASE loRest
    CANCEL
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.
loRest.ClearAllHeaders()
loRest.ClearAllQueryParams()

loRest.AddHeader("Authorization",loSbAuth.GetAsString())

* The sale ID is added to the path.
* The sale ID is obtained from payment records as shown here: Find Completed Sales
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbPath = CreateObject('Chilkat.StringBuilder')
loSbPath.Append("/v1/payments/sale/sale_id")
lnNumReplaced = loSbPath.Replace("sale_id","1XC17935MN507400J")

* Send the GET request and get the JSON response.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbJsonResponse = CreateObject('Chilkat.StringBuilder')
lnSuccess = loRest.FullRequestNoBodySb("GET",loSbPath.GetAsString(),loSbJsonResponse)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loJsonToken
    RELEASE loSbAuth
    RELEASE loRest
    RELEASE loSbPath
    RELEASE loSbJsonResponse
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.EmitCompact = 0
loJson.LoadSb(loSbJsonResponse)

? "Response Status Code = " + STR(loRest.ResponseStatusCode)

* Did we get a 200 success response?
IF (loRest.ResponseStatusCode <> 200) THEN
    ? loJson.Emit()
    ? "Failed."
    RELEASE loJsonToken
    RELEASE loSbAuth
    RELEASE loRest
    RELEASE loSbPath
    RELEASE loSbJsonResponse
    RELEASE loJson
    CANCEL
ENDIF

* Sample JSON response is shown below.
? loJson.Emit()
? "----------------------"

* Show how to get a timestamp, such as update_time.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.CkDateTime')
loDateTime = CreateObject('Chilkat.CkDateTime')
lnSuccess = loDateTime.SetFromTimestamp(loJson.StringOf("update_time"))
? "utc update_time: " + loDateTime.GetAsTimestamp(0)
? "local update_time: " + loDateTime.GetAsTimestamp(1)
? "utc rfc822: " + loDateTime.GetAsRfc822(0)
? "local rfc822: " + loDateTime.GetAsRfc822(1)

loDtUtc = loDateTime.GetDtObj(0)
? STR(loDtUtc.Month) + "/" + STR(loDtUtc.Day) + "/" + STR(loDtUtc.Year)
RELEASE loDtUtc

? "success"

* ------------------------------------------------
* A sample JSON response:

* 	{ 
* 	  "id": "1XC17935MN507400J",
* 	  "create_time": "2016-11-25T15:42:50Z",
* 	  "update_time": "2016-11-25T15:42:56Z",
* 	  "amount": { 
* 	    "total": "289.00",
* 	    "currency": "USD"
* 	  },
* 	  "payment_mode": "INSTANT_TRANSFER",
* 	  "state": "completed",
* 	  "protection_eligibility": "ELIGIBLE",
* 	  "protection_eligibility_type": "ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE",
* 	  "parent_payment": "PAY-2AA764602T410180HLA4FX6Q",
* 	  "transaction_fee": { 
* 	    "value": "8.68",
* 	    "currency": "USD"
* 	  },
* 	  "links": [
* 	    { 
* 	      "href": "https://api.sandbox.paypal.com/v1/payments/sale/1XC17935MN507400J",
* 	      "rel": "self",
* 	      "method": "GET"
* 	    },
* 	    { 
* 	      "href": "https://api.sandbox.paypal.com/v1/payments/sale/1XC17935MN507400J/refund",
* 	      "rel": "refund",
* 	      "method": "POST"
* 	    },
* 	    { 
* 	      "href": "https://api.sandbox.paypal.com/v1/payments/payment/PAY-2AA764602T410180HLA4FX6Q",
* 	      "rel": "parent_payment",
* 	      "method": "GET"
* 	    }
* 	  ]
* 	}

RELEASE loJsonToken
RELEASE loSbAuth
RELEASE loRest
RELEASE loSbPath
RELEASE loSbJsonResponse
RELEASE loJson
RELEASE loDateTime