(Classic ASP) ETrade v1 List Orders

Gets the order details for a selected brokerage account based on the search criteria provided.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = Server.CreateObject("Chilkat.Http")

http.OAuth1 = 1
http.OAuthVerifier = ""
http.OAuthConsumerKey = "ETRADE_CONSUMER_KEY"
http.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET"

' Load the access token previously obtained via the OAuth1 3-Legged Authorization examples Step1 and Step2.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.LoadFile("qa_data/tokens/etrade.json")
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Failed to load OAuth1 token") & "</pre>"
    Response.End
End If

http.OAuthToken = json.StringOf("oauth_token")
http.OAuthTokenSecret = json.StringOf("oauth_token_secret")

' See the ETrade v1 API documentation HERE.

success = http.SetUrlVar("accountIdKey","vsnhtF7d9jXxBy6HyaAC4vQ")
respStr = http.QuickGetStr("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/orders?securityType=EQ&count=100")
If (http.LastMethodSuccess <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
    Response.End
End If

' A 200 status code indicates success.
statusCode = http.LastStatus
Response.Write "<pre>" & Server.HTMLEncode( "statusCode = " & statusCode) & "</pre>"

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

' A sample XML response is shown below...

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = Server.CreateObject("Chilkat.Xml")
success = xml.LoadXml(respStr)

i = 0
count_i = xml.NumChildrenHavingTag("Order")
Do While i < count_i
    xml.I = i
    orderId = xml.GetChildIntValue("Order[i]|orderId")
    details = xml.GetChildContent("Order[i]|details")
    orderType = xml.GetChildContent("Order[i]|orderType")
    OrderDetail = xml.GetChildContent("Order[i]|OrderDetail")
    i = i + 1
Loop

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

%>
</body>
</html>