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) POST application/json HTTPS RequestDemonstrates how to send an HTTPS POST where the request body and response body both have the application/json Content-Type. Also demonstrates how to add a few custom headers to the request.
-- 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 -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- This requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code DECLARE @http int -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- Add a few custom headers. EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Client-ID', 'my_client_id' EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Client-Token', 'my_client_token' EXEC sp_OASetProperty @http, 'Accept', 'application/json' DECLARE @url nvarchar(4000) SELECT @url = 'https://api.fiscallog.eu/sign/v1' DECLARE @jsonRequestBody nvarchar(4000) SELECT @jsonRequestBody = '{ .... }' DECLARE @resp int EXEC sp_OAMethod @http, 'PostJson2', @resp OUT, @url, 'application/json', @jsonRequestBody EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT IF @iTmp0 = 0 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http RETURN END EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT PRINT 'Response status code = ' + @iTmp0 DECLARE @jsonResponseStr nvarchar(4000) EXEC sp_OAGetProperty @resp, 'BodyStr', @jsonResponseStr OUT PRINT @jsonResponseStr EXEC @hr = sp_OADestroy @resp EXEC @hr = sp_OADestroy @http END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.