Delphi ActiveX Requires Chilkat v11.7.0+
Delphi ActiveX
Stripe: Find customer records by billing email
See more Stripe Examples
Find all customers with a given billing email, including addresses with a plus sign. Display the internal account reference so the operator can select the right record.
Stripe documentation and cURL example
Chilkat Delphi ActiveX Downloads
var
success: Integer;
apiKey: WideString;
curl: TChilkatHttpCurl;
cmd: TChilkatStringBuilder;
json: TChilkatJsonObject;
replaced: Integer;
email: TChilkatStringBuilder;
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);
email := TChilkatStringBuilder.Create(Self);
email.SetString('billing+east@example.com');
// Show every match so the operator can check the internal account reference.
pageSuffix := TChilkatStringBuilder.Create(Self);
more := 1;
cursor := '';
while (more = 1) do
begin
// curl -X GET "https://api.stripe.com/v1/customers?email={email}&limit=100" \
// -u "$STRIPE_API_KEY:" \
// -H "Stripe-Version: 2026-10-28.endive"
cmd.SetString('curl -X GET "https://api.stripe.com/v1/customers?email=@EMAIL@&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('@EMAIL@',email.GetEncoded('url_rfc3986','utf-8'));
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].name') + ' | ' + json.StringOf('data[i].email') + ' | ' + json.StringOf('data[i].metadata.account_ref'));
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;