(Node.js) ETrade List Transactions

Gets transactions for the selected brokerage account.

For more information, see https://apisb.etrade.com/docs/api/account/api-transaction-v1.html

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

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

    var http = new chilkat.Http();

    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
    var jsonToken = new chilkat.JsonObject();
    var success = jsonToken.LoadFile("qa_data/tokens/etrade.json");
    if (success !== true) {
        console.log("Failed to load OAuth1 token");
        return;
    }

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

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

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

    // resp: HttpResponse
    var resp = http.QuickGetObj(sandboxUrl);
    if (http.LastMethodSuccess !== true) {
        console.log(http.LastErrorText);
        return;
    }

    // Make sure a successful response was received.
    if (resp.StatusCode > 200) {
        console.log(resp.StatusLine);
        console.log(resp.Header);
        console.log(resp.BodyStr);
        return;
    }

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

    var xml = new chilkat.Xml();
    xml.LoadXml(resp.BodyStr);
    console.log(xml.GetXml());

    var transactionId;
    var accountId;
    var transactionDate;
    var postDate;
    var amount;
    var description;
    var description2;
    var transactionType;
    var imageFlag;
    var instType;
    var quantity;
    var price;
    var settlementCurrency;
    var paymentCurrency;
    var fee;
    var settlementDate;
    var detailsURI;
    var pageMarkers;
    var moreTransactions;
    var transactionCount;
    var totalCount;

    var i = 0;
    var count_i = xml.NumChildrenHavingTag("Transaction");
    while (i < count_i) {
        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;
    }

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

    console.log("Success.");

}

chilkatExample();