Unicode C Requires Chilkat v11.0.0+
Unicode C
Schwab: Export account transactions to CSV
See more Schwab Examples
Exports the last seven days of trades, dividends, and interest for one account. Each UTF-8 CSV row represents an activity, including its signed net amount. The file is replaced on each run. For incremental imports, key records by account and activityId so overlapping date windows do not duplicate entries. If a window returns the 3,000-transaction maximum, split it before treating it as complete.
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.
Chilkat Unicode C Downloads
#include <C_CkSecretsW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkHttpW.h>
#include <C_CkDateTimeW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkHttpResponseW.h>
#include <C_CkHttpRequestW.h>
#include <C_CkJsonArrayW.h>
#include <C_CkCsvW.h>
void ChilkatSample(void)
{
BOOL success;
HCkSecretsW vault;
HCkJsonObjectW entry;
HCkJsonObjectW tokens;
const wchar_t *accessToken;
HCkHttpW http;
HCkJsonObjectW selection;
const wchar_t *accountHash;
HCkDateTimeW clock;
HCkStringBuilderW endTime;
int replacements;
HCkStringBuilderW startTime;
HCkHttpResponseW resp;
HCkHttpRequestW query;
HCkJsonArrayW activity;
HCkCsvW csv;
HCkJsonObjectW row;
int i;
success = FALSE;
// Assumes Chilkat is unlocked. See Global Unlock Sample.
success = FALSE;
vault = CkSecretsW_Create();
CkSecretsW_putLocation(vault,L"local_manager");
CkSecretsW_putAutoSplit(vault,TRUE);
entry = CkJsonObjectW_Create();
CkJsonObjectW_UpdateString(entry,L"appName",L"SchwabTrader");
CkJsonObjectW_UpdateString(entry,L"service",L"OAuth2");
CkJsonObjectW_UpdateString(entry,L"username",L"personal-desktop");
tokens = CkJsonObjectW_Create();
success = CkSecretsW_GetSecretJson(vault,entry,tokens);
if (success != TRUE) {
wprintf(L"Could not read the token record. Check the store and complete desktop authorization first.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
return;
}
accessToken = CkJsonObjectW_stringOf(tokens,L"access_token");
if (accessToken == L"") {
wprintf(L"Run the Schwab authorization or refresh example to save an access token.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
return;
}
http = CkHttpW_Create();
CkHttpW_putRequireSslCertVerify(http,TRUE);
CkHttpW_putAuthToken(http,accessToken);
// Read the hash saved by the authorized-account selection example.
CkJsonObjectW_UpdateString(entry,L"service",L"SelectedAccount");
selection = CkJsonObjectW_Create();
success = CkSecretsW_GetSecretJson(vault,entry,selection);
accountHash = CkJsonObjectW_stringOf(selection,L"hashValue");
if ((success != TRUE) || (accountHash == L"")) {
wprintf(L"Select an authorized account first.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
return;
}
CkHttpW_SetUrlVar(http,L"account",accountHash);
// Use UTC endpoints for a rolling seven-day window.
clock = CkDateTimeW_Create();
CkDateTimeW_SetFromCurrentSystemTime(clock);
endTime = CkStringBuilderW_Create();
CkStringBuilderW_Append(endTime,CkDateTimeW_getAsTimestamp(clock,FALSE));
replacements = CkStringBuilderW_Replace(endTime,L"Z",L".000Z");
CkDateTimeW_AddDays(clock,-7);
startTime = CkStringBuilderW_Create();
CkStringBuilderW_Append(startTime,CkDateTimeW_getAsTimestamp(clock,FALSE));
replacements = CkStringBuilderW_Replace(startTime,L"Z",L".000Z");
resp = CkHttpResponseW_Create();
query = CkHttpRequestW_Create();
CkHttpRequestW_putHttpVerb(query,L"GET");
CkHttpRequestW_AddParam(query,L"startDate",CkStringBuilderW_getAsString(startTime));
CkHttpRequestW_AddParam(query,L"endDate",CkStringBuilderW_getAsString(endTime));
CkHttpRequestW_AddParam(query,L"types",L"TRADE,DIVIDEND_OR_INTEREST");
success = CkHttpW_HttpReq(http,L"https://api.schwabapi.com/trader/v1/accounts/{$account}/transactions",query,resp);
if ((success != TRUE) || (CkHttpResponseW_getStatusCode(resp) != 200)) {
if (CkHttpResponseW_getStatusCode(resp) == 0) {
wprintf(L"No HTTP response. Check connectivity.\n");
}
else {
wprintf(L"Schwab returned HTTP %d\n",CkHttpResponseW_getStatusCode(resp));
if (CkHttpResponseW_getStatusCode(resp) == 401) {
wprintf(L"Refresh the access token or repeat desktop authorization.\n");
}
}
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
CkDateTimeW_Dispose(clock);
CkStringBuilderW_Dispose(endTime);
CkStringBuilderW_Dispose(startTime);
CkHttpResponseW_Dispose(resp);
CkHttpRequestW_Dispose(query);
return;
}
activity = CkJsonArrayW_Create();
success = CkJsonArrayW_Load(activity,CkHttpResponseW_bodyStr(resp));
if (success != TRUE) {
wprintf(L"Schwab returned unexpected JSON.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
CkDateTimeW_Dispose(clock);
CkStringBuilderW_Dispose(endTime);
CkStringBuilderW_Dispose(startTime);
CkHttpResponseW_Dispose(resp);
CkHttpRequestW_Dispose(query);
CkJsonArrayW_Dispose(activity);
return;
}
if (CkJsonArrayW_getSize(activity) >= 3000) {
wprintf(L"The response reached the transaction limit. Export smaller time windows.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
CkDateTimeW_Dispose(clock);
CkStringBuilderW_Dispose(endTime);
CkStringBuilderW_Dispose(startTime);
CkHttpResponseW_Dispose(resp);
CkHttpRequestW_Dispose(query);
CkJsonArrayW_Dispose(activity);
return;
}
csv = CkCsvW_Create();
CkCsvW_SetColumnName(csv,0,L"activityId");
CkCsvW_SetColumnName(csv,1,L"time");
CkCsvW_SetColumnName(csv,2,L"type");
CkCsvW_SetColumnName(csv,3,L"tradeDate");
CkCsvW_SetColumnName(csv,4,L"settlementDate");
CkCsvW_SetColumnName(csv,5,L"netAmount");
row = CkJsonObjectW_Create();
i = 0;
while ((i < CkJsonArrayW_getSize(activity))) {
CkJsonArrayW_ObjectAt2(activity,i,row);
// Keep identifiers and decimal amounts as returned by Schwab.
CkCsvW_SetCell(csv,i,0,CkJsonObjectW_stringOf(row,L"activityId"));
CkCsvW_SetCell(csv,i,1,CkJsonObjectW_stringOf(row,L"time"));
CkCsvW_SetCell(csv,i,2,CkJsonObjectW_stringOf(row,L"type"));
CkCsvW_SetCell(csv,i,3,CkJsonObjectW_stringOf(row,L"tradeDate"));
CkCsvW_SetCell(csv,i,4,CkJsonObjectW_stringOf(row,L"settlementDate"));
CkCsvW_SetCell(csv,i,5,CkJsonObjectW_stringOf(row,L"netAmount"));
i = i + 1;
}
success = CkCsvW_SaveFile2(csv,L"schwab-transactions.csv",L"utf-8");
if (success != TRUE) {
wprintf(L"Could not write schwab-transactions.csv.\n");
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
CkDateTimeW_Dispose(clock);
CkStringBuilderW_Dispose(endTime);
CkStringBuilderW_Dispose(startTime);
CkHttpResponseW_Dispose(resp);
CkHttpRequestW_Dispose(query);
CkJsonArrayW_Dispose(activity);
CkCsvW_Dispose(csv);
CkJsonObjectW_Dispose(row);
return;
}
wprintf(L"Wrote %d rows to schwab-transactions.csv.\n",CkCsvW_getNumRows(csv));
CkSecretsW_Dispose(vault);
CkJsonObjectW_Dispose(entry);
CkJsonObjectW_Dispose(tokens);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(selection);
CkDateTimeW_Dispose(clock);
CkStringBuilderW_Dispose(endTime);
CkStringBuilderW_Dispose(startTime);
CkHttpResponseW_Dispose(resp);
CkHttpRequestW_Dispose(query);
CkJsonArrayW_Dispose(activity);
CkCsvW_Dispose(csv);
CkJsonObjectW_Dispose(row);
}