C#

ETrade List Transactions

See more ETrade Examples

Gets transactions for the selected brokerage account. C#

bool success = false;

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

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

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

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

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

Chilkat.HttpResponse resp = new Chilkat.HttpResponse();
success = http.HttpNoBody("GET",sandboxUrl,resp);
if (success == false) {
    Debug.WriteLine(http.LastErrorText);
    return;
}

//  Make sure a successful response was received.
if (resp.StatusCode > 200) {
    Debug.WriteLine(resp.StatusLine);
    Debug.WriteLine(resp.Header);
    Debug.WriteLine(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>

Chilkat.Xml xml = new Chilkat.Xml();
xml.LoadXml(resp.BodyStr);
Debug.WriteLine(xml.GetXml());

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

int i = 0;
int 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");

Debug.WriteLine("Success.");