PureBasic Requires Chilkat v11.7.0+
PureBasic
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 PureBasic Downloads
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkJsonObject.pb"
IncludeFile "CkHttpCurl.pb"
Procedure ChilkatExample()
success.i = 0
; Requires an unlocked Chilkat bundle. See Global Unlock Sample.
; Supply a restricted sandbox key from merchant-controlled configuration.
apiKey.s = "YOUR_STRIPE_TEST_KEY"
curl.i = CkHttpCurl::ckCreate()
If curl.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
cmd.i = CkStringBuilder::ckCreate()
If cmd.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
json.i = CkJsonObject::ckCreate()
If json.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
replaced.i
email.i = CkStringBuilder::ckCreate()
If email.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkStringBuilder::ckSetString(email,"billing+east@example.com")
; Show every match so the operator can check the internal account reference.
pageSuffix.i = CkStringBuilder::ckCreate()
If pageSuffix.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
more.i = 1
cursor.s = ""
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"
CkStringBuilder::ckSetString(cmd,"curl -X GET " + Chr(34) + "https://api.stripe.com/v1/customers?email=@EMAIL@&limit=100@CURSOR@" + Chr(34))
CkStringBuilder::ckAppend(cmd," -u " + Chr(34) + "@KEY@:" + Chr(34))
CkStringBuilder::ckAppend(cmd," -H " + Chr(34) + "Stripe-Version: 2026-10-28.endive" + Chr(34))
replaced = CkStringBuilder::ckReplace(cmd,"@CURSOR@",CkStringBuilder::ckGetAsString(pageSuffix))
replaced = CkStringBuilder::ckReplace(cmd,"@EMAIL@",CkStringBuilder::ckGetEncoded(email,"url_rfc3986","utf-8"))
replaced = CkStringBuilder::ckReplace(cmd,"@KEY@",apiKey)
success = CkHttpCurl::ckDoYourThing(curl,CkStringBuilder::ckGetAsString(cmd))
If success <> 1
Debug "No HTTP response. Chilkat failure code: " + Str(CkHttpCurl::ckFailReason(curl))
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(email)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
success = CkHttpCurl::ckGetResponseJson(curl,json)
If (CkHttpCurl::ckStatusCode(curl) <> 200) OR (success <> 1)
Debug "Stripe HTTP " + Str(CkHttpCurl::ckStatusCode(curl)) + " Request-Id: " + CkHttpCurl::ckGetResponseHeaderField(curl,"Request-Id")
If success = 1
Debug CkJsonObject::ckStringOf(json,"error.message")
EndIf
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(email)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
i.i = 0
count.i = CkJsonObject::ckSizeOfArray(json,"data")
While (i < count)
CkJsonObject::setCkI(json, i)
Debug CkJsonObject::ckStringOf(json,"data[i].id") + " | " + CkJsonObject::ckStringOf(json,"data[i].name") + " | " + CkJsonObject::ckStringOf(json,"data[i].email") + " | " + CkJsonObject::ckStringOf(json,"data[i].metadata.account_ref")
i = i + 1
Wend
more = CkJsonObject::ckBoolOf(json,"has_more")
If more = 1
next.s = CkJsonObject::ckStringOf(json,"data[i].id")
If (count < 1) OR (next = "") OR (next = cursor)
Debug "Invalid pagination cursor."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(email)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
cursor = next
CkStringBuilder::ckSetString(pageSuffix,"&starting_after=")
CkStringBuilder::ckAppend(pageSuffix,cursor)
EndIf
Wend
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(email)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndProcedure