(VBScript) ETrade List Accounts

Returns a list of E*TRADE accounts for the current user.

For more information, see https://apisb.etrade.com/docs/api/account/api-account-v1.html

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This 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 = 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 Authorization
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/etrade.json")
If (success <> 1) Then
    outFile.WriteLine("Failed to load OAuth1 token")
    WScript.Quit
End If

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

sandboxUrl = "https://apisb.etrade.com/v1/accounts/list"
liveUrl = "https://api.etrade.com/v1/accounts/list"

' resp is a Chilkat.HttpResponse
Set resp = http.QuickGetObj(sandboxUrl)
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' Make sure a successful response was received.
If (resp.StatusCode >= 300) Then
    outFile.WriteLine(resp.StatusLine)
    outFile.WriteLine(resp.Header)
    outFile.WriteLine(resp.BodyStr)
    WScript.Quit
End If

If (resp.StatusCode = 204) Then
    outFile.WriteLine("No records available.")
    WScript.Quit
End If

' 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" standalone="yes"?>
' <AccountListResponse>
'     <Accounts>
'         <Account>
'             <accountId>82314598</accountId>
'             <accountIdKey>dBZOKt9xDrtRSAOl4MSiiA</accountIdKey>
'             <accountMode>IRA</accountMode>
'             <accountDesc>Brokerage</accountDesc>
'             <accountName>NickName-1</accountName>
'             <accountType>MARGIN</accountType>
'             <institutionType>BROKERAGE</institutionType>
'             <accountStatus>ACTIVE</accountStatus>
'             <closedDate>0</closedDate>
'         </Account>
'         <Account>
'             <accountId>58315636</accountId>
'             <accountIdKey>vQMsebA1H5WltUfDkJP48g</accountIdKey>
'             <accountMode>BROKERAGE</accountMode>
'             <accountDesc>Complete Savings</accountDesc>
'             <accountName>NickName-2</accountName>
'             <accountType>INDIVIDUAL</accountType>
'             <institutionType>BROKERAGE</institutionType>
'             <accountStatus>ACTIVE</accountStatus>
'             <closedDate>0</closedDate>
'         </Account>
'         <Account>
'             <accountId>70700418</accountId>
'             <accountIdKey>6_Dpy0rmuQ9cu9IbTfvF2A</accountIdKey>
'             <accountMode>CASH</accountMode>
'             <accountDesc>INDIVIDUAL</accountDesc>
'             <accountName>NickName-3</accountName>
'             <accountType>INDIVIDUAL</accountType>
'             <institutionType>BROKERAGE</institutionType>
'             <accountStatus>ACTIVE</accountStatus>
'             <closedDate>0</closedDate>
'         </Account>
'         <Account>
'             <accountId>83515143</accountId>
'             <accountIdKey>xj1Dc18FTqWPqkEEVUr5rw</accountIdKey>
'             <accountMode>CASH</accountMode>
'             <accountDesc>INDIVIDUAL</accountDesc>
'             <accountName/>
'             <accountType>CASH</accountType>
'             <institutionType>BROKERAGE</institutionType>
'             <accountStatus>CLOSED</accountStatus>
'             <closedDate>1521027780</closedDate>
' 
'         </Account>
'     </Accounts>
' </AccountListResponse>

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = CreateObject("Chilkat.Xml")
success = xml.LoadXml(resp.BodyStr)
outFile.WriteLine(xml.GetXml())

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

outFile.WriteLine("Success.")

outFile.Close