Xojo Plugin

ETrade v1 List Orders

See more HTTP Misc Examples

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

Dim success As Boolean
success = False

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

Dim http As New 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.
Dim json As New Chilkat.JsonObject
success = json.LoadFile("qa_data/tokens/etrade.json")
If (success <> True) Then
    System.DebugLog("Failed to load OAuth1 token")
    Return
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")
Dim respStr As String
respStr = http.QuickGetStr("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/orders?securityType=EQ&count=100")
If (http.LastMethodSuccess <> True) Then
    System.DebugLog(http.LastErrorText)
    Return
End If

// A 200 status code indicates success.
Dim statusCode As Int32
statusCode = http.LastStatus
System.DebugLog("statusCode = " + Str(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...

Dim xml As New Chilkat.Xml
success = xml.LoadXml(respStr)

Dim i As Int32
Dim count_i As Int32
Dim tagPath As String
Dim orderId As Int32
Dim details As String
Dim orderType As String
Dim OrderDetail As String

i = 0
count_i = xml.NumChildrenHavingTag("Order")
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
Wend

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