Unicode C Requires Chilkat v11.7.0+
Unicode C
Stripe: Export a period of account activity
See more Stripe Examples
Export account activity for a UTC date range to CSV, including transaction references, fees, net amounts, and currencies.
Stripe documentation and cURL example
Chilkat Unicode C Downloads
#include <C_CkHttpCurlW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkCsvW.h>
void ChilkatSample(void)
{
BOOL success;
const wchar_t *apiKey;
HCkHttpCurlW curl;
HCkStringBuilderW cmd;
HCkJsonObjectW json;
int replaced;
const wchar_t *fromTime;
const wchar_t *untilTime;
HCkCsvW ledger;
int outputRow;
HCkStringBuilderW pageSuffix;
BOOL more;
const wchar_t *cursor;
int i;
int count;
const wchar_t *next;
success = FALSE;
// Requires an unlocked Chilkat bundle. See Global Unlock Sample.
// Supply a restricted sandbox key from merchant-controlled configuration.
apiKey = L"YOUR_STRIPE_TEST_KEY";
curl = CkHttpCurlW_Create();
cmd = CkStringBuilderW_Create();
json = CkJsonObjectW_Create();
// Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
fromTime = L"1790812800";
untilTime = L"1793491200";
ledger = CkCsvW_Create();
CkCsvW_putHasColumnNames(ledger,TRUE);
outputRow = 0;
CkCsvW_SetColumnName(ledger,0,L"id");
CkCsvW_SetColumnName(ledger,1,L"created");
CkCsvW_SetColumnName(ledger,2,L"source");
CkCsvW_SetColumnName(ledger,3,L"reporting_category");
CkCsvW_SetColumnName(ledger,4,L"amount");
CkCsvW_SetColumnName(ledger,5,L"fee");
CkCsvW_SetColumnName(ledger,6,L"net");
CkCsvW_SetColumnName(ledger,7,L"currency");
pageSuffix = CkStringBuilderW_Create();
more = TRUE;
cursor = L"";
while ((more == TRUE)) {
// curl -X GET "https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D={fromTime}&created%5Blt%5D={untilTime}&limit=100" \
// -u "$STRIPE_API_KEY:" \
// -H "Stripe-Version: 2026-10-28.endive"
CkStringBuilderW_SetString(cmd,L"curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"");
CkStringBuilderW_Append(cmd,L" -u \"@KEY@:\"");
CkStringBuilderW_Append(cmd,L" -H \"Stripe-Version: 2026-10-28.endive\"");
replaced = CkStringBuilderW_Replace(cmd,L"@CURSOR@",CkStringBuilderW_getAsString(pageSuffix));
replaced = CkStringBuilderW_Replace(cmd,L"@FROM@",fromTime);
replaced = CkStringBuilderW_Replace(cmd,L"@UNTIL@",untilTime);
replaced = CkStringBuilderW_Replace(cmd,L"@KEY@",apiKey);
success = CkHttpCurlW_DoYourThing(curl,CkStringBuilderW_getAsString(cmd));
if (success != TRUE) {
wprintf(L"No HTTP response. Chilkat failure code: %d\n",CkHttpCurlW_getFailReason(curl));
CkHttpCurlW_Dispose(curl);
CkStringBuilderW_Dispose(cmd);
CkJsonObjectW_Dispose(json);
CkCsvW_Dispose(ledger);
CkStringBuilderW_Dispose(pageSuffix);
return;
}
success = CkHttpCurlW_GetResponseJson(curl,json);
if ((CkHttpCurlW_getStatusCode(curl) != 200) || (success != TRUE)) {
wprintf(L"Stripe HTTP %d Request-Id: %s\n",CkHttpCurlW_getStatusCode(curl),CkHttpCurlW_getResponseHeaderField(curl,L"Request-Id"));
if (success == TRUE) {
wprintf(L"%s\n",CkJsonObjectW_stringOf(json,L"error.message"));
}
CkHttpCurlW_Dispose(curl);
CkStringBuilderW_Dispose(cmd);
CkJsonObjectW_Dispose(json);
CkCsvW_Dispose(ledger);
CkStringBuilderW_Dispose(pageSuffix);
return;
}
i = 0;
count = CkJsonObjectW_SizeOfArray(json,L"data");
while ((i < count)) {
CkJsonObjectW_putI(json,i);
CkCsvW_SetCell(ledger,outputRow,0,CkJsonObjectW_stringOf(json,L"data[i].id"));
CkCsvW_SetCell(ledger,outputRow,1,CkJsonObjectW_stringOf(json,L"data[i].created"));
CkCsvW_SetCell(ledger,outputRow,2,CkJsonObjectW_stringOf(json,L"data[i].source"));
CkCsvW_SetCell(ledger,outputRow,3,CkJsonObjectW_stringOf(json,L"data[i].reporting_category"));
CkCsvW_SetCell(ledger,outputRow,4,CkJsonObjectW_stringOf(json,L"data[i].amount"));
CkCsvW_SetCell(ledger,outputRow,5,CkJsonObjectW_stringOf(json,L"data[i].fee"));
CkCsvW_SetCell(ledger,outputRow,6,CkJsonObjectW_stringOf(json,L"data[i].net"));
CkCsvW_SetCell(ledger,outputRow,7,CkJsonObjectW_stringOf(json,L"data[i].currency"));
outputRow = outputRow + 1;
i = i + 1;
}
more = CkJsonObjectW_BoolOf(json,L"has_more");
if (more == TRUE) {
next = CkJsonObjectW_stringOf(json,L"data[i].id");
if ((count < 1) || (next == L"") || (next == cursor)) {
wprintf(L"Invalid pagination cursor.\n");
CkHttpCurlW_Dispose(curl);
CkStringBuilderW_Dispose(cmd);
CkJsonObjectW_Dispose(json);
CkCsvW_Dispose(ledger);
CkStringBuilderW_Dispose(pageSuffix);
return;
}
cursor = next;
CkStringBuilderW_SetString(pageSuffix,L"&starting_after=");
CkStringBuilderW_Append(pageSuffix,cursor);
}
}
success = CkCsvW_SaveFile(ledger,L"stripe-balance-transactions.csv");
if (success == FALSE) {
wprintf(L"%s\n",CkCsvW_lastErrorText(ledger));
CkHttpCurlW_Dispose(curl);
CkStringBuilderW_Dispose(cmd);
CkJsonObjectW_Dispose(json);
CkCsvW_Dispose(ledger);
CkStringBuilderW_Dispose(pageSuffix);
return;
}
wprintf(L"Exported rows: %d\n",outputRow);
CkHttpCurlW_Dispose(curl);
CkStringBuilderW_Dispose(cmd);
CkJsonObjectW_Dispose(json);
CkCsvW_Dispose(ledger);
CkStringBuilderW_Dispose(pageSuffix);
}