Delphi ActiveX Requires Chilkat v11.7.0+
Delphi ActiveX
Stripe: Review invoices and outstanding amounts
See more Stripe Examples
List open invoices for a billing account and show outstanding amounts, due dates, and invoice links.
Stripe documentation and cURL example
Chilkat Delphi ActiveX Downloads
var
success: Integer;
apiKey: WideString;
curl: TChilkatHttpCurl;
cmd: TChilkatStringBuilder;
json: TChilkatJsonObject;
replaced: Integer;
customerId: WideString;
pageSuffix: TChilkatStringBuilder;
more: Integer;
cursor: WideString;
i: Integer;
count: Integer;
next: WideString;
begin
success := 0;
// Requires an unlocked Chilkat bundle. See Global Unlock Sample.
// Supply a restricted sandbox key from merchant-controlled configuration.
apiKey := 'YOUR_STRIPE_TEST_KEY';
curl := TChilkatHttpCurl.Create(Self);
cmd := TChilkatStringBuilder.Create(Self);
json := TChilkatJsonObject.Create(Self);
customerId := 'cus_FROM_BILLING_ACCOUNT';
// Remove status=open to show all invoice states.
pageSuffix := TChilkatStringBuilder.Create(Self);
more := 1;
cursor := '';
while (more = 1) do
begin
// curl -X GET "https://api.stripe.com/v1/invoices?customer={customerId}&status=open&limit=100" \
// -u "$STRIPE_API_KEY:" \
// -H "Stripe-Version: 2026-10-28.endive"
cmd.SetString('curl -X GET "https://api.stripe.com/v1/invoices?customer=@CUSTOMER@&status=open&limit=100@CURSOR@"');
cmd.Append(' -u "@KEY@:"');
cmd.Append(' -H "Stripe-Version: 2026-10-28.endive"');
replaced := cmd.Replace('@CURSOR@',pageSuffix.GetAsString());
replaced := cmd.Replace('@CUSTOMER@',customerId);
replaced := cmd.Replace('@KEY@',apiKey);
success := curl.DoYourThing(cmd.GetAsString());
if (success <> 1) then
begin
Memo1.Lines.Add('No HTTP response. Chilkat failure code: ' + IntToStr(curl.FailReason));
Exit;
end;
success := curl.GetResponseJson(json.ControlInterface);
if ((curl.StatusCode <> 200) or (success <> 1)) then
begin
Memo1.Lines.Add('Stripe HTTP ' + IntToStr(curl.StatusCode) + ' Request-Id: ' + curl.GetResponseHeaderField('Request-Id'));
if (success = 1) then
begin
Memo1.Lines.Add(json.StringOf('error.message'));
end;
Exit;
end;
i := 0;
count := json.SizeOfArray('data');
while (i < count) do
begin
json.I := i;
Memo1.Lines.Add(json.StringOf('data[i].id') + ' | ' + json.StringOf('data[i].number') + ' | ' + json.StringOf('data[i].status') + ' | ' + json.StringOf('data[i].due_date')
+ ' | ' + json.StringOf('data[i].amount_remaining') + ' | ' + json.StringOf('data[i].currency') + ' | ' + json.StringOf('data[i].hosted_invoice_url') + ' | ' + json.StringOf('data[i].invoice_pdf'));
i := i + 1;
end;
more := json.BoolOf('has_more');
if (more = 1) then
begin
next := json.StringOf('data[i].id');
if ((count < 1) or (next = '') or (next = cursor)) then
begin
Memo1.Lines.Add('Invalid pagination cursor.');
Exit;
end;
cursor := next;
pageSuffix.SetString('&starting_after=');
pageSuffix.Append(cursor);
end;
end;