Chilkat Examples

ChilkatHOME.NET Core C#Android™AutoItCC#C++Chilkat2-PythonCkPythonClassic ASPDataFlexDelphi ActiveXDelphi DLLGoJavaLianjaMono C#Node.jsObjective-CPHP ActiveXPHP ExtensionPerlPowerBuilderPowerShellPureBasicRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++VB.NETVBScriptVisual Basic 6.0Visual FoxProXojo Plugin

DataFlex Web API Examples

Primary Categories

ABN AMRO
AWS Secrets Manager
AWS Security Token Service
AWS Translate
Activix CRM
Adyen
Alibaba Cloud OSS
Amazon Cognito
Amazon DynamoDB
Amazon MWS
Amazon Pay
Amazon Rekognition
Amazon SP-API
Amazon Voice ID
Aruba Fatturazione
Azure Maps
Azure Monitor
Azure OAuth2
Azure Storage Accounts
Backblaze S3
Banco Inter
Belgian eHealth Platform
Bitfinex v2 REST
Bluzone
BrickLink
Bunny CDN
CallRail
CardConnect
Cerved
ClickBank
Clickatell
Cloudfare
Constant Contact
DocuSign
Duo Auth MFA
ETrade
Ecwid
Egypt ITIDA
Egypt eReceipt
Etsy
Facebook
Faire
Frame.io
GeoOp
GetHarvest
Global Payments
Google People
Google Search Console
Google Translate
Hungary NAV Invoicing
IBM Text to Speech
Ibanity
IntakeQ
Jira
Lightspeed
MYOB
Magento
Mailgun
Mastercard

MedTunnel
MercadoLibre
MessageMedia
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
Moody's
Okta OAuth/OIDC
OneLogin OIDC
OneNote
OpenAI ChatGPT
PRODA
PayPal
Paynow.pl
Peoplevox
Populi
QuickBooks
Rabobank
Refinitiv
Royal Mail OBA
SCiS Schools Catalogue
SII Chile
SMSAPI
SOAP finkok.com
SendGrid
Shippo
Shopify
Shopware
Shopware 6
SimpleTexting
Square
Stripe
SugarCRM
TicketBAI
Trello
Twilio
Twitter API v2
Twitter v1
UPS
UniPin
VoiceBase
Vonage
WaTrend
Walmart v3
Wasabi
WhatsApp
WiX
WooCommerce
WordPress
Xero
Yahoo Mail
Yapily
Yousign
ZATCA
Zendesk
Zoom
_Miscellaneous_
eBay
effectconnect
hacienda.go.cr

 

 

 

(DataFlex) PayPal - Find Completed Sales

List 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.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-9.5.0-win32.pkg

Procedure Test
    Handle hoJsonToken
    Handle hoSbAuth
    Handle hoRest
    Boolean iBAutoReconnect
    Boolean iSuccess
    Variant vSbJsonResponse
    Handle hoSbJsonResponse
    Handle hoJson
    Variant vSbTemp
    Handle hoSbTemp
    Integer iNumPayments
    Integer i
    Integer j
    Integer iNumTransactions
    Integer iNumRelatedResources
    Integer k
    Variant vJsonSale
    Handle hoJsonSale
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    // 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)
    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..
    // ----------------------------------------------------------------------------------------------

    // Clear the REST object of any headers or query params from previous requests.
    Get ComClearAllHeaders Of hoRest To iSuccess
    Get ComClearAllQueryParams Of hoRest To iSuccess

    Get ComGetAsString Of hoSbAuth To sTemp1
    Get ComAddHeader Of hoRest "Authorization" sTemp1 To iSuccess

    // To find sales transactions, we list payments and look for those
    // containing "sale" transactions
    Get ComAddQueryParam Of hoRest "count" "100" To iSuccess
    Get ComAddQueryParam Of hoRest "start_index" "0" To iSuccess
    Get ComAddQueryParam Of hoRest "sort_by" "update_time" To iSuccess
    Get ComAddQueryParam Of hoRest "sort_order" "asc" 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/payments/payment" 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

    // (optional) Save the entire JSON response to a file to examine if desired..
    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbTemp
    If (Not(IsComObjectCreated(hoSbTemp))) Begin
        Send CreateComObject of hoSbTemp
    End
    Get pvComObject of hoSbTemp to vSbTemp
    Get ComEmitSb Of hoJson vSbTemp To iSuccess
    Get ComWriteFile Of hoSbTemp "qa_output/paypal_payments.json" "utf-8" False 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

    // 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.
    Get ComSizeOfArray Of hoJson "payments" To iNumPayments
    Move 0 To i
    While (i < iNumPayments)

        Set ComI Of hoJson To i
        Move 0 To j
        Get ComSizeOfArray Of hoJson "payments[i].transactions" To iNumTransactions
        While (j < iNumTransactions)
            Set ComJ Of hoJson To j
            Get ComSizeOfArray Of hoJson "payments[i].transactions[j].related_resources" To iNumRelatedResources
            Move 0 To k
            While (k < iNumRelatedResources)
                Set ComK Of hoJson To k
                Get ComHasMember Of hoJson "payments[i].transactions[j].related_resources[k].sale" To bTemp1
                If (bTemp1 = True) Begin
                    Get ComObjectOf Of hoJson "payments[i].transactions[j].related_resources[k].sale" To vJsonSale
                    If (IsComObject(vJsonSale)) Begin
                        Get Create (RefClass(cComChilkatJsonObject)) To hoJsonSale
                        Set pvComObject Of hoJsonSale To vJsonSale
                    End
                    Get ComStringOf Of hoJsonSale "id" To sTemp1
                    Showln "sale id: " sTemp1
                    Get ComStringOf Of hoJsonSale "state" To sTemp1
                    Showln "state: " sTemp1
                    Get ComStringOf Of hoJsonSale "amount.total" To sTemp1
                    Showln "total: " sTemp1
                    Showln "----"
                    Send Destroy of hoJsonSale
                End

                Move k + 1 To k
            Loop

            Move j + 1 To j
        Loop

        Move i + 1 To i
    Loop

    Showln "success"


End_Procedure

 

© 2000-2024 Chilkat Software, Inc. All Rights Reserved.