(PowerShell) ETrade v1 List Orders

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

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.

$http.SetUrlVar("accountIdKey","vsnhtF7d9jXxBy6HyaAC4vQ")
$respStr = $http.QuickGetStr("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/orders?securityType=EQ&count=100")
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("Order")
while ($i -lt $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
}

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