Visual Basic 6.0 Requires Chilkat v11.7.0+
Visual Basic 6.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 Visual Basic 6.0 Downloads
Dim success As Long
success = 0
' 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 ChilkatHttpCurl
Dim cmd As New ChilkatStringBuilder
Dim json As New ChilkatJsonObject
Dim replaced As Long
Dim email As New ChilkatStringBuilder
success = email.SetString("billing+east@example.com")
' Show every match so the operator can check the internal account reference.
Dim pageSuffix As New ChilkatStringBuilder
Dim more As Long
more = 1
Dim cursor As String
cursor = ""
Do While (more = 1)
' 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 <> 1) Then
Debug.Print "No HTTP response. Chilkat failure code: " & curl.FailReason
Exit Sub
End If
success = curl.GetResponseJson(json)
If ((curl.StatusCode <> 200) Or (success <> 1)) Then
Debug.Print "Stripe HTTP " & curl.StatusCode & " Request-Id: " & curl.GetResponseHeaderField("Request-Id")
If (success = 1) Then
Debug.Print json.StringOf("error.message")
End If
Exit Sub
End If
Dim i As Long
i = 0
Dim count As Long
count = json.SizeOfArray("data")
Do While (i < count)
json.I = i
Debug.Print 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
Loop
more = json.BoolOf("has_more")
If (more = 1) Then
Dim next As String
next = json.StringOf("data[i].id")
If ((count < 1) Or (next = "") Or (next = cursor)) Then
Debug.Print "Invalid pagination cursor."
Exit Sub
End If
cursor = next
success = pageSuffix.SetString("&starting_after=")
success = pageSuffix.Append(cursor)
End If
Loop