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) SII GET boleta.electronica.semillaObtención de la semilla For more information, see https://www4c.sii.cl/bolcoreinternetui/api/
-- 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) -- This example assumes 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 DECLARE @success int -- Implements the following CURL command: -- curl -X GET "https://apicert.sii.cl/recursos/v1/boleta.electronica.semilla" -H "accept: application/xml" -- Use the following online tool to generate HTTP code from a CURL command -- Convert a cURL Command to HTTP Source Code EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'accept', 'application/xml' -- Use one of the following domains, depending on the environment: -- apicert.sii.cl - Certification Environment -- api.sii.cl - Production Environment DECLARE @sbResponseBody int -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://apicert.sii.cl/recursos/v1/boleta.electronica.semilla', @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 @xmlResponse int -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlResponse OUT EXEC sp_OAMethod @xmlResponse, 'LoadSb', @success OUT, @sbResponseBody, 1 EXEC sp_OAMethod @xmlResponse, 'GetXml', @sTmp0 OUT PRINT @sTmp0 -- Sample XML response: -- (Sample code for parsing the XML response is shown below) -- <?xml version="1.0" encoding="UTF-8"?> -- <SII:RESPUESTA xmlns:SII="http://www.sii.cl/XMLSchema"> -- <SII:RESP_BODY> -- <SEMILLA>030530912644</SEMILLA> -- </SII:RESP_BODY> -- <SII:RESP_HDR> -- <ESTADO>0</ESTADO> -- </SII:RESP_HDR> -- </SII:RESPUESTA> -- Sample code for parsing the XML response... -- Use the following online tool to generate parsing code from sample XML: -- Generate Parsing Code from XML DECLARE @SII_RESPUESTA_xmlns_SII nvarchar(4000) EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @SII_RESPUESTA_xmlns_SII OUT, 'xmlns:SII' DECLARE @SEMILLA nvarchar(4000) EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @SEMILLA OUT, 'SII:RESP_BODY|SEMILLA' DECLARE @ESTADO int EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @ESTADO OUT, 'SII:RESP_HDR|ESTADO' EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @sbResponseBody EXEC @hr = sp_OADestroy @xmlResponse END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.