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

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

DataFlex
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