(Unicode C) 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 C/C++ Library Downloads
MS Visual C/C++ Linux/CentOS C/C++ Alpine Linux C/C++ MAC OS X C/C++	armhf/aarch64 C/C++ C++ Builder iOS C/C++ Android C/C++	Solaris C/C++ MinGW C/C++

#include <C_CkJsonObjectW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkRestW.h>

void ChilkatSample(void)
    {
    HCkJsonObjectW jsonToken;
    HCkStringBuilderW sbAuth;
    HCkRestW rest;
    BOOL bAutoReconnect;
    BOOL success;
    HCkStringBuilderW sbJsonResponse;
    HCkJsonObjectW json;
    HCkStringBuilderW sbTemp;
    int numPayments;
    int i;
    int j;
    int numTransactions;
    int numRelatedResources;
    int k;
    HCkJsonObjectW jsonSale;

    // 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)
    jsonToken = CkJsonObjectW_Create();
    CkJsonObjectW_LoadFile(jsonToken,L"qa_data/tokens/paypal.json");

    // Build the Authorization request header field value.
    sbAuth = CkStringBuilderW_Create();
    // token_type should be "Bearer"
    CkStringBuilderW_Append(sbAuth,CkJsonObjectW_stringOf(jsonToken,L"token_type"));
    CkStringBuilderW_Append(sbAuth,L" ");
    CkStringBuilderW_Append(sbAuth,CkJsonObjectW_stringOf(jsonToken,L"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.
    rest = CkRestW_Create();
    bAutoReconnect = TRUE;
    success = CkRestW_Connect(rest,L"api.sandbox.paypal.com",443,TRUE,bAutoReconnect);
    if (success != TRUE) {
        wprintf(L"%s\n",CkRestW_lastErrorText(rest));
        CkJsonObjectW_Dispose(jsonToken);
        CkStringBuilderW_Dispose(sbAuth);
        CkRestW_Dispose(rest);
        return;
    }

    // ----------------------------------------------------------------------------------------------
    // 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.
    CkRestW_ClearAllHeaders(rest);
    CkRestW_ClearAllQueryParams(rest);

    CkRestW_AddHeader(rest,L"Authorization",CkStringBuilderW_getAsString(sbAuth));

    // To find sales transactions, we list payments and look for those
    // containing "sale" transactions
    CkRestW_AddQueryParam(rest,L"count",L"100");
    CkRestW_AddQueryParam(rest,L"start_index",L"0");
    CkRestW_AddQueryParam(rest,L"sort_by",L"update_time");
    CkRestW_AddQueryParam(rest,L"sort_order",L"asc");

    // Send the GET request and get the JSON response.
    sbJsonResponse = CkStringBuilderW_Create();
    success = CkRestW_FullRequestNoBodySb(rest,L"GET",L"/v1/payments/payment",sbJsonResponse);
    if (success != TRUE) {
        wprintf(L"%s\n",CkRestW_lastErrorText(rest));
        CkJsonObjectW_Dispose(jsonToken);
        CkStringBuilderW_Dispose(sbAuth);
        CkRestW_Dispose(rest);
        CkStringBuilderW_Dispose(sbJsonResponse);
        return;
    }

    json = CkJsonObjectW_Create();
    CkJsonObjectW_putEmitCompact(json,FALSE);
    CkJsonObjectW_LoadSb(json,sbJsonResponse);

    // (optional) Save the entire JSON response to a file to examine if desired..
    sbTemp = CkStringBuilderW_Create();
    CkJsonObjectW_EmitSb(json,sbTemp);
    CkStringBuilderW_WriteFile(sbTemp,L"qa_output/paypal_payments.json",L"utf-8",FALSE);

    wprintf(L"Response Status Code = %d\n",CkRestW_getResponseStatusCode(rest));

    // Did we get a 200 success response?
    if (CkRestW_getResponseStatusCode(rest) != 200) {
        wprintf(L"%s\n",CkJsonObjectW_emit(json));
        wprintf(L"Failed.\n");
        CkJsonObjectW_Dispose(jsonToken);
        CkStringBuilderW_Dispose(sbAuth);
        CkRestW_Dispose(rest);
        CkStringBuilderW_Dispose(sbJsonResponse);
        CkJsonObjectW_Dispose(json);
        CkStringBuilderW_Dispose(sbTemp);
        return;
    }

    // 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 = CkJsonObjectW_SizeOfArray(json,L"payments");
    i = 0;
    while (i < numPayments) {

        CkJsonObjectW_putI(json,i);
        j = 0;
        numTransactions = CkJsonObjectW_SizeOfArray(json,L"payments[i].transactions");
        while (j < numTransactions) {
            CkJsonObjectW_putJ(json,j);
            numRelatedResources = CkJsonObjectW_SizeOfArray(json,L"payments[i].transactions[j].related_resources");
            k = 0;
            while (k < numRelatedResources) {
                CkJsonObjectW_putK(json,k);
                if (CkJsonObjectW_HasMember(json,L"payments[i].transactions[j].related_resources[k].sale") == TRUE) {
                    jsonSale = CkJsonObjectW_ObjectOf(json,L"payments[i].transactions[j].related_resources[k].sale");
                    wprintf(L"sale id: %s\n",CkJsonObjectW_stringOf(jsonSale,L"id"));
                    wprintf(L"state: %s\n",CkJsonObjectW_stringOf(jsonSale,L"state"));
                    wprintf(L"total: %s\n",CkJsonObjectW_stringOf(jsonSale,L"amount.total"));
                    wprintf(L"----\n");
                    CkJsonObjectW_Dispose(jsonSale);
                }

                k = k + 1;
            }

            j = j + 1;
        }

        i = i + 1;
    }

    wprintf(L"success\n");


    CkJsonObjectW_Dispose(jsonToken);
    CkStringBuilderW_Dispose(sbAuth);
    CkRestW_Dispose(rest);
    CkStringBuilderW_Dispose(sbJsonResponse);
    CkJsonObjectW_Dispose(json);
    CkStringBuilderW_Dispose(sbTemp);

    }