(MFC) 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

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkHttp.h>
#include <CkJsonObject.h>
#include <CkHttpResponse.h>
#include <CkXml.h>

void ChilkatSample(void)
    {
    CkString strOut;

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

    CkHttp http;

    http.put_OAuth1(true);
    http.put_OAuthVerifier("");
    http.put_OAuthConsumerKey("ETRADE_CONSUMER_KEY");
    http.put_OAuthConsumerSecret("ETRADE_CONSUMER_SECRET");

    // Load the access token previously obtained via the OAuth1 Authorization
    CkJsonObject jsonToken;
    bool success = jsonToken.LoadFile("qa_data/tokens/etrade.json");
    if (success != true) {
        strOut.append("Failed to load OAuth1 token");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    http.put_OAuthToken(jsonToken.stringOf("oauth_token"));
    http.put_OAuthTokenSecret(jsonToken.stringOf("oauth_token_secret"));

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

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

    CkHttpResponse *resp = http.QuickGetObj(sandboxUrl);
    if (http.get_LastMethodSuccess() != true) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    // Make sure a successful response was received.
    if (resp->get_StatusCode() > 200) {
        strOut.append(resp->statusLine());
        strOut.append("\r\n");
        strOut.append(resp->header());
        strOut.append("\r\n");
        strOut.append(resp->bodyStr());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        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>

    CkXml xml;
    xml.LoadXml(resp->bodyStr());
    strOut.append(xml.getXml());
    strOut.append("\r\n");

    const char *transactionId = 0;
    int accountId;
    const char *transactionDate = 0;
    const char *postDate = 0;
    int amount;
    const char *description = 0;
    int description2;
    const char *transactionType = 0;
    const char *imageFlag = 0;
    const char *instType = 0;
    int quantity;
    int price;
    const char *settlementCurrency = 0;
    const char *paymentCurrency = 0;
    int fee;
    const char *settlementDate = 0;
    const char *detailsURI = 0;
    const char *pageMarkers = 0;
    const char *moreTransactions = 0;
    int transactionCount;
    int totalCount;

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

    strOut.append("Success.");
    strOut.append("\r\n");


    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }