Chilkat Tools

DefaultEndpoint / Cancel

ASP AutoIt C C (Unicode) C++ C++ (Unicode) C# DataFlex Delphi Foxpro Go Java Node.js Objective-C Perl PHP Extension PowerBuilder Powershell PureBasic Python CkPython Ruby SQL Server Swift TCL VB.NET VB6 VBScript Xojo

Min Request Full Request

-- Important: See this note about {{-https://cknotes.com/sql-sp_oamethod-string-length-return-value-limitations/|||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 {{-https://www.example-code.com/sql/default.asp|||warning about using nvarchar(max)-}}.
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @xml int
    -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @xml, 'Tag', 'soap:Envelope'
    DECLARE @success int
    EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:soap', 'http://www.w3.org/2003/05/soap-envelope'
    EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:a031', 'http://sfera.sk/xmtrade/isom/types/2013/03'
    EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:a03', 'http://sfera.sk/xmtrade/isom/services/MeasuredValuesOfSupplyAndDeliveryPoints/2013/03'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Header', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:REFERENCENUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:IDENTIFIER', 'UTILMD'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:VERSIONNUMBER', 'D'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:RELEASENUMBER', '01C'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:CONTROLAGENCY', 'UN'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:ASSOCCODE', 'E4SK40'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNH|a031:ACCESSREF', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:BGM|a031:NAME', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:BGM|a031:CODELISTAGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:BGM|a031:DOCUMENTNUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:BGM|a031:DOCUMENTFUNC', 9
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:BGM|a031:RESPONSETYPE', 'AB'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:DTM|a031:DATUMQUALIFIER', 92
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:DTM|a031:DATUM', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:DTM|a031:FORMAT', 203
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:RFF|a031:REFERENCEQUALIFIER', 'ACW'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:RFF|a031:REFERENCENUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:ACTION', 'MR'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:PARTNER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:CODELISTAGENCY', 305
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:PARTNERNAME1', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:PARTNERNAME2', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:STREET1', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:STREET2', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:STREET3', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:STREET4', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:CITY', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:COUNTRY', 'SK'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:PLACE_QUALIFIER', 172
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:PLACE_ID', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:CODE_LIST_RESPONSIBLE_AGENCY', 305
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:LINE_ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CODE_LIST_RESPONSIBLE_AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY_QUALIFIER', 47
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUMQUALIFIER', 92
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUM', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:FORMAT', 203
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CHARACTERISTIC_ID', 'Z03'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CODE_LIST_RESPONSIBLE_AGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE_CODED', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:RFF|a031:REFERENCEQUALIFIER', 'ACW'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:RFF|a031:REFERENCENUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:NAD|a031:ZIPCODE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:OBJECT_TYPE', 24
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:PLACE_QUALIFIER', 172
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:PLACE_ID', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:CODE_LIST_RESPONSIBLE_AGENCY', 305
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:LINE_ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CODE_LIST_RESPONSIBLE_AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY_QUALIFIER', 47
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUMQUALIFIER', 92
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUM', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:FORMAT', 203
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:CHARACTERISTIC_ID', 'Z03'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:CODE_LIST_RESPONSIBLE_AGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE_CODED', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:DTM|a031:DATUMQUALIFIER', 92
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:DTM|a031:DATUM', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:DTM|a031:FORMAT', 203
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:PRC|a031:PROCESS_TYPE', 'MSG_DETAIL'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:PRC|a031:CODELISTAGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:TEXT_SUBJECT_QUALIFIER', 'AAI'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_CODE', 3
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:CODELISTAGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_1', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_2', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_3', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_4', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:FTX|a031:FREE_TEXT_5', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:AGR|a031:AGREE_TYPE_ID', 11
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:AGR|a031:AGREE_TYPE_DESCRIPTION', 'E01'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:AGR|a031:AGREE_TYPE_CODE_LIST', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:AGR|a031:AGREE_TYPE_AGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:AGR|a031:AGREE_TYPE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:CHARACTERISTIC_ID', 'Z03'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:CODE_LIST_RESPONSIBLE_AGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE_CODED', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:CAV|a031:AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:CCI|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:ACTION', 'MR'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:PARTNER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:CODELISTAGENCY', 305
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:PARTNERNAME1', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:PARTNERNAME2', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:STREET1', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:STREET2', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:STREET3', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:STREET4', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:CITY', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:COUNTRY', 'SK'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:PLACE_QUALIFIER', 172
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:PLACE_ID', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:CODE_LIST_RESPONSIBLE_AGENCY', 305
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:LINE_ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:ITEM_NUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CODE_LIST_RESPONSIBLE_AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY_QUALIFIER', 47
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:QUANTITY', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUMQUALIFIER', 92
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:DATUM', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:QTY|a031:DTM|a031:FORMAT', 203
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CHARACTERISTIC_ID', 'Z03'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CODE_LIST_RESPONSIBLE_AGENCY', 260
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE_CODED', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:AGENCY', 'SKE'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:CAV|a031:CHARACTERISTIC_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_APPLICATION', 'AAZ'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_UNIT_QUALIFIER', 'KWH'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:LOC|a031:LIN|a031:CCI|a031:MEA|a031:MEASURMENT_VALUE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:RFF|a031:REFERENCEQUALIFIER', 'ACW'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:RFF|a031:REFERENCENUMBER', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:IDE|a031:NAD|a031:ZIPCODE', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNT|a031:NUMSEG', 'string'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'soap:Body|a03:CancelRequest|a03:UTILMD|a031:UNT|a031:REFNUM', 'string'

    -- In a SOAP HTTP request, including the XML declaration (<?xml version="1.0" encoding="UTF-8"?>) in the XML body is generally not required. 
    EXEC sp_OASetProperty @xml, 'EmitXmlDecl', 0
    DECLARE @soapRequestBody nvarchar(4000)
    EXEC sp_OAMethod @xml, 'GetXml', @soapRequestBody OUT

    DECLARE @endpoint nvarchar(4000)
    SELECT @endpoint = 'http://isom.okte.sk/interfaces/MeasuredValuesOfSupplyAndDeliveryPoints/Service.svc'
    DECLARE @soapAction nvarchar(4000)
    SELECT @soapAction = 'http://sfera.sk/xmtrade/isom/services/MeasuredValuesOfSupplyAndDeliveryPoints/2013/03/MeasuredValuesOfSupplyAndDeliveryPointsContract/Cancel'
    --  For SOAP requests, the standard Content-Type is usually set to "text/xml" or "application/soap+xml"
    DECLARE @contentType nvarchar(4000)
    SELECT @contentType = 'text/xml'

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT

    EXEC sp_OAMethod @http, 'ClearHeaders', NULL
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', @contentType
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'SOAPAction', @soapAction

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostXml', @resp OUT, @endpoint, @soapRequestBody, 'utf-8'
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0

        PRINT 'Failed to send SOAP request.'
        EXEC @hr = sp_OADestroy @xml
        EXEC @hr = sp_OADestroy @http
        RETURN
      END

    -- Get the XML response body.
    DECLARE @responseXml int
    -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @responseXml OUT

    EXEC sp_OAMethod @resp, 'GetBodyXml', @success OUT, @responseXml

    DECLARE @statusCode int
    EXEC sp_OAGetProperty @resp, 'StatusCode', @statusCode OUT

    PRINT 'response status code: ' + @statusCode

    EXEC @hr = sp_OADestroy @resp

    -- If the status code does not indicate succcess, then show the response XML,
    -- which probably contains error information.
    IF @statusCode <> 200
      BEGIN
        EXEC sp_OAMethod @responseXml, 'GetXml', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @xml
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @responseXml
        RETURN
      END

    EXEC sp_OAMethod @responseXml, 'GetXml', @sTmp0 OUT
    PRINT @sTmp0

    -- Parse the successful SOAP response XML.

    -- This is a sample of the response XML, but the namespace prefixes will be different.
    -- We can parse the result using "*" for the namespace prefixes (see below).

    DECLARE @REFERENCEQUALIFIER nvarchar(4000)

    DECLARE @REFERENCENUMBER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFERENCENUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:REFERENCENUMBER'
    DECLARE @IDENTIFIER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @IDENTIFIER OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:IDENTIFIER'
    DECLARE @VERSIONNUMBER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @VERSIONNUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:VERSIONNUMBER'
    DECLARE @RELEASENUMBER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @RELEASENUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:RELEASENUMBER'
    DECLARE @CONTROLAGENCY nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @CONTROLAGENCY OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:CONTROLAGENCY'
    DECLARE @ASSOCCODE nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @ASSOCCODE OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:ASSOCCODE'
    DECLARE @ACCESSREF nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @ACCESSREF OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNH|*:ACCESSREF'
    DECLARE @NAME int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @NAME OUT, '*:Body|*:CancelResponse|*:APERAK|*:BGM|*:NAME'
    DECLARE @CODELISTAGENCY int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @CODELISTAGENCY OUT, '*:Body|*:CancelResponse|*:APERAK|*:BGM|*:CODELISTAGENCY'
    DECLARE @DOCUMENTNUMBER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @DOCUMENTNUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:BGM|*:DOCUMENTNUMBER'
    DECLARE @DOCUMENTFUNC int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @DOCUMENTFUNC OUT, '*:Body|*:CancelResponse|*:APERAK|*:BGM|*:DOCUMENTFUNC'
    DECLARE @RESPONSETYPE nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @RESPONSETYPE OUT, '*:Body|*:CancelResponse|*:APERAK|*:BGM|*:RESPONSETYPE'
    DECLARE @DATUMQUALIFIER int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @DATUMQUALIFIER OUT, '*:Body|*:CancelResponse|*:APERAK|*:DTM|*:DATUMQUALIFIER'
    DECLARE @DATUM nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @DATUM OUT, '*:Body|*:CancelResponse|*:APERAK|*:DTM|*:DATUM'
    DECLARE @FORMAT int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @FORMAT OUT, '*:Body|*:CancelResponse|*:APERAK|*:DTM|*:FORMAT'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @responseXml, 'NumChildrenHavingTag', @count_i OUT, '*:Body|*:CancelResponse|*:APERAK|a031:RFF'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @responseXml, 'I', @i
        EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFERENCEQUALIFIER OUT, '*:Body|*:CancelResponse|*:APERAK|*:RFF[i]|*:REFERENCEQUALIFIER'
        EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFERENCENUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:RFF[i]|*:REFERENCENUMBER'
        SELECT @i = @i + 1
      END
    DECLARE @ACTION nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @ACTION OUT, '*:Body|*:CancelResponse|*:APERAK|*:NAD|*:ACTION'
    DECLARE @PARTNER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @PARTNER OUT, '*:Body|*:CancelResponse|*:APERAK|*:NAD|*:PARTNER'
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @CODELISTAGENCY OUT, '*:Body|*:CancelResponse|*:APERAK|*:NAD|*:CODELISTAGENCY'
    DECLARE @ERROR_ID nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @ERROR_ID OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:ERROR_ID'
    DECLARE @AGENCY nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @AGENCY OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:AGENCY'
    DECLARE @TEXT_SUBJECT_QUALIFIER nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @TEXT_SUBJECT_QUALIFIER OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:TEXT_SUBJECT_QUALIFIER'
    DECLARE @FREE_TEXT_CODE int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @FREE_TEXT_CODE OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_CODE'
    DECLARE @FREE_TEXT_VALUE_CODE nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_VALUE_CODE OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_VALUE_CODE'
    DECLARE @CODE_LIST_ID nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @CODE_LIST_ID OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:CODE_LIST_ID'
    DECLARE @strCODELISTAGENCY nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @strCODELISTAGENCY OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:CODELISTAGENCY'
    DECLARE @FREE_TEXT_1 nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_1 OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_1'
    DECLARE @FREE_TEXT_2 nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_2 OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_2'
    DECLARE @FREE_TEXT_3 nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_3 OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_3'
    DECLARE @FREE_TEXT_4 nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_4 OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_4'
    DECLARE @FREE_TEXT_5 nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @FREE_TEXT_5 OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:FTX|*:FREE_TEXT_5'
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFERENCEQUALIFIER OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:RFF|*:REFERENCEQUALIFIER'
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFERENCENUMBER OUT, '*:Body|*:CancelResponse|*:APERAK|*:ERC|*:RFF|*:REFERENCENUMBER'
    DECLARE @NUMSEG int
    EXEC sp_OAMethod @responseXml, 'GetChildIntValue', @NUMSEG OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNT|*:NUMSEG'
    DECLARE @REFNUM nvarchar(4000)
    EXEC sp_OAMethod @responseXml, 'GetChildContent', @REFNUM OUT, '*:Body|*:CancelResponse|*:APERAK|*:UNT|*:REFNUM'

    EXEC @hr = sp_OADestroy @xml
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @responseXml


END
GO

Request XML

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:a031="http://sfera.sk/xmtrade/isom/types/2013/03" xmlns:a03="http://sfera.sk/xmtrade/isom/services/MeasuredValuesOfSupplyAndDeliveryPoints/2013/03">
    <soap:Header/>
    <soap:Body>
        <a03:CancelRequest>
            <a03:UTILMD>
                <a031:UNH>
                    <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                    <a031:IDENTIFIER>UTILMD</a031:IDENTIFIER>
                    <a031:VERSIONNUMBER>D</a031:VERSIONNUMBER>
                    <a031:RELEASENUMBER>01C</a031:RELEASENUMBER>
                    <a031:CONTROLAGENCY>UN</a031:CONTROLAGENCY>
                    <a031:ASSOCCODE>E4SK40</a031:ASSOCCODE>
                    <a031:ACCESSREF>string</a031:ACCESSREF>
                </a031:UNH>
                <a031:BGM>
                    <a031:NAME>string</a031:NAME>
                    <a031:CODELISTAGENCY>260</a031:CODELISTAGENCY>
                    <a031:DOCUMENTNUMBER>string</a031:DOCUMENTNUMBER>
                    <a031:DOCUMENTFUNC>9</a031:DOCUMENTFUNC>
                    <a031:RESPONSETYPE>AB</a031:RESPONSETYPE>
                </a031:BGM>
                <a031:DTM>
                    <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                    <a031:DATUM>string</a031:DATUM>
                    <a031:FORMAT>203</a031:FORMAT>
                </a031:DTM>
                <a031:RFF>
                    <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                    <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                </a031:RFF>
                <a031:NAD>
                    <a031:ACTION>MR</a031:ACTION>
                    <a031:PARTNER>string</a031:PARTNER>
                    <a031:CODELISTAGENCY>305</a031:CODELISTAGENCY>
                    <a031:PARTNERNAME1>string</a031:PARTNERNAME1>
                    <a031:PARTNERNAME2>string</a031:PARTNERNAME2>
                    <a031:STREET1>string</a031:STREET1>
                    <a031:STREET2>string</a031:STREET2>
                    <a031:STREET3>string</a031:STREET3>
                    <a031:STREET4>string</a031:STREET4>
                    <a031:CITY>string</a031:CITY>
                    <a031:COUNTRY>SK</a031:COUNTRY>
                    <a031:LOC>
                        <a031:PLACE_QUALIFIER>172</a031:PLACE_QUALIFIER>
                        <a031:PLACE_ID>string</a031:PLACE_ID>
                        <a031:CODE_LIST_RESPONSIBLE_AGENCY>305</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                        <a031:LIN>
                            <a031:LINE_ITEM_NUMBER>string</a031:LINE_ITEM_NUMBER>
                            <a031:ITEM_NUMBER>string</a031:ITEM_NUMBER>
                            <a031:CODE_LIST_RESPONSIBLE_AGENCY>SKE</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                            <a031:MEA>
                                <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                            </a031:MEA>
                            <a031:QTY>
                                <a031:QUANTITY_QUALIFIER>47</a031:QUANTITY_QUALIFIER>
                                <a031:QUANTITY>string</a031:QUANTITY>
                                <a031:DTM>
                                    <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                                    <a031:DATUM>string</a031:DATUM>
                                    <a031:FORMAT>203</a031:FORMAT>
                                </a031:DTM>
                            </a031:QTY>
                            <a031:CCI>
                                <a031:CHARACTERISTIC_ID>Z03</a031:CHARACTERISTIC_ID>
                                <a031:CODE_LIST_RESPONSIBLE_AGENCY>260</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                                <a031:CAV>
                                    <a031:CHARACTERISTIC_VALUE_CODED>string</a031:CHARACTERISTIC_VALUE_CODED>
                                    <a031:AGENCY>SKE</a031:AGENCY>
                                    <a031:CHARACTERISTIC_VALUE>string</a031:CHARACTERISTIC_VALUE>
                                </a031:CAV>
                                <a031:MEA>
                                    <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                    <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                    <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                                </a031:MEA>
                            </a031:CCI>
                        </a031:LIN>
                    </a031:LOC>
                    <a031:RFF>
                        <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                        <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                    </a031:RFF>
                    <a031:ZIPCODE>string</a031:ZIPCODE>
                </a031:NAD>
                <a031:IDE>
                    <a031:OBJECT_TYPE>24</a031:OBJECT_TYPE>
                    <a031:LOC>
                        <a031:PLACE_QUALIFIER>172</a031:PLACE_QUALIFIER>
                        <a031:PLACE_ID>string</a031:PLACE_ID>
                        <a031:CODE_LIST_RESPONSIBLE_AGENCY>305</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                        <a031:LIN>
                            <a031:LINE_ITEM_NUMBER>string</a031:LINE_ITEM_NUMBER>
                            <a031:ITEM_NUMBER>string</a031:ITEM_NUMBER>
                            <a031:CODE_LIST_RESPONSIBLE_AGENCY>SKE</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                            <a031:MEA>
                                <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                            </a031:MEA>
                            <a031:QTY>
                                <a031:QUANTITY_QUALIFIER>47</a031:QUANTITY_QUALIFIER>
                                <a031:QUANTITY>string</a031:QUANTITY>
                                <a031:DTM>
                                    <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                                    <a031:DATUM>string</a031:DATUM>
                                    <a031:FORMAT>203</a031:FORMAT>
                                </a031:DTM>
                            </a031:QTY>
                            <a031:CCI>
                                <a031:CHARACTERISTIC_ID>Z03</a031:CHARACTERISTIC_ID>
                                <a031:CODE_LIST_RESPONSIBLE_AGENCY>260</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                                <a031:CAV>
                                    <a031:CHARACTERISTIC_VALUE_CODED>string</a031:CHARACTERISTIC_VALUE_CODED>
                                    <a031:AGENCY>SKE</a031:AGENCY>
                                    <a031:CHARACTERISTIC_VALUE>string</a031:CHARACTERISTIC_VALUE>
                                </a031:CAV>
                                <a031:MEA>
                                    <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                    <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                    <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                                </a031:MEA>
                            </a031:CCI>
                        </a031:LIN>
                    </a031:LOC>
                    <a031:DTM>
                        <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                        <a031:DATUM>string</a031:DATUM>
                        <a031:FORMAT>203</a031:FORMAT>
                    </a031:DTM>
                    <a031:PRC>
                        <a031:PROCESS_TYPE>MSG_DETAIL</a031:PROCESS_TYPE>
                        <a031:CODELISTAGENCY>SKE</a031:CODELISTAGENCY>
                    </a031:PRC>
                    <a031:FTX>
                        <a031:TEXT_SUBJECT_QUALIFIER>AAI</a031:TEXT_SUBJECT_QUALIFIER>
                        <a031:FREE_TEXT_CODE>3</a031:FREE_TEXT_CODE>
                        <a031:CODELISTAGENCY>SKE</a031:CODELISTAGENCY>
                        <a031:FREE_TEXT_1>string</a031:FREE_TEXT_1>
                        <a031:FREE_TEXT_2>string</a031:FREE_TEXT_2>
                        <a031:FREE_TEXT_3>string</a031:FREE_TEXT_3>
                        <a031:FREE_TEXT_4>string</a031:FREE_TEXT_4>
                        <a031:FREE_TEXT_5>string</a031:FREE_TEXT_5>
                    </a031:FTX>
                    <a031:AGR>
                        <a031:AGREE_TYPE_ID>11</a031:AGREE_TYPE_ID>
                        <a031:AGREE_TYPE_DESCRIPTION>E01</a031:AGREE_TYPE_DESCRIPTION>
                        <a031:AGREE_TYPE_CODE_LIST>string</a031:AGREE_TYPE_CODE_LIST>
                        <a031:AGREE_TYPE_AGENCY>260</a031:AGREE_TYPE_AGENCY>
                        <a031:AGREE_TYPE>string</a031:AGREE_TYPE>
                    </a031:AGR>
                    <a031:CCI>
                        <a031:CHARACTERISTIC_ID>Z03</a031:CHARACTERISTIC_ID>
                        <a031:CODE_LIST_RESPONSIBLE_AGENCY>260</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                        <a031:CAV>
                            <a031:CHARACTERISTIC_VALUE_CODED>string</a031:CHARACTERISTIC_VALUE_CODED>
                            <a031:AGENCY>SKE</a031:AGENCY>
                            <a031:CHARACTERISTIC_VALUE>string</a031:CHARACTERISTIC_VALUE>
                        </a031:CAV>
                        <a031:MEA>
                            <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                            <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                            <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                        </a031:MEA>
                    </a031:CCI>
                    <a031:NAD>
                        <a031:ACTION>MR</a031:ACTION>
                        <a031:PARTNER>string</a031:PARTNER>
                        <a031:CODELISTAGENCY>305</a031:CODELISTAGENCY>
                        <a031:PARTNERNAME1>string</a031:PARTNERNAME1>
                        <a031:PARTNERNAME2>string</a031:PARTNERNAME2>
                        <a031:STREET1>string</a031:STREET1>
                        <a031:STREET2>string</a031:STREET2>
                        <a031:STREET3>string</a031:STREET3>
                        <a031:STREET4>string</a031:STREET4>
                        <a031:CITY>string</a031:CITY>
                        <a031:COUNTRY>SK</a031:COUNTRY>
                        <a031:LOC>
                            <a031:PLACE_QUALIFIER>172</a031:PLACE_QUALIFIER>
                            <a031:PLACE_ID>string</a031:PLACE_ID>
                            <a031:CODE_LIST_RESPONSIBLE_AGENCY>305</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                            <a031:LIN>
                                <a031:LINE_ITEM_NUMBER>string</a031:LINE_ITEM_NUMBER>
                                <a031:ITEM_NUMBER>string</a031:ITEM_NUMBER>
                                <a031:CODE_LIST_RESPONSIBLE_AGENCY>SKE</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                                <a031:MEA>
                                    <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                    <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                    <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                                </a031:MEA>
                                <a031:QTY>
                                    <a031:QUANTITY_QUALIFIER>47</a031:QUANTITY_QUALIFIER>
                                    <a031:QUANTITY>string</a031:QUANTITY>
                                    <a031:DTM>
                                        <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                                        <a031:DATUM>string</a031:DATUM>
                                        <a031:FORMAT>203</a031:FORMAT>
                                    </a031:DTM>
                                </a031:QTY>
                                <a031:CCI>
                                    <a031:CHARACTERISTIC_ID>Z03</a031:CHARACTERISTIC_ID>
                                    <a031:CODE_LIST_RESPONSIBLE_AGENCY>260</a031:CODE_LIST_RESPONSIBLE_AGENCY>
                                    <a031:CAV>
                                        <a031:CHARACTERISTIC_VALUE_CODED>string</a031:CHARACTERISTIC_VALUE_CODED>
                                        <a031:AGENCY>SKE</a031:AGENCY>
                                        <a031:CHARACTERISTIC_VALUE>string</a031:CHARACTERISTIC_VALUE>
                                    </a031:CAV>
                                    <a031:MEA>
                                        <a031:MEASURMENT_APPLICATION>AAZ</a031:MEASURMENT_APPLICATION>
                                        <a031:MEASURMENT_UNIT_QUALIFIER>KWH</a031:MEASURMENT_UNIT_QUALIFIER>
                                        <a031:MEASURMENT_VALUE>string</a031:MEASURMENT_VALUE>
                                    </a031:MEA>
                                </a031:CCI>
                            </a031:LIN>
                        </a031:LOC>
                        <a031:RFF>
                            <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                            <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                        </a031:RFF>
                        <a031:ZIPCODE>string</a031:ZIPCODE>
                    </a031:NAD>
                </a031:IDE>
                <a031:UNT>
                    <a031:NUMSEG>string</a031:NUMSEG>
                    <a031:REFNUM>string</a031:REFNUM>
                </a031:UNT>
            </a03:UTILMD>
        </a03:CancelRequest>
    </soap:Body>
</soap:Envelope>

Response XML

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:a031="http://sfera.sk/xmtrade/isom/types/2013/03" xmlns:a03="http://sfera.sk/xmtrade/isom/services/MeasuredValuesOfSupplyAndDeliveryPoints/2013/03">
    <soap:Header/>
    <soap:Body>
        <a03:CancelResponse>
            <a03:APERAK>
                <a031:UNH>
                    <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                    <a031:IDENTIFIER>APERAK</a031:IDENTIFIER>
                    <a031:VERSIONNUMBER>D</a031:VERSIONNUMBER>
                    <a031:RELEASENUMBER>96A</a031:RELEASENUMBER>
                    <a031:CONTROLAGENCY>UN</a031:CONTROLAGENCY>
                    <a031:ASSOCCODE>E4SK40</a031:ASSOCCODE>
                    <a031:ACCESSREF>string</a031:ACCESSREF>
                </a031:UNH>
                <a031:BGM>
                    <a031:NAME>799</a031:NAME>
                    <a031:CODELISTAGENCY>260</a031:CODELISTAGENCY>
                    <a031:DOCUMENTNUMBER>string</a031:DOCUMENTNUMBER>
                    <a031:DOCUMENTFUNC>27</a031:DOCUMENTFUNC>
                    <a031:RESPONSETYPE>NA</a031:RESPONSETYPE>
                </a031:BGM>
                <a031:DTM>
                    <a031:DATUMQUALIFIER>92</a031:DATUMQUALIFIER>
                    <a031:DATUM>string</a031:DATUM>
                    <a031:FORMAT>203</a031:FORMAT>
                </a031:DTM>
                <a031:RFF>
                    <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                    <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                </a031:RFF>
                <a031:NAD>
                    <a031:ACTION>MR</a031:ACTION>
                    <a031:PARTNER>string</a031:PARTNER>
                    <a031:CODELISTAGENCY>305</a031:CODELISTAGENCY>
                </a031:NAD>
                <a031:ERC>
                    <a031:ERROR_ID>OK</a031:ERROR_ID>
                    <a031:AGENCY>SKE</a031:AGENCY>
                    <a031:FTX>
                        <a031:TEXT_SUBJECT_QUALIFIER>ACD</a031:TEXT_SUBJECT_QUALIFIER>
                        <a031:FREE_TEXT_CODE>3</a031:FREE_TEXT_CODE>
                        <a031:FREE_TEXT_VALUE_CODE>string</a031:FREE_TEXT_VALUE_CODE>
                        <a031:CODE_LIST_ID>OER</a031:CODE_LIST_ID>
                        <a031:CODELISTAGENCY>SKE</a031:CODELISTAGENCY>
                        <a031:FREE_TEXT_1>string</a031:FREE_TEXT_1>
                        <a031:FREE_TEXT_2>string</a031:FREE_TEXT_2>
                        <a031:FREE_TEXT_3>string</a031:FREE_TEXT_3>
                        <a031:FREE_TEXT_4>string</a031:FREE_TEXT_4>
                        <a031:FREE_TEXT_5>string</a031:FREE_TEXT_5>
                    </a031:FTX>
                    <a031:RFF>
                        <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                        <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                    </a031:RFF>
                </a031:ERC>
                <a031:RFF>
                    <a031:REFERENCEQUALIFIER>ACW</a031:REFERENCEQUALIFIER>
                    <a031:REFERENCENUMBER>string</a031:REFERENCENUMBER>
                </a031:RFF>
                <a031:UNT>
                    <a031:NUMSEG>123</a031:NUMSEG>
                    <a031:REFNUM>string</a031:REFNUM>
                </a031:UNT>
            </a03:APERAK>
        </a03:CancelResponse>
    </soap:Body>
</soap:Envelope>

SOAP WSDL Generate Code

DefaultEndpoint / Cancel

Request XML

Response XML