Pascal (Lazarus/Delphi)

PayPal - Find Completed Sales

See more PayPal Examples

List payments and find completed payments (sales transactions). Get the sales id, state, and total amount for each. Pascal (Lazarus/Delphi)

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.StringBuilder,
  Chilkat.Rest,
  Chilkat.JsonObject;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  jsonToken: TJsonObject;
  sbAuth: TStringBuilder;
  rest: TRest;
  bAutoReconnect: Boolean;
  sbJsonResponse: TStringBuilder;
  json: TJsonObject;
  sbTemp: TStringBuilder;
  jsonSale: TJsonObject;
  numPayments: Integer;
  i: Integer;
  j: Integer;
  numTransactions: Integer;
  numRelatedResources: Integer;
  k: Integer;

begin
  success := False;

  //  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 := TJsonObject.Create;
  jsonToken.LoadFile('qa_data/tokens/paypal.json');

  //  Build the Authorization request header field value.
  sbAuth := TStringBuilder.Create;
  //  token_type should be "Bearer"
  sbAuth.Append(jsonToken.StringOf('token_type'));
  sbAuth.Append(' ');
  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.
  rest := TRest.Create;
  bAutoReconnect := True;
  success := rest.Connect('api.sandbox.paypal.com',443,True,bAutoReconnect);
  if (success = False) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    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.
  rest.ClearAllHeaders();
  rest.ClearAllQueryParams();

  rest.AddHeader('Authorization',sbAuth.GetAsString());

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

  //  Send the GET request and get the JSON response.
  sbJsonResponse := TStringBuilder.Create;
  success := rest.FullRequestNoBodySb('GET','/v1/payments/payment',sbJsonResponse);
  if (success = False) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    end;

  json := TJsonObject.Create;
  json.EmitCompact := False;
  json.LoadSb(sbJsonResponse);

  //  (optional) Save the entire JSON response to a file to examine if desired..
  sbTemp := TStringBuilder.Create;
  json.EmitSb(sbTemp);
  sbTemp.WriteFile('qa_output/paypal_payments.json','utf-8',False);

  WriteLn('Response Status Code = ' + rest.ResponseStatusCode);

  //  Did we get a 200 success response?
  if (rest.ResponseStatusCode <> 200) then
    begin
      WriteLn(json.Emit());
      WriteLn('Failed.');
      Exit;
    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.
  jsonSale := TJsonObject.Create;
  numPayments := json.SizeOfArray('payments');
  i := 0;
  while i < numPayments do
    begin

      json.I := i;
      j := 0;
      numTransactions := json.SizeOfArray('payments[i].transactions');
      while j < numTransactions do
        begin
          json.J := j;
          numRelatedResources := json.SizeOfArray('payments[i].transactions[j].related_resources');
          k := 0;
          while k < numRelatedResources do
            begin
              json.K := k;
              if (json.HasMember('payments[i].transactions[j].related_resources[k].sale') = True) then
                begin

                  json.ObjectOf2('payments[i].transactions[j].related_resources[k].sale',jsonSale);

                  WriteLn('sale id: ' + jsonSale.StringOf('id'));
                  WriteLn('state: ' + jsonSale.StringOf('state'));
                  WriteLn('total: ' + jsonSale.StringOf('amount.total'));
                  WriteLn('----');
                end;
              k := k + 1;
            end;

          j := j + 1;
        end;

      i := i + 1;
    end;

  WriteLn('success');


  jsonToken.Free;
  sbAuth.Free;
  rest.Free;
  sbJsonResponse.Free;
  json.Free;
  sbTemp.Free;
  jsonSale.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.