Sample code for 30+ languages & platforms
Xojo Plugin 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 Xojo Plugin Downloads

Xojo Plugin
Dim success As Boolean
success = False

//  Requires an unlocked Chilkat bundle. See Global Unlock Sample.
//  Supply a restricted sandbox key from merchant-controlled configuration.
Dim apiKey As String
apiKey = "YOUR_STRIPE_TEST_KEY"

Dim curl As New Chilkat.HttpCurl
Dim cmd As New Chilkat.StringBuilder
Dim json As New Chilkat.JsonObject

Dim replaced As Int32

Dim email As New Chilkat.StringBuilder
success = email.SetString("billing+east@example.com")

//  Show every match so the operator can check the internal account reference.

Dim pageSuffix As New Chilkat.StringBuilder
Dim more As Boolean
more = True
Dim cursor As String
cursor = ""
While (more = True)
    //  curl -X GET "https://api.stripe.com/v1/customers?email={email}&limit=100" \
    //    -u "$STRIPE_API_KEY:" \
    //    -H "Stripe-Version: 2026-10-28.endive"
    success = cmd.SetString("curl -X GET ""https://api.stripe.com/v1/customers?email=@EMAIL@&limit=100@CURSOR@""")
    success = cmd.Append(" -u ""@KEY@:""")
    success = 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 <> True) Then
        System.DebugLog("No HTTP response. Chilkat failure code: " + Str(curl.FailReason))
        Return
    End If

    success = curl.GetResponseJson(json)
    If ((curl.StatusCode <> 200) Or (success <> True)) Then
        System.DebugLog("Stripe HTTP " + Str(curl.StatusCode) + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
        If (success = True) Then
            System.DebugLog(json.StringOf("error.message"))
        End If

        Return
    End If

    Dim i As Int32
    i = 0
    Dim count As Int32
    count = json.SizeOfArray("data")
    While (i < count)
        json.I = i
        System.DebugLog(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
    Wend
    more = json.BoolOf("has_more")
    If (more = True) Then
        Dim next As String
        next = json.StringOf("data[i].id")
        If ((count < 1) Or (next = "") Or (next = cursor)) Then
            System.DebugLog("Invalid pagination cursor.")
            Return
        End If

        cursor = next
        success = pageSuffix.SetString("&starting_after=")
        success = pageSuffix.Append(cursor)
    End If

Wend