DataFlex Requires Chilkat v11.7.0+
DataFlex
Stripe: Review invoices and outstanding amounts
See more Stripe Examples
List open invoices for a billing account and show outstanding amounts, due dates, and invoice links.
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
String sCustomerId
Handle hoPageSuffix
Boolean iMore
String sCursor
Integer i
Integer iCount
String sNext
String sTemp1
String sTemp2
String sTemp3
String sTemp4
String sTemp5
String sTemp6
String sTemp7
String sTemp8
Integer iTemp1
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
Move "cus_FROM_BILLING_ACCOUNT" To sCustomerId
// Remove status=open to show all invoice states.
Get Create (RefClass(cComChilkatStringBuilder)) To hoPageSuffix
If (Not(IsComObjectCreated(hoPageSuffix))) Begin
Send CreateComObject of hoPageSuffix
End
Move True To iMore
Move "" To sCursor
While (iMore = True)
// curl -X GET "https://api.stripe.com/v1/invoices?customer={customerId}&status=open&limit=100" \
// -u "$STRIPE_API_KEY:" \
// -H "Stripe-Version: 2026-10-28.endive"
Get ComSetString Of hoCmd 'curl -X GET "https://api.stripe.com/v1/invoices?customer=@CUSTOMER@&status=open&limit=100@CURSOR@"' To iSuccess
Get ComAppend Of hoCmd ' -u "@KEY@:"' To iSuccess
Get ComAppend Of hoCmd ' -H "Stripe-Version: 2026-10-28.endive"' To iSuccess
Get ComGetAsString Of hoPageSuffix To sTemp1
Get ComReplace Of hoCmd "@CURSOR@" sTemp1 To iReplaced
Get ComReplace Of hoCmd "@CUSTOMER@" sCustomerId 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
Move 0 To i
Get ComSizeOfArray Of hoJson "data" To iCount
While (i < iCount)
Set ComI Of hoJson To i
Get ComStringOf Of hoJson "data[i].id" To sTemp1
Get ComStringOf Of hoJson "data[i].number" To sTemp2
Get ComStringOf Of hoJson "data[i].status" To sTemp3
Get ComStringOf Of hoJson "data[i].due_date" To sTemp4
Get ComStringOf Of hoJson "data[i].amount_remaining" To sTemp5
Get ComStringOf Of hoJson "data[i].currency" To sTemp6
Get ComStringOf Of hoJson "data[i].hosted_invoice_url" To sTemp7
Get ComStringOf Of hoJson "data[i].invoice_pdf" To sTemp8
Showln sTemp1 " | " sTemp2 " | " sTemp3 " | " sTemp4 " | " sTemp5 " | " sTemp6 " | " sTemp7 " | " sTemp8
Move (i + 1) To i
Loop
Get ComBoolOf Of hoJson "has_more" To iMore
If (iMore = True) Begin
Get ComStringOf Of hoJson "data[i].id" To sNext
If ((iCount < 1) Or (sNext = "") Or (sNext = sCursor)) Begin
Showln "Invalid pagination cursor."
Procedure_Return
End
Move sNext To sCursor
Get ComSetString Of hoPageSuffix "&starting_after=" To iSuccess
Get ComAppend Of hoPageSuffix sCursor To iSuccess
End
Loop
End_Procedure