Classic ASP

ETrade v1 List Accounts

See more HTTP Misc Examples

List ETrade accounts using the ETrade v1 API. Classic ASP

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0

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

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

respStr = http.QuickGetStr("https://apisb.etrade.com/v1/accounts/list")
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...

set xml = Server.CreateObject("Chilkat.Xml")
success = xml.LoadXml(respStr)

i = 0
count_i = xml.NumChildrenHavingTag("Accounts|Account")
Do While i < count_i
    xml.I = i
    accountId = xml.GetChildIntValue("Accounts|Account[i]|accountId")
    accountIdKey = xml.GetChildContent("Accounts|Account[i]|accountIdKey")
    accountMode = xml.GetChildContent("Accounts|Account[i]|accountMode")
    accountDesc = xml.GetChildContent("Accounts|Account[i]|accountDesc")
    accountName = xml.GetChildContent("Accounts|Account[i]|accountName")
    accountType = xml.GetChildContent("Accounts|Account[i]|accountType")
    institutionType = xml.GetChildContent("Accounts|Account[i]|institutionType")
    accountStatus = xml.GetChildContent("Accounts|Account[i]|accountStatus")
    closedDate = xml.GetChildIntValue("Accounts|Account[i]|closedDate")
    i = i + 1
Loop

'  <?xml version="1.0" encoding="UTF-8"?>
'  <AccountListResponse>
'     <Accounts>
'        <Account>
'           <accountId>84010429</accountId>
'           <accountIdKey>JIdOIAcSpwR1Jva7RQBraQ</accountIdKey>
'           <accountMode>MARGIN</accountMode>
'           <accountDesc>INDIVIDUAL</accountDesc>
'           <accountName>Individual Brokerage</accountName>
'           <accountType>INDIVIDUAL</accountType>
'           <institutionType>BROKERAGE</institutionType>
'           <accountStatus>ACTIVE</accountStatus>
'           <closedDate>0</closedDate>
'        </Account>
'        <Account>
'           <accountId>84010430</accountId>
'           <accountIdKey>JAAOIAcSpwR1Jva7RQBraQ</accountIdKey>
'           <accountMode>MARGIN</accountMode>
'           <accountDesc>INDIVIDUAL</accountDesc>
'           <accountName>Individual Brokerage</accountName>
'           <accountType>INDIVIDUAL</accountType>
'           <institutionType>BROKERAGE</institutionType>
'           <accountStatus>ACTIVE</accountStatus>
'           <closedDate>0</closedDate>
'        </Account>
'     </Accounts>
'  </AccountListResponse>

%>
</body>
</html>