|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(Classic ASP) PayPal - Find Completed SalesList payments and find completed payments (sales transactions). Get the sales id, state, and total amount for each. Note: This example requires Chilkat v9.5.0.65 or greater.
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' 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") set jsonToken = Server.CreateObject("Chilkat.JsonObject") success = jsonToken.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") set sbAuth = Server.CreateObject("Chilkat.StringBuilder") ' token_type should be "Bearer" success = sbAuth.Append(jsonToken.StringOf("token_type")) success = sbAuth.Append(" ") success = sbAuth.Append(jsonToken.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") set rest = Server.CreateObject("Chilkat.Rest") bAutoReconnect = 1 success = rest.Connect("api.sandbox.paypal.com",443,1,bAutoReconnect) If (success <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' ---------------------------------------------------------------------------------------------- ' 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. success = rest.ClearAllHeaders() success = rest.ClearAllQueryParams() success = rest.AddHeader("Authorization",sbAuth.GetAsString()) ' To find sales transactions, we list payments and look for those ' containing "sale" transactions success = rest.AddQueryParam("count","100") success = rest.AddQueryParam("start_index","0") success = rest.AddQueryParam("sort_by","update_time") success = rest.AddQueryParam("sort_order","asc") ' Send the GET request and get the JSON response. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbJsonResponse = Server.CreateObject("Chilkat.StringBuilder") success = rest.FullRequestNoBodySb("GET","/v1/payments/payment",sbJsonResponse) If (success <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set json = Server.CreateObject("Chilkat.JsonObject") json.EmitCompact = 0 success = json.LoadSb(sbJsonResponse) ' (optional) Save the entire JSON response to a file to examine if desired.. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbTemp = Server.CreateObject("Chilkat.StringBuilder") success = json.EmitSb(sbTemp) success = sbTemp.WriteFile("qa_output/paypal_payments.json","utf-8",0) Response.Write "<pre>" & Server.HTMLEncode( "Response Status Code = " & rest.ResponseStatusCode) & "</pre>" ' Did we get a 200 success response? If (rest.ResponseStatusCode <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( json.Emit()) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>" Response.End End If ' We are looking for sales transactions . ' As shown below, we are looking in the "transactions" for "related_resources" ' containing "sale" JSON objects. ' { ' "payments": [ ' { ' "id": "PAY-66A12106PU3254228LA3BYKI", ' "create_time": "2016-11-23T22:46:01Z", ' "update_time": "2016-11-23T22:46:07Z", ' "state": "approved", ' "intent": "sale", ' "payer": { ' ... ' } ' ] ' }, ' "transactions": [ ' { ' ... ' "related_resources": [ ' { ' "sale": { ' "id": "70L88278E6781074B", ' "create_time": "2016-11-23T22:46:01Z", ' "update_time": "2016-11-23T22:46:07Z", ' "amount": { ' "total": "7.47", ' "currency": "USD" ' }, ' "state": "completed", ' "parent_payment": "PAY-66A12106PU3254228LA3BYKI", ' Iterate over the payments and show each sale transaction. numPayments = json.SizeOfArray("payments") i = 0 Do While i < numPayments json.I = i j = 0 numTransactions = json.SizeOfArray("payments[i].transactions") Do While j < numTransactions json.J = j numRelatedResources = json.SizeOfArray("payments[i].transactions[j].related_resources") k = 0 Do While k < numRelatedResources json.K = k If (json.HasMember("payments[i].transactions[j].related_resources[k].sale") = 1) Then ' jsonSale is a Chilkat.JsonObject Set jsonSale = json.ObjectOf("payments[i].transactions[j].related_resources[k].sale") Response.Write "<pre>" & Server.HTMLEncode( "sale id: " & jsonSale.StringOf("id")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "state: " & jsonSale.StringOf("state")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "total: " & jsonSale.StringOf("amount.total")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "----") & "</pre>" End If k = k + 1 Loop j = j + 1 Loop i = i + 1 Loop Response.Write "<pre>" & Server.HTMLEncode( "success") & "</pre>" %> </body> </html> |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.