Pascal (Lazarus/Delphi)

ETrade List Transactions

See more ETrade Examples

Gets transactions for the selected brokerage account. 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.Http,
  Chilkat.Xml,
  Chilkat.HttpResponse,
  Chilkat.JsonObject;

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

procedure RunDemo;
var
  success: Boolean;
  http: THttp;
  jsonToken: TJsonObject;
  sandboxUrl: string;
  liveUrl: string;
  resp: THttpResponse;
  xml: TXml;
  transactionId: string;
  accountId: Integer;
  transactionDate: string;
  postDate: string;
  amount: Integer;
  description: string;
  description2: Integer;
  transactionType: string;
  imageFlag: string;
  instType: string;
  quantity: Integer;
  price: Integer;
  settlementCurrency: string;
  paymentCurrency: string;
  fee: Integer;
  settlementDate: string;
  detailsURI: string;
  pageMarkers: string;
  moreTransactions: string;
  transactionCount: Integer;
  totalCount: Integer;
  i: Integer;
  count_i: Integer;

begin
  success := False;

  //  This requires the Chilkat API to have been previously unlocked.
  //  See Global Unlock Sample for sample code.

  http := THttp.Create;

  http.OAuth1 := True;
  http.OAuthVerifier := '';
  http.OAuthConsumerKey := 'ETRADE_CONSUMER_KEY';
  http.OAuthConsumerSecret := 'ETRADE_CONSUMER_SECRET';

  //  Load the access token previously obtained via the OAuth1 Authorization
  jsonToken := TJsonObject.Create;
  success := jsonToken.LoadFile('qa_data/tokens/etrade.json');
  if (success <> True) then
    begin
      WriteLn('Failed to load OAuth1 token');
      Exit;
    end;

  http.OAuthToken := jsonToken.StringOf('oauth_token');
  http.OAuthTokenSecret := jsonToken.StringOf('oauth_token_secret');

  sandboxUrl := 'https://apisb.etrade.com/v1/accounts/{$accountIdKey}/transactions';
  liveUrl := 'https://api.etrade.com/v1/accounts/{$accountIdKey}/transactions';

  http.SetUrlVar('accountIdKey','6_Dpy0rmuQ9cu9IbTfvF2A');

  resp := THttpResponse.Create;
  success := http.HttpNoBody('GET',sandboxUrl,resp);
  if (success = False) then
    begin
      WriteLn(http.LastErrorText);
      Exit;
    end;

  //  Make sure a successful response was received.
  if (resp.StatusCode > 200) then
    begin
      WriteLn(resp.StatusLine);
      WriteLn(resp.Header);
      WriteLn(resp.BodyStr);
      Exit;
    end;

  //  Sample XML response:

  //  Use this online tool to generate parsing code from sample XML: 
  //  Generate Parsing Code from XML

  //  <?xml version="1.0" encoding="UTF-8"?>
  //  <TransactionListResponse>
  //     <Transaction>
  //        <transactionId>18165100001766</transactionId>
  //        <accountId>83564979</accountId>
  //        <transactionDate>1528948800000</transactionDate>
  //        <postDate>1528948800000</postDate>
  //        <amount>-2</amount>
  //        <description>ACH WITHDRAWL REFID:109187276;</description>
  //        <description2>109187276</description2>
  //        <transactionType>Transfer</transactionType>
  //        <memo />
  //        <imageFlag>false</imageFlag>
  //        <instType>BROKERAGE</instType>
  //        <brokerage>
  //           <product />
  //           <quantity>0</quantity>
  //           <price>0</price>
  //           <settlementCurrency>USD</settlementCurrency>
  //           <paymentCurrency>USD</paymentCurrency>
  //           <fee>0</fee>
  //           <settlementDate>1528948800000</settlementDate>
  //        </brokerage>
  //        <detailsURI>https://api.etrade.com/v1/accounts/yIFaUoJ81qyAhgxLWRQ42g/transactions/18165100001766</detailsURI>
  //     </Transaction>
  //     <Transaction>
  //        <transactionId>18158100000983</transactionId>
  //        <accountId>83564979</accountId>
  //        <transactionDate>1528344000000</transactionDate>
  //        <postDate>1528344000000</postDate>
  //        <amount>-2</amount>
  //        <description>ACH WITHDRAWL REFID:98655276;</description>
  //        <description2>98655276</description2>
  //        <transactionType>Transfer</transactionType>
  //        <memo />
  //        <imageFlag>false</imageFlag>
  //        <instType>BROKERAGE</instType>
  //        <brokerage>
  //           <product />
  //           <quantity>0</quantity>
  //           <price>0</price>
  //           <settlementCurrency>USD</settlementCurrency>
  //           <paymentCurrency>USD</paymentCurrency>
  //           <fee>0</fee>
  //           <settlementDate>1528344000000</settlementDate>
  //        </brokerage>
  //        <detailsURI>https://api.etrade.com/v1/accounts/yIFaUoJ81qyAhgxLWRQ42g/transactions/18158100000983</detailsURI>
  //     </Transaction>
  //     <pageMarkers>eNpTsAlITE91zi%2FNK%2FHMc04syi8tTs2xM7TRxybMpWATkl%2BSmBOUmpxflAKWtTO10ccQg6mDmwEyEE0EqAbE8SvNTUotCk4tLE3NS061M9Ax0DEEYgOIA9BkuRQgmjxTfDKLQUYoQAV8E4uyU4vsDC0MzUwNDYDA0NzMrKamBmIKVJYLphpiKsyTUB7IbH1kwwFa7F0D</pageMarkers>
  //     <moreTransactions>false</moreTransactions>
  //     <transactionCount>5</transactionCount>
  //     <totalCount>5</totalCount>
  //  </TransactionListResponse>

  xml := TXml.Create;
  xml.LoadXml(resp.BodyStr);
  WriteLn(xml.GetXml());

  i := 0;
  count_i := xml.NumChildrenHavingTag('Transaction');
  while i < count_i do
    begin
      xml.I := i;
      transactionId := xml.GetChildContent('Transaction[i]|transactionId');
      accountId := xml.GetChildIntValue('Transaction[i]|accountId');
      transactionDate := xml.GetChildContent('Transaction[i]|transactionDate');
      postDate := xml.GetChildContent('Transaction[i]|postDate');
      amount := xml.GetChildIntValue('Transaction[i]|amount');
      description := xml.GetChildContent('Transaction[i]|description');
      description2 := xml.GetChildIntValue('Transaction[i]|description2');
      transactionType := xml.GetChildContent('Transaction[i]|transactionType');
      imageFlag := xml.GetChildContent('Transaction[i]|imageFlag');
      instType := xml.GetChildContent('Transaction[i]|instType');
      quantity := xml.GetChildIntValue('Transaction[i]|brokerage|quantity');
      price := xml.GetChildIntValue('Transaction[i]|brokerage|price');
      settlementCurrency := xml.GetChildContent('Transaction[i]|brokerage|settlementCurrency');
      paymentCurrency := xml.GetChildContent('Transaction[i]|brokerage|paymentCurrency');
      fee := xml.GetChildIntValue('Transaction[i]|brokerage|fee');
      settlementDate := xml.GetChildContent('Transaction[i]|brokerage|settlementDate');
      detailsURI := xml.GetChildContent('Transaction[i]|detailsURI');
      i := i + 1;
    end;

  pageMarkers := xml.GetChildContent('pageMarkers');
  moreTransactions := xml.GetChildContent('moreTransactions');
  transactionCount := xml.GetChildIntValue('transactionCount');
  totalCount := xml.GetChildIntValue('totalCount');

  WriteLn('Success.');


  http.Free;
  jsonToken.Free;
  resp.Free;
  xml.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.