Visual Basic 6.0 Requires Chilkat v11.7.0+
Visual Basic 6.0
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 Visual Basic 6.0 Downloads
Dim success As Long
success = 0
' 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 ChilkatHttpCurl
Dim cmd As New ChilkatStringBuilder
Dim json As New ChilkatJsonObject
Dim replaced As Long
Dim customerId As String
customerId = "cus_FROM_BILLING_ACCOUNT"
' Remove status=open to show all invoice states.
Dim pageSuffix As New ChilkatStringBuilder
Dim more As Long
more = 1
Dim cursor As String
cursor = ""
Do While (more = 1)
' 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 <> 1) Then
Debug.Print "No HTTP response. Chilkat failure code: " & curl.FailReason
Exit Sub
End If
success = curl.GetResponseJson(json)
If ((curl.StatusCode <> 200) Or (success <> 1)) Then
Debug.Print "Stripe HTTP " & curl.StatusCode & " Request-Id: " & curl.GetResponseHeaderField("Request-Id")
If (success = 1) Then
Debug.Print json.StringOf("error.message")
End If
Exit Sub
End If
Dim i As Long
i = 0
Dim count As Long
count = json.SizeOfArray("data")
Do While (i < count)
json.I = i
Debug.Print 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
Loop
more = json.BoolOf("has_more")
If (more = 1) Then
Dim next As String
next = json.StringOf("data[i].id")
If ((count < 1) Or (next = "") Or (next = cursor)) Then
Debug.Print "Invalid pagination cursor."
Exit Sub
End If
cursor = next
success = pageSuffix.SetString("&starting_after=")
success = pageSuffix.Append(cursor)
End If
Loop