Visual Basic 6.0 Stripe: List all Invoices

Back to Index

Attempts payment on an invoice out of the normal collection schedule.


CURL Command

curl \

Visual Basic 6.0 Example

Dim rest As New ChilkatRest
Dim success As Long

'  URL:
Dim bTls As Long
bTls = 1
Dim port As Long
port = 443
Dim bAutoReconnect As Long
bAutoReconnect = 1
success = rest.Connect("",port,bTls,bAutoReconnect)
If (success <> 1) Then
    Debug.Print "ConnectFailReason: " & rest.ConnectFailReason
    Debug.Print rest.LastErrorText
    Exit Sub
End If

success = rest.SetAuthBasic("STRIPE_SECRET_KEY","")

Dim sbResponseBody As New ChilkatStringBuilder
success = rest.FullRequestNoBodySb("GET","/v1/invoices?limit=3",sbResponseBody)
If (success <> 1) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim jsonResponse As New ChilkatJsonObject
success = jsonResponse.LoadSb(sbResponseBody)

Dim object As String
Dim url As String
Dim has_more As Long
Dim i As Long
Dim count_i As Long
Dim id As String
Dim amount_due As Long
Dim application_fee As Long
Dim attempt_count As Long
Dim attempted As Long
Dim billing As String
Dim charge As Long
Dim closed As Long
Dim currency As String
Dim customer As String
Dim date As Long
Dim description As Long
Dim discount As Long
Dim due_date As Long
Dim ending_balance As Long
Dim forgiven As Long
Dim linesHas_more As Long
Dim linesObject As String
Dim linesUrl As String
Dim livemode As Long
Dim next_payment_attempt As Long
Dim number As String
Dim paid As Long
Dim period_end As Long
Dim period_start As Long
Dim receipt_number As Long
Dim starting_balance As Long
Dim statement_descriptor As Long
Dim subscription As Long
Dim subtotal As Long
Dim tax As Long
Dim tax_percent As Long
Dim total As Long
Dim webhooks_delivered_at As Long
Dim j As Long
Dim count_j As Long
Dim amount As Long
Dim description_str As String
Dim discountable As Long
Dim periodStart As Long
Dim periodEnd As Long
Dim planId As String
Dim planObject As String
Dim planAmount As Long
Dim planCreated As Long
Dim planCurrency As String
Dim planInterval As String
Dim planInterval_count As Long
Dim planLivemode As Long
Dim planName As String
Dim planStatement_descriptor As Long
Dim planTrial_period_days As Long
Dim proration As Long
Dim quantity As Long
Dim subscription_item As String
Dim type As String

object = jsonResponse.StringOf("object")
url = jsonResponse.StringOf("url")
has_more = jsonResponse.BoolOf("has_more")
i = 0
count_i = jsonResponse.SizeOfArray("data")
Do While i < count_i
    jsonResponse.I = i
    id = jsonResponse.StringOf("data[i].id")
    object = jsonResponse.StringOf("data[i].object")
    amount_due = jsonResponse.IntOf("data[i].amount_due")
    application_fee = jsonResponse.IsNullOf("data[i].application_fee")
    attempt_count = jsonResponse.IntOf("data[i].attempt_count")
    attempted = jsonResponse.BoolOf("data[i].attempted")
    billing = jsonResponse.StringOf("data[i].billing")
    charge = jsonResponse.IsNullOf("data[i].charge")
    closed = jsonResponse.BoolOf("data[i].closed")
    currency = jsonResponse.StringOf("data[i].currency")
    customer = jsonResponse.StringOf("data[i].customer")
    date = jsonResponse.IntOf("data[i].date")
    description = jsonResponse.IsNullOf("data[i].description")
    discount = jsonResponse.IsNullOf("data[i].discount")
    due_date = jsonResponse.IsNullOf("data[i].due_date")
    ending_balance = jsonResponse.IsNullOf("data[i].ending_balance")
    forgiven = jsonResponse.BoolOf("data[i].forgiven")
    linesHas_more = jsonResponse.BoolOf("data[i].lines.has_more")
    linesObject = jsonResponse.StringOf("data[i].lines.object")
    linesUrl = jsonResponse.StringOf("data[i].lines.url")
    livemode = jsonResponse.BoolOf("data[i].livemode")
    next_payment_attempt = jsonResponse.IntOf("data[i].next_payment_attempt")
    number = jsonResponse.StringOf("data[i].number")
    paid = jsonResponse.BoolOf("data[i].paid")
    period_end = jsonResponse.IntOf("data[i].period_end")
    period_start = jsonResponse.IntOf("data[i].period_start")
    receipt_number = jsonResponse.IsNullOf("data[i].receipt_number")
    starting_balance = jsonResponse.IntOf("data[i].starting_balance")
    statement_descriptor = jsonResponse.IsNullOf("data[i].statement_descriptor")
    subscription = jsonResponse.IsNullOf("data[i].subscription")
    subtotal = jsonResponse.IntOf("data[i].subtotal")
    tax = jsonResponse.IsNullOf("data[i].tax")
    tax_percent = jsonResponse.IsNullOf("data[i].tax_percent")
    total = jsonResponse.IntOf("data[i].total")
    webhooks_delivered_at = jsonResponse.IsNullOf("data[i].webhooks_delivered_at")
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i]")
    Do While j < count_j
        jsonResponse.J = j
        id = jsonResponse.StringOf("data[i][j].id")
        object = jsonResponse.StringOf("data[i][j].object")
        amount = jsonResponse.IntOf("data[i][j].amount")
        currency = jsonResponse.StringOf("data[i][j].currency")
        description_str = jsonResponse.StringOf("data[i][j].description")
        discountable = jsonResponse.BoolOf("data[i][j].discountable")
        livemode = jsonResponse.BoolOf("data[i][j].livemode")
        periodStart = jsonResponse.IntOf("data[i][j].period.start")
        periodEnd = jsonResponse.IntOf("data[i][j].period.end")
        planId = jsonResponse.StringOf("data[i][j]")
        planObject = jsonResponse.StringOf("data[i][j].plan.object")
        planAmount = jsonResponse.IntOf("data[i][j].plan.amount")
        planCreated = jsonResponse.IntOf("data[i][j].plan.created")
        planCurrency = jsonResponse.StringOf("data[i][j].plan.currency")
        planInterval = jsonResponse.StringOf("data[i][j].plan.interval")
        planInterval_count = jsonResponse.IntOf("data[i][j].plan.interval_count")
        planLivemode = jsonResponse.BoolOf("data[i][j].plan.livemode")
        planName = jsonResponse.StringOf("data[i][j]")
        planStatement_descriptor = jsonResponse.IsNullOf("data[i][j].plan.statement_descriptor")
        planTrial_period_days = jsonResponse.IsNullOf("data[i][j].plan.trial_period_days")
        proration = jsonResponse.BoolOf("data[i][j].proration")
        quantity = jsonResponse.IntOf("data[i][j].quantity")
        subscription = jsonResponse.IsNullOf("data[i][j].subscription")
        subscription_item = jsonResponse.StringOf("data[i][j].subscription_item")
        type = jsonResponse.StringOf("data[i][j].type")
        j = j + 1
    i = i + 1

Sample JSON Response Body

  "object": "list",
  "url": "/v1/invoices",
  "has_more": false,
  "data": [
      "id": "in_1BnETLGswQrCoh0X6M67Qy9c",
      "object": "invoice",
      "amount_due": 0,
      "application_fee": null,
      "attempt_count": 0,
      "attempted": false,
      "billing": "charge_automatically",
      "charge": null,
      "closed": false,
      "currency": "usd",
      "customer": "cus_CBbggkUyLoz3pe",
      "date": 1516662783,
      "description": null,
      "discount": null,
      "due_date": null,
      "ending_balance": null,
      "forgiven": false,
      "lines": {
        "data": [
            "id": "sub_CBbgC3EaFZqN3Q",
            "object": "line_item",
            "amount": 999,
            "currency": "usd",
            "description": "1x Silver Express (at $9.99)",
            "discountable": true,
            "livemode": true,
            "metadata": {},
            "period": {
              "start": 1521760383,
              "end": 1524438783
            "plan": {
              "id": "gold",
              "object": "plan",
              "amount": 2000,
              "created": 1516662783,
              "currency": "usd",
              "interval": "month",
              "interval_count": 1,
              "livemode": false,
              "metadata": {},
              "name": "T-shirt",
              "statement_descriptor": null,
              "trial_period_days": null
            "proration": false,
            "quantity": 1,
            "subscription": null,
            "subscription_item": "si_CBbgZxCVF3Ha7P",
            "type": "subscription"
        "has_more": false,
        "object": "list",
        "url": "/v1/invoices/in_1BnETLGswQrCoh0X6M67Qy9c/lines"
      "livemode": false,
      "metadata": {},
      "next_payment_attempt": 1516666383,
      "number": "330a34b8d5-0001",
      "paid": false,
      "period_end": 1516662783,
      "period_start": 1516662783,
      "receipt_number": null,
      "starting_balance": 0,
      "statement_descriptor": null,
      "subscription": null,
      "subtotal": 0,
      "tax": null,
      "tax_percent": null,
      "total": 0,
      "webhooks_delivered_at": null