VBScript 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:

VBScript Example

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

set rest = CreateObject("Chilkat_9_5_0.Rest")

'  URL: https://api.stripe.com/v1/balance
bTls = 1
port = 443
bAutoReconnect = 1
success = rest.Connect("api.stripe.com",port,bTls,bAutoReconnect)
If (success <> 1) Then
    outFile.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

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

set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/v1/balance",sbResponseBody)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

set jsonResponse = CreateObject("Chilkat_9_5_0.JsonObject")
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

outFile.Close

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
      }
    }
  ]
}