Sample code for 30+ languages & platforms
Delphi ActiveX Requires Chilkat v11.7.0+

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

Delphi ActiveX
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;