![]() |
Chilkat HOME Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi DLL Go Java Node.js Objective-C PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) Bitfinex v2 REST TickersThe tickers endpoint provides a high level overview of the state of the market. It shows the current best bid and ask, the last traded price, as well as information on the daily volume and price movement over the last day. The endpoint can retrieve multiple tickers with a single query. Note: This example requires Chilkat v11.0.0 or greater. For more information, see https://docs.bitfinex.com/reference#rest-public-tickers
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) DECLARE @success int SELECT @success = 0 -- This example assumes the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @http int EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- Implements the following CURL command: -- curl https://api-pub.bitfinex.com/v2/tickers?symbols=tBTCUSD,tLTCUSD,fUSD -- Use the following online tool to generate HTTP code from a CURL command -- Convert a cURL Command to HTTP Source Code DECLARE @sbResponseBody int EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://api-pub.bitfinex.com/v2/tickers?symbols=tBTCUSD,tLTCUSD,fUSD', @sbResponseBody IF @success = 0 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @sbResponseBody RETURN END DECLARE @jarrResp int EXEC @hr = sp_OACreate 'Chilkat.JsonArray', @jarrResp OUT EXEC sp_OAMethod @jarrResp, 'LoadSb', @success OUT, @sbResponseBody EXEC sp_OASetProperty @jarrResp, 'EmitCompact', 0 PRINT 'Response Body:' EXEC sp_OAMethod @jarrResp, 'Emit', @sTmp0 OUT PRINT @sTmp0 DECLARE @respStatusCode int EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT PRINT 'Response Status Code = ' + @respStatusCode IF @respStatusCode >= 400 BEGIN PRINT 'Response Header:' EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT PRINT @sTmp0 PRINT 'Failed.' EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @sbResponseBody EXEC @hr = sp_OADestroy @jarrResp RETURN END -- Sample JSON response: -- (Sample code for parsing the JSON response is shown below) -- [ -- [ -- "tBTCUSD", -- 9318.6, -- 21.53815472, -- 9318.7, -- 5.30463105, -- 223.5, -- 0.0246, -- 9318.7, -- 4125.21689058, -- 9370.998872, -- 9075.80199233 -- ], -- [ -- "tLTCUSD", -- 44.008, -- 1807.8617840300003, -- 44.019, -- 2394.7625575100005, -- 2.359, -- 0.0566, -- 44.019, -- 27051.34115724, -- 44.16, -- 41.559 -- ], -- [ -- "fUSD", -- 0.00022955068493150685, -- 0.000199, -- 30, -- 871597.2359141599, -- 0.0001962, -- 2, -- 67926.11558407999, -- -0.00001146, -- -0.0523, -- 0.00020757, -- 167542924.22214913, -- 0.00024, -- 0.00000299, -- null, -- null, -- 82649109.90968154 -- ] -- ] -- Sample code for parsing the JSON response... -- Use the following online tool to generate parsing code from sample JSON: -- Generate Parsing Code from JSON DECLARE @jarr_1 int EXEC @hr = sp_OACreate 'Chilkat.JsonArray', @jarr_1 OUT DECLARE @j int DECLARE @count_j int DECLARE @strVal nvarchar(4000) DECLARE @i int SELECT @i = 0 DECLARE @count_i int EXEC sp_OAGetProperty @jarrResp, 'Size', @count_i OUT WHILE @i < @count_i BEGIN EXEC sp_OAMethod @jarrResp, 'ArrayAt2', @success OUT, @i, @jarr_1 SELECT @j = 0 EXEC sp_OAGetProperty @jarr_1, 'Size', @count_j OUT WHILE @j < @count_j BEGIN EXEC sp_OAMethod @jarr_1, 'StringAt', @strVal OUT, @j SELECT @j = @j + 1 END SELECT @i = @i + 1 END EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @sbResponseBody EXEC @hr = sp_OADestroy @jarrResp EXEC @hr = sp_OADestroy @jarr_1 END GO |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.