SQL Server
SQL Server
palena.sii.cl getSeed SOAP Request
See more SII Chile Examples
Demonstrates how to call getSeed SOAP request at palena.sii.clChilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @responseStatusCode int
EXEC sp_OASetProperty @http, 'UncommonOptions', 'AllowEmptyHeaders'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'SOAPAction', ''
-- The endpoint for this soap service is:
DECLARE @endPoint nvarchar(4000)
SELECT @endPoint = 'https://palena.sii.cl/DTEWS/CrSeed.jws'
-- Send the following SOAP XML
-- <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:def="http://DefaultNamespace">
-- <soapenv:Header/>
-- <soapenv:Body>
-- <def:getSeed soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
-- </soapenv:Body>
-- </soapenv:Envelope>
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OASetProperty @xml, 'Tag', 'soapenv:Envelope'
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:xsd', 'http://www.w3.org/2001/XMLSchema'
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:soapenv', 'http://schemas.xmlsoap.org/soap/envelope/'
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:def', 'http://DefaultNamespace'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soapenv:Header', ''
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'soapenv:Body|def:getSeed', 1, 'soapenv:encodingStyle', 'http://schemas.xmlsoap.org/soap/encoding/'
DECLARE @resp int
EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @xml, 'GetXml', @sTmp0 OUT
EXEC sp_OAMethod @http, 'HttpStr', @success OUT, 'POST', @endPoint, @sTmp0, 'utf-8', 'text/xml', @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @responseStatusCode OUT
PRINT 'Response Status Code: ' + @responseStatusCode
-- You may examine the exact HTTP header sent with the POST like this:
PRINT 'LastHeader:'
EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
PRINT @sTmp0
-- Examine the XML returned by the web service:
PRINT 'XML Response:'
DECLARE @xmlResp int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlResp OUT
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
EXEC sp_OAMethod @xmlResp, 'LoadXml', @success OUT, @sTmp0
EXEC sp_OAMethod @xmlResp, 'GetXml', @sTmp0 OUT
PRINT @sTmp0
-- Use this online tool to generate parsing code from response XML:
-- Generate Parsing Code from XML
-- The response is:
-- <?xml version="1.0" encoding="UTF-8"?>
-- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
-- <soapenv:Body>
-- <ns1:getSeedResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://DefaultNamespace">
-- <ns1:getSeedReturn xsi:type="xsd:string"><?xml version="1.0" encoding="UTF-8"?><SII:RESPUESTA xmlns:SII="http://www.sii.cl/XMLSchema"><SII:RESP_BODY><SEMILLA>039159253918</SEMILLA></SII:RESP_BODY><SII:RESP_HDR><ESTADO>00</ESTADO></SII:RESP_HDR></SII:RESPUESTA></ns1:getSeedReturn>
-- </ns1:getSeedResponse>
-- </soapenv:Body>
-- </soapenv:Envelope>
-- Get the XML contained in the getSeedReturn element:
DECLARE @embeddedXml nvarchar(4000)
EXEC sp_OAMethod @xmlResp, 'GetChildContent', @embeddedXml OUT, 'soapenv:Body|ns1:getSeedResponse|ns1:getSeedReturn'
PRINT @embeddedXml
-- The embedded XML is:
-- <?xml version="1.0" encoding="UTF-8"?>
-- <SII:RESPUESTA xmlns:SII="http://www.sii.cl/XMLSchema">
-- <SII:RESP_BODY>
-- <SEMILLA>039159397998</SEMILLA>
-- </SII:RESP_BODY>
-- <SII:RESP_HDR>
-- <ESTADO>00</ESTADO>
-- </SII:RESP_HDR>
-- </SII:RESPUESTA>
-- Get the seed:
DECLARE @xml2 int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml2 OUT
EXEC sp_OAMethod @xml2, 'LoadXml', @success OUT, @embeddedXml
DECLARE @seed nvarchar(4000)
EXEC sp_OAMethod @xml2, 'GetChildContent', @seed OUT, 'SII:RESP_BODY|SEMILLA'
PRINT 'seed = ' + @seed
-- --------------------------------------------------------------------------------
-- Also see Chilkat's Online WSDL Code Generator
-- to generate code and SOAP Request and Response XML for each operation in a WSDL.
-- --------------------------------------------------------------------------------
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @xmlResp
EXEC @hr = sp_OADestroy @xml2
END
GO