(SQL Server) SII GET boleta.electronica.semilla

Obtención de la semilla

For more information, see https://www4c.sii.cl/bolcoreinternetui/api/

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- 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