Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(Excel) Stripe: Retrieve BalanceRetrieves the current Stripe.com account balance.
' This example assumes the Chilkat HTTP API to have been previously unlocked. ' See Global Unlock Sample for sample code. Dim http As Chilkat.Http Set http = Chilkat.NewHttp ' Set the Authorization header using your secret key, ' which looks something like this: sk_test_Oxo7a3Atz3UMRz5IRiafjkf7 http.SetRequestHeader "Authorization","Bearer STRIPE_SECRET_KEY" jsonResponse = http.QuickGetStr("https://api.stripe.com/v1/balance") If (http.LastMethodSuccess <> True) Then Debug.Print http.LastErrorText Exit Sub End If Dim json As Chilkat.JsonObject Set json = Chilkat.NewJsonObject Dim success As Boolean success = json.Load(jsonResponse) json.EmitCompact = False If (http.LastStatus <> 200) Then ' The request failed. Show the error. Debug.Print json.Emit() Debug.Print "Error status returned." Exit Sub End If ' Show the successful response. Debug.Print json.Emit() ' A sample result: ' { ' "object": "balance", ' "available": [ ' { ' "currency": "usd", ' "amount": 0, ' "source_types": { ' "card": 0 ' } ' } ' ], ' "livemode": false, ' "pending": [ ' { ' "currency": "usd", ' "amount": 0, ' "source_types": { ' "card": 0 ' } ' } ' ] ' } ' To get some information from the JSON: amountAvailable = json.IntOf("available[0].amount") Debug.Print "available amount = "; amountAvailable amountPending = json.IntOf("pending[0].amount") Debug.Print "pending amount = "; amountPending |
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.