|
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
(DataFlex) PayPal List Merchant InvoicesList PayPal invoices. See also PayPal List Invoices REST API Reference
Use ChilkatAx-win32.pkg Procedure Test Token Handle hoJsonToken Boolean iSuccess Handle hoSbAuth Handle hoRest Boolean iBAutoReconnect Boolean iSuccess Variant vSbJsonResponse Handle hoSbJsonResponse Handle hoJson Integer iNumInvoices Integer i Integer j Integer iNumBillingInfo Integer iNumLinks String sTemp1 Integer iTemp1 // Note: Requires Chilkat v9.5.0.64 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) Get Create (RefClass(cComChilkatJsonObject)) To hoJsonToken If (Not(IsComObjectCreated(hoJsonToken))) Begin Send CreateComObject of hoJsonToken End Get ComLoadFile Of hoJsonToken "qa_data/tokens/paypal.json" To iSuccess // Build the Authorization request header field value. Get Create (RefClass(cComChilkatStringBuilder)) To hoSbAuth If (Not(IsComObjectCreated(hoSbAuth))) Begin Send CreateComObject of hoSbAuth End // token_type should be "Bearer" Get ComStringOf Of hoJsonToken "token_type" To sTemp1 Get ComAppend Of hoSbAuth sTemp1 To iSuccess Get ComAppend Of hoSbAuth " " To iSuccess Get ComStringOf Of hoJsonToken "access_token" To sTemp1 Get ComAppend Of hoSbAuth sTemp1 To iSuccess // 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. Get Create (RefClass(cComChilkatRest)) To hoRest If (Not(IsComObjectCreated(hoRest))) Begin Send CreateComObject of hoRest End Move True To iBAutoReconnect Get ComConnect Of hoRest "api.sandbox.paypal.com" 443 True iBAutoReconnect To iSuccess If (iSuccess <> True) Begin Get ComLastErrorText Of hoRest To sTemp1 Showln sTemp1 Procedure_Return End // ---------------------------------------------------------------------------------------------- // 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.. // ---------------------------------------------------------------------------------------------- Get ComGetAsString Of hoSbAuth To sTemp1 Get ComAddHeader Of hoRest "Authorization" sTemp1 To iSuccess Get ComAddQueryParam Of hoRest "page" "0" To iSuccess Get ComAddQueryParam Of hoRest "page_size" "20" To iSuccess Get ComAddQueryParam Of hoRest "total_count_required" "true" To iSuccess // Send the GET request and get the JSON response. Get Create (RefClass(cComChilkatStringBuilder)) To hoSbJsonResponse If (Not(IsComObjectCreated(hoSbJsonResponse))) Begin Send CreateComObject of hoSbJsonResponse End Get pvComObject of hoSbJsonResponse to vSbJsonResponse Get ComFullRequestNoBodySb Of hoRest "GET" "/v1/invoicing/invoices" vSbJsonResponse To iSuccess If (iSuccess <> True) Begin Get ComLastErrorText Of hoRest To sTemp1 Showln sTemp1 Procedure_Return End Get Create (RefClass(cComChilkatJsonObject)) To hoJson If (Not(IsComObjectCreated(hoJson))) Begin Send CreateComObject of hoJson End Set ComEmitCompact Of hoJson To False Get pvComObject of hoSbJsonResponse to vSbJsonResponse Get ComLoadSb Of hoJson vSbJsonResponse To iSuccess Get ComResponseStatusCode Of hoRest To iTemp1 Showln "Response Status Code = " iTemp1 // Did we get a 200 success response? Get ComResponseStatusCode Of hoRest To iTemp1 If (iTemp1 <> 200) Begin Get ComEmit Of hoJson To sTemp1 Showln sTemp1 Showln "Failed." Procedure_Return End // Sample response JSON is shown below. // Iterate over each invoice and get some information from each.. Get ComSizeOfArray Of hoJson "invoices" To iNumInvoices Move 0 To i While (i < iNumInvoices) Set ComI Of hoJson To i Get ComStringOf Of hoJson "invoices[i].id" To sTemp1 Showln "Invoice ID: " sTemp1 Get ComStringOf Of hoJson "invoices[i].number" To sTemp1 Showln "Invoice Number: " sTemp1 Get ComStringOf Of hoJson "invoices[i].status" To sTemp1 Showln "Invoice Status: " sTemp1 Get ComStringOf Of hoJson "invoices[i].shipping_info.first_name" To sTemp1 Showln "Shipping First Name: " sTemp1 Move 0 To j Get ComSizeOfArray Of hoJson "invoices[i].billing_info" To iNumBillingInfo While (j < iNumBillingInfo) Set ComJ Of hoJson To j Get ComStringOf Of hoJson "invoices[i].billing_info[j].email" To sTemp1 Showln "billing_info email: " sTemp1 Move (j + 1) To j Loop Get ComSizeOfArray Of hoJson "invoices[i].links" To iNumLinks Move 0 To j While (j < iNumLinks) Set ComJ Of hoJson To j Get ComStringOf Of hoJson "invoices[i].links[j].href" To sTemp1 Showln "link: " sTemp1 Move (j + 1) To j Loop Showln "----" Move (i + 1) To i Loop Showln "Success." // { // "total_count": 2, // "invoices": [ // { // "id": "INV2-XV4B-736P-PLVN-SZCE", // "number": "0002", // "status": "DRAFT", // "merchant_info": { // "email": "smith-facilitator@chilkatsoft.com" // }, // "billing_info": [ // { // "email": "smith-buyer@chilkatsoft.com" // } // ], // "shipping_info": { // "email": "smith-buyer@chilkatsoft.com", // "first_name": "Sally", // "last_name": "Patient", // "business_name": "Not applicable" // }, // "invoice_date": "2016-11-15 PST", // "payment_term": { // "due_date": "2016-12-30 PST" // }, // "note": "Medical Invoice 16 Jul, 2013 PST", // "total_amount": { // "currency": "USD", // "value": "500.00" // }, // "metadata": { // "created_date": "2016-11-15 08:09:21 PST" // }, // "paid_amount": { // "paypal": { // "currency": "USD", // "value": "0.00" // }, // "other": { // "currency": "USD", // "value": "0.00" // } // }, // "refunded_amount": { // "paypal": { // "currency": "USD", // "value": "0.00" // }, // "other": { // "currency": "USD", // "value": "0.00" // } // }, // "links": [ // { // "rel": "self", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-XV4B-736P-PLVN-SZCE", // "method": "GET" // }, // { // "rel": "send", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-XV4B-736P-PLVN-SZCE/send", // "method": "POST" // }, // { // "rel": "update", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-XV4B-736P-PLVN-SZCE/update", // "method": "PUT" // }, // { // "rel": "delete", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-XV4B-736P-PLVN-SZCE", // "method": "DELETE" // } // ] // }, // { // "id": "INV2-ZG2H-HKAW-PMWU-N6ZR", // "number": "0001", // "status": "SENT", // "merchant_info": { // "email": "smith-facilitator@chilkatsoft.com" // }, // "billing_info": [ // { // "email": "smith-buyer@chilkatsoft.com" // } // ], // "shipping_info": { // "email": "smith-buyer@chilkatsoft.com", // "first_name": "Sally", // "last_name": "Patient", // "business_name": "Not applicable" // }, // "invoice_date": "2016-11-15 PST", // "payment_term": { // "due_date": "2016-12-30 PST" // }, // "note": "Medical Invoice 16 Jul, 2013 PST", // "total_amount": { // "currency": "USD", // "value": "500.00" // }, // "metadata": { // "created_date": "2016-11-15 06:17:03 PST", // "payer_view_url": "https://www.sandbox.paypal.com/cgi_bin/webscr?cmd=_pay-inv&viewtype=altview&id=INV2-ZG2H-HKAW-PMWU-N6ZR" // }, // "paid_amount": { // "paypal": { // "currency": "USD", // "value": "0.00" // }, // "other": { // "currency": "USD", // "value": "0.00" // } // }, // "refunded_amount": { // "paypal": { // "currency": "USD", // "value": "0.00" // }, // "other": { // "currency": "USD", // "value": "0.00" // } // }, // "links": [ // { // "rel": "self", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR", // "method": "GET" // }, // { // "rel": "update", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR/update", // "method": "PUT" // }, // { // "rel": "cancel", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR/remind", // "method": "POST" // }, // { // "rel": "remind", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR/cancel", // "method": "POST" // }, // { // "rel": "record-payment", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR/record-payment", // "method": "POST" // }, // { // "rel": "qr-code", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices/INV2-ZG2H-HKAW-PMWU-N6ZR/qr-code", // "method": "GET" // } // ] // } // ], // "links": [ // { // "rel": "self", // "href": "https://api.sandbox.paypal.com/v1/invoicing/invoices?page=0&page_size=20&total_count_required=true", // "method": "GET" // } // ] // } // End_Procedure |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.