Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) Stripe: Retrieve BalanceRetrieves the current Stripe.com account balance.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls. // CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @iTmp0 int DECLARE @sTmp0 nvarchar(4000) -- This example assumes the Chilkat HTTP API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @http int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- Set the Authorization header using your secret key, -- which looks something like this: sk_test_Oxo7a3Atz3UMRz5IRiafjkf7 EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Authorization', 'Bearer STRIPE_SECRET_KEY' DECLARE @jsonResponse nvarchar(4000) EXEC sp_OAMethod @http, 'QuickGetStr', @jsonResponse OUT, 'https://api.stripe.com/v1/balance' EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT IF @iTmp0 <> 1 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http RETURN END DECLARE @json int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT DECLARE @success int EXEC sp_OAMethod @json, 'Load', @success OUT, @jsonResponse EXEC sp_OASetProperty @json, 'EmitCompact', 0 EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT IF @iTmp0 <> 200 BEGIN -- The request failed. Show the error. EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT PRINT @sTmp0 PRINT 'Error status returned.' EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @json RETURN END -- Show the successful response. EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT PRINT @sTmp0 -- 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: DECLARE @amountAvailable int EXEC sp_OAMethod @json, 'IntOf', @amountAvailable OUT, 'available[0].amount' PRINT 'available amount = ' + @amountAvailable DECLARE @amountPending int EXEC sp_OAMethod @json, 'IntOf', @amountPending OUT, 'pending[0].amount' PRINT 'pending amount = ' + @amountPending EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @json END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.