Sample code for 30+ languages & platforms
Delphi DLL 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 Delphi DLL Downloads

Delphi DLL
var
success: Boolean;
vault: HCkSecrets;
entry: HCkJsonObject;
tokens: HCkJsonObject;
accessToken: PWideChar;
http: HCkHttp;
selection: HCkJsonObject;
accountHash: PWideChar;
clock: HCkDateTime;
endTime: HCkStringBuilder;
replacements: Integer;
startTime: HCkStringBuilder;
statusFilter: PWideChar;
resp: HCkHttpResponse;
query: HCkHttpRequest;
orders: HCkJsonArray;
order: HCkJsonObject;
i: Integer;

begin
success := False;

//  Assumes Chilkat is unlocked. See Global Unlock Sample.
success := False;

vault := CkSecrets_Create();
CkSecrets_putLocation(vault,'local_manager');
CkSecrets_putAutoSplit(vault,True);
entry := CkJsonObject_Create();
CkJsonObject_UpdateString(entry,'appName','SchwabTrader');
CkJsonObject_UpdateString(entry,'service','OAuth2');
CkJsonObject_UpdateString(entry,'username','personal-desktop');
tokens := CkJsonObject_Create();
success := CkSecrets_GetSecretJson(vault,entry,tokens);
if (success <> True) then
  begin
    Memo1.Lines.Add('Could not read the token record. Check the store and complete desktop authorization first.');
    Exit;
  end;
accessToken := CkJsonObject__stringOf(tokens,'access_token');
if (accessToken = '') then
  begin
    Memo1.Lines.Add('Run the Schwab authorization or refresh example to save an access token.');
    Exit;
  end;
http := CkHttp_Create();
CkHttp_putRequireSslCertVerify(http,True);
CkHttp_putAuthToken(http,accessToken);

//  Read the hash saved by the authorized-account selection example.
CkJsonObject_UpdateString(entry,'service','SelectedAccount');
selection := CkJsonObject_Create();
success := CkSecrets_GetSecretJson(vault,entry,selection);
accountHash := CkJsonObject__stringOf(selection,'hashValue');
if ((success <> True) or (accountHash = '')) then
  begin
    Memo1.Lines.Add('Select an authorized account first.');
    Exit;
  end;
CkHttp_SetUrlVar(http,'account',accountHash);

//  Use UTC endpoints for a rolling seven-day window.
clock := CkDateTime_Create();
CkDateTime_SetFromCurrentSystemTime(clock);
endTime := CkStringBuilder_Create();
CkStringBuilder_Append(endTime,CkDateTime__getAsTimestamp(clock,False));
replacements := CkStringBuilder_Replace(endTime,'Z','.000Z');
CkDateTime_AddDays(clock,-7);
startTime := CkStringBuilder_Create();
CkStringBuilder_Append(startTime,CkDateTime__getAsTimestamp(clock,False));
replacements := CkStringBuilder_Replace(startTime,'Z','.000Z');
statusFilter := '';
resp := CkHttpResponse_Create();
query := CkHttpRequest_Create();
CkHttpRequest_putHttpVerb(query,'GET');
CkHttpRequest_AddParam(query,'fromEnteredTime',CkStringBuilder__getAsString(startTime));
CkHttpRequest_AddParam(query,'toEnteredTime',CkStringBuilder__getAsString(endTime));
CkHttpRequest_AddParam(query,'maxResults','100');
if (statusFilter <> '') then
  begin
    CkHttpRequest_AddParam(query,'status',statusFilter);
  end;
success := CkHttp_HttpReq(http,'https://api.schwabapi.com/trader/v1/accounts/{$account}/orders',query,resp);
if ((success <> True) or (CkHttpResponse_getStatusCode(resp) <> 200)) then
  begin
    if (CkHttpResponse_getStatusCode(resp) = 0) then
      begin
        Memo1.Lines.Add('No HTTP response. Check connectivity.');
      end
    else
      begin
        Memo1.Lines.Add('Schwab returned HTTP ' + IntToStr(CkHttpResponse_getStatusCode(resp)));
        if (CkHttpResponse_getStatusCode(resp) = 401) then
          begin
            Memo1.Lines.Add('Refresh the access token or repeat desktop authorization.');
          end;
      end;
    Exit;
  end;
orders := CkJsonArray_Create();
success := CkJsonArray_Load(orders,CkHttpResponse__bodyStr(resp));
if (success <> True) then
  begin
    Memo1.Lines.Add('Schwab returned unexpected JSON.');
    Exit;
  end;

if (CkJsonArray_getSize(orders) = 0) then
  begin
    Memo1.Lines.Add('No matching orders entered during this interval.');
  end;
if (CkJsonArray_getSize(orders) = 100) then
  begin
    Memo1.Lines.Add('Reached maxResults. Narrow the interval to check for additional orders.');
  end;
order := CkJsonObject_Create();
i := 0;
while (i < CkJsonArray_getSize(orders)) do
  begin
    CkJsonArray_ObjectAt2(orders,i,order);
    Memo1.Lines.Add('Order ' + CkJsonObject__stringOf(order,'orderId') + '  ' + CkJsonObject__stringOf(order,'enteredTime') + '  ' + CkJsonObject__stringOf(order,'orderType')
         + '  ' + CkJsonObject__stringOf(order,'status'));
    Memo1.Lines.Add('  filled ' + CkJsonObject__stringOf(order,'filledQuantity') + '  remaining ' + CkJsonObject__stringOf(order,'remainingQuantity'));
    i := i + 1;
  end;

CkSecrets_Dispose(vault);
CkJsonObject_Dispose(entry);
CkJsonObject_Dispose(tokens);
CkHttp_Dispose(http);
CkJsonObject_Dispose(selection);
CkDateTime_Dispose(clock);
CkStringBuilder_Dispose(endTime);
CkStringBuilder_Dispose(startTime);
CkHttpResponse_Dispose(resp);
CkHttpRequest_Dispose(query);
CkJsonArray_Dispose(orders);
CkJsonObject_Dispose(order);