C Requires Chilkat v11.7.0+
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 C Downloads
#include <C_CkHttpCurl.h>
#include <C_CkStringBuilder.h>
#include <C_CkJsonObject.h>
#include <C_CkCsv.h>
void ChilkatSample(void)
{
BOOL success;
const char *apiKey;
HCkHttpCurl curl;
HCkStringBuilder cmd;
HCkJsonObject json;
int replaced;
const char *fromTime;
const char *untilTime;
HCkCsv ledger;
int outputRow;
HCkStringBuilder pageSuffix;
BOOL more;
const char *cursor;
int i;
int count;
const char *next;
success = FALSE;
// Requires an unlocked Chilkat bundle. See Global Unlock Sample.
// Supply a restricted sandbox key from merchant-controlled configuration.
apiKey = "YOUR_STRIPE_TEST_KEY";
curl = CkHttpCurl_Create();
cmd = CkStringBuilder_Create();
json = CkJsonObject_Create();
// Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
fromTime = "1790812800";
untilTime = "1793491200";
ledger = CkCsv_Create();
CkCsv_putHasColumnNames(ledger,TRUE);
outputRow = 0;
CkCsv_SetColumnName(ledger,0,"id");
CkCsv_SetColumnName(ledger,1,"created");
CkCsv_SetColumnName(ledger,2,"source");
CkCsv_SetColumnName(ledger,3,"reporting_category");
CkCsv_SetColumnName(ledger,4,"amount");
CkCsv_SetColumnName(ledger,5,"fee");
CkCsv_SetColumnName(ledger,6,"net");
CkCsv_SetColumnName(ledger,7,"currency");
pageSuffix = CkStringBuilder_Create();
more = TRUE;
cursor = "";
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"
CkStringBuilder_SetString(cmd,"curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"");
CkStringBuilder_Append(cmd," -u \"@KEY@:\"");
CkStringBuilder_Append(cmd," -H \"Stripe-Version: 2026-10-28.endive\"");
replaced = CkStringBuilder_Replace(cmd,"@CURSOR@",CkStringBuilder_getAsString(pageSuffix));
replaced = CkStringBuilder_Replace(cmd,"@FROM@",fromTime);
replaced = CkStringBuilder_Replace(cmd,"@UNTIL@",untilTime);
replaced = CkStringBuilder_Replace(cmd,"@KEY@",apiKey);
success = CkHttpCurl_DoYourThing(curl,CkStringBuilder_getAsString(cmd));
if (success != TRUE) {
printf("No HTTP response. Chilkat failure code: %d\n",CkHttpCurl_getFailReason(curl));
CkHttpCurl_Dispose(curl);
CkStringBuilder_Dispose(cmd);
CkJsonObject_Dispose(json);
CkCsv_Dispose(ledger);
CkStringBuilder_Dispose(pageSuffix);
return;
}
success = CkHttpCurl_GetResponseJson(curl,json);
if ((CkHttpCurl_getStatusCode(curl) != 200) || (success != TRUE)) {
printf("Stripe HTTP %d Request-Id: %s\n",CkHttpCurl_getStatusCode(curl),CkHttpCurl_getResponseHeaderField(curl,"Request-Id"));
if (success == TRUE) {
printf("%s\n",CkJsonObject_stringOf(json,"error.message"));
}
CkHttpCurl_Dispose(curl);
CkStringBuilder_Dispose(cmd);
CkJsonObject_Dispose(json);
CkCsv_Dispose(ledger);
CkStringBuilder_Dispose(pageSuffix);
return;
}
i = 0;
count = CkJsonObject_SizeOfArray(json,"data");
while ((i < count)) {
CkJsonObject_putI(json,i);
CkCsv_SetCell(ledger,outputRow,0,CkJsonObject_stringOf(json,"data[i].id"));
CkCsv_SetCell(ledger,outputRow,1,CkJsonObject_stringOf(json,"data[i].created"));
CkCsv_SetCell(ledger,outputRow,2,CkJsonObject_stringOf(json,"data[i].source"));
CkCsv_SetCell(ledger,outputRow,3,CkJsonObject_stringOf(json,"data[i].reporting_category"));
CkCsv_SetCell(ledger,outputRow,4,CkJsonObject_stringOf(json,"data[i].amount"));
CkCsv_SetCell(ledger,outputRow,5,CkJsonObject_stringOf(json,"data[i].fee"));
CkCsv_SetCell(ledger,outputRow,6,CkJsonObject_stringOf(json,"data[i].net"));
CkCsv_SetCell(ledger,outputRow,7,CkJsonObject_stringOf(json,"data[i].currency"));
outputRow = outputRow + 1;
i = i + 1;
}
more = CkJsonObject_BoolOf(json,"has_more");
if (more == TRUE) {
next = CkJsonObject_stringOf(json,"data[i].id");
if ((count < 1) || (next == "") || (next == cursor)) {
printf("Invalid pagination cursor.\n");
CkHttpCurl_Dispose(curl);
CkStringBuilder_Dispose(cmd);
CkJsonObject_Dispose(json);
CkCsv_Dispose(ledger);
CkStringBuilder_Dispose(pageSuffix);
return;
}
cursor = next;
CkStringBuilder_SetString(pageSuffix,"&starting_after=");
CkStringBuilder_Append(pageSuffix,cursor);
}
}
success = CkCsv_SaveFile(ledger,"stripe-balance-transactions.csv");
if (success == FALSE) {
printf("%s\n",CkCsv_lastErrorText(ledger));
CkHttpCurl_Dispose(curl);
CkStringBuilder_Dispose(cmd);
CkJsonObject_Dispose(json);
CkCsv_Dispose(ledger);
CkStringBuilder_Dispose(pageSuffix);
return;
}
printf("Exported rows: %d\n",outputRow);
CkHttpCurl_Dispose(curl);
CkStringBuilder_Dispose(cmd);
CkJsonObject_Dispose(json);
CkCsv_Dispose(ledger);
CkStringBuilder_Dispose(pageSuffix);
}