(PowerShell) ETrade v1 List Accounts

List ETrade accounts using the ETrade v1 API.

Chilkat .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

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

$http = New-Object Chilkat.Http

$http.OAuth1 = $true
$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.
$json = New-Object Chilkat.JsonObject
$success = $json.LoadFile("qa_data/tokens/etrade.json")
if ($success -ne $true) {
    $("Failed to load OAuth1 token")
    exit
}

$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 -ne $true) {
    $($http.LastErrorText)
    exit
}

# A 200 status code indicates success.
$statusCode = $http.LastStatus
$("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...

$xml = New-Object Chilkat.Xml
$xml.LoadXml($respStr)

$i = 0
$count_i = $xml.NumChildrenHavingTag("Accounts|Account")
while ($i -lt $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
}

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