Excel Stripe: Retrieve Balance

Back to Index

Retrieves the current account balance, based on the authentication that was used to make the request.

Documentation: https://stripe.com/docs/api/curl#retrieve_balance

CURL Command

curl https://api.stripe.com/v1/balance \
   -u STRIPE_SECRET_KEY:

Excel Example

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

'  URL: https://api.stripe.com/v1/balance

bTls = True

port = 443

bAutoReconnect = True
success = rest.Connect("api.stripe.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.Print "ConnectFailReason: "; rest.ConnectFailReason
    Debug.Print rest.LastErrorText
    Exit Sub
End If

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

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/v1/balance",sbResponseBody)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
success = jsonResponse.LoadSb(sbResponseBody)

object = jsonResponse.StringOf("object")
livemode = jsonResponse.BoolOf("livemode")
i = 0
count_i = jsonResponse.SizeOfArray("available")
Do While i < count_i
    jsonResponse.I = i
    currency = jsonResponse.StringOf("available[i].currency")
    amount = jsonResponse.IntOf("available[i].amount")
    source_typesCard = jsonResponse.IntOf("available[i].source_types.card")
    i = i + 1
Loop
i = 0
count_i = jsonResponse.SizeOfArray("pending")
Do While i < count_i
    jsonResponse.I = i
    currency = jsonResponse.StringOf("pending[i].currency")
    amount = jsonResponse.IntOf("pending[i].amount")
    source_typesCard = jsonResponse.IntOf("pending[i].source_types.card")
    i = i + 1
Loop

Sample JSON Response Body

{
  "object": "balance",
  "available": [
    {
      "currency": "usd",
      "amount": 0,
      "source_types": {
        "card": 0
      }
    }
  ],
  "livemode": false,
  "pending": [
    {
      "currency": "usd",
      "amount": 0,
      "source_types": {
        "card": 0
      }
    }
  ]
}