Xojo Plugin Requires Chilkat v11.7.0+
Xojo Plugin
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 Xojo Plugin Downloads
Dim success As Boolean
success = False
// 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 Chilkat.HttpCurl
Dim cmd As New Chilkat.StringBuilder
Dim json As New Chilkat.JsonObject
Dim replaced As Int32
Dim customerId As String
customerId = "cus_FROM_BILLING_ACCOUNT"
// Remove status=open to show all invoice states.
Dim pageSuffix As New Chilkat.StringBuilder
Dim more As Boolean
more = True
Dim cursor As String
cursor = ""
While (more = 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"
success = cmd.SetString("curl -X GET ""https://api.stripe.com/v1/invoices?customer=@CUSTOMER@&status=open&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("@CUSTOMER@",customerId)
replaced = cmd.Replace("@KEY@",apiKey)
success = curl.DoYourThing(cmd.GetAsString())
If (success <> True) Then
System.DebugLog("No HTTP response. Chilkat failure code: " + Str(curl.FailReason))
Return
End If
success = curl.GetResponseJson(json)
If ((curl.StatusCode <> 200) Or (success <> True)) Then
System.DebugLog("Stripe HTTP " + Str(curl.StatusCode) + " Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
If (success = True) Then
System.DebugLog(json.StringOf("error.message"))
End If
Return
End If
Dim i As Int32
i = 0
Dim count As Int32
count = json.SizeOfArray("data")
While (i < count)
json.I = i
System.DebugLog(json.StringOf("data[i].id") + " | " + json.StringOf("data[i].number") + " | " + json.StringOf("data[i].status") + " | " + json.StringOf("data[i].due_date") _
+ " | " + json.StringOf("data[i].amount_remaining") + " | " + json.StringOf("data[i].currency") + " | " + json.StringOf("data[i].hosted_invoice_url") + " | " + json.StringOf("data[i].invoice_pdf"))
i = i + 1
Wend
more = json.BoolOf("has_more")
If (more = True) Then
Dim next As String
next = json.StringOf("data[i].id")
If ((count < 1) Or (next = "") Or (next = cursor)) Then
System.DebugLog("Invalid pagination cursor.")
Return
End If
cursor = next
success = pageSuffix.SetString("&starting_after=")
success = pageSuffix.Append(cursor)
End If
Wend