Sample code for 30+ languages & platforms
Classic ASP Requires Chilkat v11.0.0+

Schwab: List recent orders for one account

See more Schwab Examples

Lists orders entered in the last seven days, with an optional status filter such as WORKING. Shows the order ID, entry time, status, filled quantity, and remaining quantity. Select an ID from the results for the order detail and fills example. An older order can still be working outside this entry-time window.

Use the access token saved by desktop authorization. First select the authorized account whose data you want to use. Use the same Chilkat Secrets store as the OAuth example.

Schwab API specification

Chilkat Classic ASP Downloads

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

'  Assumes Chilkat is unlocked. See Global Unlock Sample.
success = 0

set vault = Server.CreateObject("Chilkat.Secrets")
vault.Location = "local_manager"
vault.AutoSplit = 1
set entry = Server.CreateObject("Chilkat.JsonObject")
success = entry.UpdateString("appName","SchwabTrader")
success = entry.UpdateString("service","OAuth2")
success = entry.UpdateString("username","personal-desktop")
set tokens = Server.CreateObject("Chilkat.JsonObject")
success = vault.GetSecretJson(entry,tokens)
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Could not read the token record. Check the store and complete desktop authorization first.") & "</pre>"
    Response.End
End If

accessToken = tokens.StringOf("access_token")
If (accessToken = "") Then
    Response.Write "<pre>" & Server.HTMLEncode( "Run the Schwab authorization or refresh example to save an access token.") & "</pre>"
    Response.End
End If

set http = Server.CreateObject("Chilkat.Http")
http.RequireSslCertVerify = 1
http.AuthToken = accessToken

'  Read the hash saved by the authorized-account selection example.
success = entry.UpdateString("service","SelectedAccount")
set selection = Server.CreateObject("Chilkat.JsonObject")
success = vault.GetSecretJson(entry,selection)
accountHash = selection.StringOf("hashValue")
If ((success <> 1) Or (accountHash = "")) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Select an authorized account first.") & "</pre>"
    Response.End
End If

success = http.SetUrlVar("account",accountHash)

'  Use UTC endpoints for a rolling seven-day window.
set clock = Server.CreateObject("Chilkat.CkDateTime")
success = clock.SetFromCurrentSystemTime()
set endTime = Server.CreateObject("Chilkat.StringBuilder")
success = endTime.Append(clock.GetAsTimestamp(0))
replacements = endTime.Replace("Z",".000Z")
success = clock.AddDays(-7)
set startTime = Server.CreateObject("Chilkat.StringBuilder")
success = startTime.Append(clock.GetAsTimestamp(0))
replacements = startTime.Replace("Z",".000Z")
statusFilter = ""
set resp = Server.CreateObject("Chilkat.HttpResponse")
set query = Server.CreateObject("Chilkat.HttpRequest")
query.HttpVerb = "GET"
query.AddParam "fromEnteredTime",startTime.GetAsString()
query.AddParam "toEnteredTime",endTime.GetAsString()
query.AddParam "maxResults","100"
If (statusFilter <> "") Then
    query.AddParam "status",statusFilter
End If

success = http.HttpReq("https://api.schwabapi.com/trader/v1/accounts/{$account}/orders",query,resp)
If ((success <> 1) Or (resp.StatusCode <> 200)) Then
    If (resp.StatusCode = 0) Then
        Response.Write "<pre>" & Server.HTMLEncode( "No HTTP response. Check connectivity.") & "</pre>"
    Else
        Response.Write "<pre>" & Server.HTMLEncode( "Schwab returned HTTP " & resp.StatusCode) & "</pre>"
        If (resp.StatusCode = 401) Then
            Response.Write "<pre>" & Server.HTMLEncode( "Refresh the access token or repeat desktop authorization.") & "</pre>"
        End If

    End If

    Response.End
End If

set orders = Server.CreateObject("Chilkat.JsonArray")
success = orders.Load(resp.BodyStr)
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Schwab returned unexpected JSON.") & "</pre>"
    Response.End
End If

If (orders.Size = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( "No matching orders entered during this interval.") & "</pre>"
End If

If (orders.Size = 100) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Reached maxResults. Narrow the interval to check for additional orders.") & "</pre>"
End If

set order = Server.CreateObject("Chilkat.JsonObject")
i = 0
Do While (i < orders.Size)
    success = orders.ObjectAt2(i,order)
    Response.Write "<pre>" & Server.HTMLEncode( "Order " & order.StringOf("orderId") & "  " & order.StringOf("enteredTime") & "  " & order.StringOf("orderType") & "  " _
         & order.StringOf("status")) & "</pre>"
    Response.Write "<pre>" & Server.HTMLEncode( "  filled " & order.StringOf("filledQuantity") & "  remaining " & order.StringOf("remainingQuantity")) & "</pre>"
    i = i + 1
Loop

%>
</body>
</html>