Lua

ETrade v1 List Orders

See more HTTP Misc Examples

Gets the order details for a selected brokerage account based on the search criteria provided. 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}/orders?securityType=EQ&count=100")
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 orderId = 0
local details = ""
local orderType = ""
local OrderDetail = ""

local i = 0
local count_i = xml:num_children_having_tag("Order")
while i < count_i do
    xml.i = i
    orderId = xml:get_child_int_value("Order[i]|orderId")
    details = xml:get_child_content("Order[i]|details")
    orderType = xml:get_child_content("Order[i]|orderType")
    OrderDetail = xml:get_child_content("Order[i]|OrderDetail")
    i = i + 1
end

-- Sample XML Response
-- <?xml version="1.0" encoding="UTF-8"?>
-- <OrdersResponse>
--    <Order>
--       <orderId>96</orderId>
--       <details>https://api.etrade.com/v1/accounts/ZrnXF-hPu853sBzwHfWGBQ/orders/96</details>
--       <orderType>EQ</orderType>
--       <OrderDetail>�</OrderDetail>
--    </Order>
--    <Order>
--       <orderId>95</orderId>
--       <details>https://api.etrade.com/v1/accounts/ZrnXF-hPu853sBzwHfWGBQ/orders/95</details>
--       <orderType>EQ</orderType>
--       <OrderDetail>�</OrderDetail>
--    </Order>
--    <Order>
--       <orderId>94</orderId>
--       <details>https://api.etrade.com/v1/accounts/ZrnXF-hPu853sBzwHfWGBQ/orders/94</details>
--       <orderType>EQ</orderType>
--       <OrderDetail>�</OrderDetail>
--    </Order>
--    <Order>
--       <orderId>93</orderId>
--       <details>https://api.etrade.com/v1/accounts/ZrnXF-hPu853sBzwHfWGBQ/orders/93</details>
--       <orderType>EQ</orderType>
--       <OrderDetail>�</OrderDetail>
--    </Order>
-- </OrdersResponse>