DataFlex Requires Chilkat v11.7.0+
DataFlex
Stripe: Find a catalog price by its lookup key
See more Stripe Examples
Retrieve an active price by its catalog lookup key and read its price ID, currency, amount, and billing type.
Stripe documentation and cURL example
Chilkat DataFlex Downloads
Use ChilkatAx-win32.pkg
Procedure Test
Boolean iSuccess
String sApiKey
Handle hoCurl
Handle hoCmd
Variant vJson
Handle hoJson
Integer iReplaced
Handle hoLookupKey
String sTemp1
Integer iTemp1
Boolean bTemp1
Move False To iSuccess
// Requires an unlocked Chilkat bundle. See Global Unlock Sample.
// Supply a restricted sandbox key from merchant-controlled configuration.
Move "YOUR_STRIPE_TEST_KEY" To sApiKey
Get Create (RefClass(cComChilkatHttpCurl)) To hoCurl
If (Not(IsComObjectCreated(hoCurl))) Begin
Send CreateComObject of hoCurl
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoCmd
If (Not(IsComObjectCreated(hoCmd))) Begin
Send CreateComObject of hoCmd
End
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoLookupKey
If (Not(IsComObjectCreated(hoLookupKey))) Begin
Send CreateComObject of hoLookupKey
End
Get ComSetString Of hoLookupKey "support_monthly_usd" To iSuccess
// curl -X GET "https://api.stripe.com/v1/prices?active=true&lookup_keys%5B%5D={lookupKey}&limit=2" \
// -u "$STRIPE_API_KEY:" \
// -H "Stripe-Version: 2026-10-28.endive"
Get ComSetString Of hoCmd 'curl -X GET "https://api.stripe.com/v1/prices?active=true&lookup_keys%5B%5D=@LOOKUP@&limit=2"' To iSuccess
Get ComAppend Of hoCmd ' -u "@KEY@:"' To iSuccess
Get ComAppend Of hoCmd ' -H "Stripe-Version: 2026-10-28.endive"' To iSuccess
Get ComGetEncoded Of hoLookupKey "url_rfc3986" "utf-8" To sTemp1
Get ComReplace Of hoCmd "@LOOKUP@" sTemp1 To iReplaced
Get ComReplace Of hoCmd "@KEY@" sApiKey To iReplaced
Get ComGetAsString Of hoCmd To sTemp1
Get ComDoYourThing Of hoCurl sTemp1 To iSuccess
If (iSuccess <> True) Begin
Get ComFailReason Of hoCurl To iTemp1
Showln "No HTTP response. Chilkat failure code: " iTemp1
Procedure_Return
End
Get pvComObject of hoJson to vJson
Get ComGetResponseJson Of hoCurl vJson To iSuccess
Get ComStatusCode Of hoCurl To iTemp1
If ((iTemp1 <> 200) Or (iSuccess <> True)) Begin
Get ComStatusCode Of hoCurl To iTemp1
Get ComGetResponseHeaderField Of hoCurl "Request-Id" To sTemp1
Showln "Stripe HTTP " iTemp1 " Request-Id: " sTemp1
If (iSuccess = True) Begin
Get ComStringOf Of hoJson "error.message" To sTemp1
Showln sTemp1
End
Procedure_Return
End
Get ComSizeOfArray Of hoJson "data" To iTemp1
Get ComBoolOf Of hoJson "has_more" To bTemp1
If ((iTemp1 <> 1) Or (bTemp1 = True)) Begin
Showln "Expected one active price for this lookup key."
Procedure_Return
End
Get ComStringOf Of hoJson "data[0].id" To sTemp1
Showln "id = " sTemp1
Get ComStringOf Of hoJson "data[0].lookup_key" To sTemp1
Showln "lookup_key = " sTemp1
Get ComStringOf Of hoJson "data[0].currency" To sTemp1
Showln "currency = " sTemp1
Get ComStringOf Of hoJson "data[0].unit_amount_decimal" To sTemp1
Showln "unit_amount_decimal = " sTemp1
Get ComStringOf Of hoJson "data[0].type" To sTemp1
Showln "type = " sTemp1
End_Procedure