Sample code for 30+ languages & platforms
Lua

ETrade v1 List Transactions

See more HTTP Misc Examples

Get information about the transactions in an ETrade brokerage account.

Chilkat Lua Downloads

Download Chilkat for Lua
Lua 
local chilkat = require("chilkat")

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

local http = chilkat.Http.new()

http.oauth1 = true
http.oauth_verifier = ""
http.oauth_consumer_key = "ETRADE_CONSUMER_KEY"
http.oauth_consumer_secret = "ETRADE_CONSUMER_SECRET"

-- Load the access token previously obtained via the OAuth1 3-Legged Authorization examples Step1 and Step2.
local json = chilkat.JsonObject.new()
local success = json:load_file("qa_data/tokens/etrade.json")
if not success then
    print("Failed to load OAuth1 token")
    return
end

http.oauth_token = json:string_of("oauth_token")
http.oauth_token_secret = json:string_of("oauth_token_secret")

-- See the ETrade v1 API documentation HERE.

http:set_url_var("accountIdKey", "vsnhtF7d9jXxBy6HyaAC4vQ")
local respStr = http:quick_get_str("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/transactions")
if not http.last_method_success then
    print(http.last_error_text)
    return
end

-- A 200 status code indicates success.
local statusCode = http.last_status
print("statusCode = " .. statusCode)

-- Use the following online tool to generate parsing code from sample XML:
-- Generate Parsing Code from XML

-- A sample XML response is shown below...

local xml = chilkat.Xml.new()
xml:load_xml(respStr)

local tagPath = ""
local transactionId = ""
local accountId = 0
local transactionDate = ""
local postDate = ""
local amount = 0
local description = ""
local description2 = 0
local transactionType = ""
local imageFlag = ""
local instType = ""
local quantity = 0
local price = 0
local settlementCurrency = ""
local paymentCurrency = ""
local fee = 0
local settlementDate = ""
local detailsURI = ""

local i = 0
local count_i = xml:num_children_having_tag("Transaction")
while i < count_i do
    xml.i = i
    transactionId = xml:get_child_content("Transaction[i]|transactionId")
    accountId = xml:get_child_int_value("Transaction[i]|accountId")
    transactionDate = xml:get_child_content("Transaction[i]|transactionDate")
    postDate = xml:get_child_content("Transaction[i]|postDate")
    amount = xml:get_child_int_value("Transaction[i]|amount")
    description = xml:get_child_content("Transaction[i]|description")
    description2 = xml:get_child_int_value("Transaction[i]|description2")
    transactionType = xml:get_child_content("Transaction[i]|transactionType")
    imageFlag = xml:get_child_content("Transaction[i]|imageFlag")
    instType = xml:get_child_content("Transaction[i]|instType")
    quantity = xml:get_child_int_value("Transaction[i]|brokerage|quantity")
    price = xml:get_child_int_value("Transaction[i]|brokerage|price")
    settlementCurrency = xml:get_child_content("Transaction[i]|brokerage|settlementCurrency")
    paymentCurrency = xml:get_child_content("Transaction[i]|brokerage|paymentCurrency")
    fee = xml:get_child_int_value("Transaction[i]|brokerage|fee")
    settlementDate = xml:get_child_content("Transaction[i]|brokerage|settlementDate")
    detailsURI = xml:get_child_content("Transaction[i]|detailsURI")
    i = i + 1
end

local pageMarkers = xml:get_child_content("pageMarkers")
local moreTransactions = xml:get_child_content("moreTransactions")
local transactionCount = xml:get_child_int_value("transactionCount")
local totalCount = xml:get_child_int_value("totalCount")

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