Chilkat Online Tools

SQL Server / EDS API / Dokuments "Naftas produktu akcīzes nodokļa deklarācija".

Back to Collection Items

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

    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'

    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://eds.vid.gov.lv/api/doc/annv4/:id', @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 @jResp int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT

    EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
    EXEC sp_OASetProperty @jResp, 'EmitCompact', 0


    PRINT 'Response Body:'
    EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    DECLARE @respStatusCode int
    EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT

    PRINT 'Response Status Code = ' + @respStatusCode
    IF @respStatusCode >= 400
      BEGIN

        PRINT 'Response Header:'
        EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
        PRINT @sTmp0

        PRINT 'Failed.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        EXEC @hr = sp_OADestroy @jResp
        RETURN
      END

    -- Sample JSON response:
    -- (Sample code for parsing the JSON response is shown below)

    -- {
    --   "Epasts": "Lorem in eiusmod aliquip voluptate",
    --   "Talrunis": "non deserunt vol",
    --   "Gads": -82184631,
    --   "Menesis": 9,
    --   "Datums": "2000-01-31T00:00:00",
    --   "MaksTerm": "2000-01-31T00:00:00",
    --   "NmStatuss": "pariatur proident",
    --   "R08": "minim",
    --   "R09": "dolore sit velit mollit",
    --   "Sagatavotajs": "ipsum dolor non",
    --   "R10": {
    --     "K1": 16328653.724837586,
    --     "K2": -87950817.9898314,
    --     "K3": 3257414.3665181845,
    --     "K4": 2394689.2126417607,
    --     "K5": -24777365.814456195,
    --     "K6": 18770070.284489423,
    --     "K7": -91784300.62529133,
    --     "K8": 70422771.01527569,
    --     "K9": -61744581.7129465,
    --     "K10": 86719181.78426033,
    --     "K11": 68817542.37522736,
    --     "K12": 17738553.890762135,
    --     "K13": -62589633.93775363,
    --     "K14": -75021119.05898628
    --   },
    --   "R11": {
    --     "K1": -69769058.13043426,
    --     "K2": -22538375.37679124,
    --     "K3": 29341845.91991383,
    --     "K4": -34763994.10235254,
    --     "K5": 25905955.370100304,
    --     "K6": 35927187.79492253,
    --     "K7": 26232897.638250157,
    --     "K8": 45676818.95360184,
    --     "K9": -7741680.646063149,
    --     "K10": 12673528.015534341,
    --     "K11": -16997929.824192896,
    --     "K12": 76869640.18793342,
    --     "K13": 80234821.6924516,
    --     "K14": -66331290.35164833
    --   },
    --   "R12": {
    --     "K1": -87677419.0124578,
    --     "K2": 25420989.805896714,
    --     "K3": 55544761.99298918,
    --     "K4": -4520012.362582192,
    --     "K5": 49608714.00385019,
    --     "K6": -85684047.11885807,
    --     "K7": -14208737.808883637,
    --     "K8": -74685139.35987593,
    --     "K9": 75963902.07094994,
    --     "K10": 33059041.79335788,
    --     "K11": -30102683.49103278,
    --     "K12": 18919426.742815882,
    --     "K13": -48197777.87267841,
    --     "K14": 60477294.91038045
    --   },
    --   "R13": {
    --     "K1": 37996786.06479803,
    --     "K2": -79388460.0479906,
    --     "K3": -50691224.35651625,
    --     "K4": 49668907.75893873,
    --     "K5": -14662552.909173638,
    --     "K6": 7011946.461176023,
    --     "K7": 64045578.6923078,
    --     "K8": 85927610.18557975,
    --     "K9": 72242584.48766556,
    --     "K10": -9367338.82431446,
    --     "K11": 88407209.07040676,
    --     "K12": -82244194.18180972,
    --     "K13": -27869706.705521047,
    --     "K14": -37458512.05595736
    --   },
    --   "R14": {
    --     "K1": -82552340.35908301,
    --     "K2": -76986648.24431378,
    --     "K3": -14183588.083701432,
    --     "K4": -86590588.6036936,
    --     "K5": 81142943.85499617,
    --     "K6": 7373716.631371915,
    --     "K7": -41591381.47619949,
    --     "K8": 86831738.48671126,
    --     "K9": 29043101.68491344,
    --     "K10": -96306803.84246513,
    --     "K11": -39938170.19626902,
    --     "K12": 13214252.948196888,
    --     "K13": -53910787.287705466,
    --     "K14": 75890132.15710837
    --   },
    --   "R15": {
    --     "K1": 56218799.43265244,
    --     "K2": 17484511.11899309,
    --     "K3": 83931780.68462405,
    --     "K4": -77977080.83588928,
    --     "K5": -47522019.41539473,
    --     "K6": 93316753.27175727,
    --     "K7": 94091462.10675386,
    --     "K8": 42147080.01023099,
    --     "K9": -27120036.000980943,
    --     "K10": 3139036.4073375016,
    --     "K11": 74727534.62230012,
    --     "K12": -73090419.95923331,
    --     "K13": -85540072.87872797,
    --     "K14": 8788261.774200782
    --   },
    --   "R16": {
    --     "K1": 95844914.32977328,
    --     "K2": 47519667.90724692,
    --     "K3": 7728179.655423954,
    --     "K4": -8365360.586450025,
    --     "K5": 10599964.662404597,
    --     "K6": -21309629.48953536,
    --     "K7": 2050946.0627980828,
    --     "K8": -85178499.05269709,
    --     "K9": -46504773.23531632,
    --     "K10": 98167003.51412368,
    --     "K11": -60548282.585043676,
    --     "K12": -74085171.35319452,
    --     "K13": -58064063.25406552,
    --     "K14": 42650385.29950726
    --   },
    --   "R17": {
    --     "K1": 65775098.75594056,
    --     "K2": 30696291.135660708,
    --     "K3": -72830309.28755236,
    --     "K4": -96577791.29292314,
    --     "K5": 94802979.22747439,
    --     "K6": -65211786.726446785,
    --     "K7": -28678720.192400277,
    --     "K8": 4629496.269421324,
    --     "K9": 44472928.43451443,
    --     "K10": -37639559.097108364,
    --     "K11": -64463239.43126169,
    --     "K12": 43341913.32631683,
    --     "K13": 34870544.35076398,
    --     "K14": 91513218.17405257
    --   },
    --   "R18": {
    --     "K1": 34623946.292095006,
    --     "K2": -77341977.41821456,
    --     "K3": 88187647.13118777,
    --     "K4": 82828077.92357829,
    --     "K5": -89835481.16541749,
    --     "K6": -61223499.628719755,
    --     "K7": 12645700.801432997,
    --     "K8": 2158960.846409783,
    --     "K9": 79932087.35901889,
    --     "K10": 18599091.86527142,
    --     "K11": 47695563.875030875,
    --     "K12": -33424832.508073978,
    --     "K13": -99519925.48258577,
    --     "K14": 58261675.10968125
    --   },
    --   "R19": {
    --     "K1": -55629509.78202768,
    --     "K2": 94647221.01314664,
    --     "K3": -76028826.04196641,
    --     "K4": 65404013.02994433,
    --     "K5": -49660536.89266783,
    --     "K6": 25273326.973483324,
    --     "K7": 35955896.1050781,
    --     "K8": 11466690.643244743,
    --     "K9": -43277983.55096233,
    --     "K10": -67342785.60243192,
    --     "K11": 93988871.59945258,
    --     "K12": 93940750.65659192,
    --     "K13": -51361665.98857517,
    --     "K14": 78941139.35570145
    --   },
    --   "R21": {
    --     "K1": 27395240.943158686,
    --     "K2": 70606060.86312711,
    --     "K3": -22131413.5372535,
    --     "K4": 85377691.96456128,
    --     "K5": -69741292.71116145,
    --     "K6": -85059526.54666911,
    --     "K7": -24655423.400929302,
    --     "K8": 89254563.010488,
    --     "K9": 49150023.06885788,
    --     "K10": 23179391.624741584,
    --     "K11": 87865688.05695194,
    --     "K12": -2847786.0169280767,
    --     "K13": 91130827.18421376,
    --     "K14": 82068324.82837763
    --   },
    --   "R22": {
    --     "K1": -37953848.45602423,
    --     "K2": 65314700.50226021,
    --     "K3": 60856344.52899012,
    --     "K4": 66185966.26782459,
    --     "K5": -5512935.085172147,
    --     "K6": -99053516.1854766,
    --     "K7": 85592692.61948216,
    --     "K8": 73920831.61064419,
    --     "K9": 23010426.12183605,
    --     "K10": -31701684.100666896,
    --     "K11": 3047137.5906404555,
    --     "K12": -49302373.42979588,
    --     "K13": -25042474.251780033,
    --     "K14": -66006049.109234735
    --   },
    --   "R23": {
    --     "K1": -5767009.382611036,
    --     "K2": 95566182.27854589,
    --     "K3": 68731931.89284873,
    --     "K4": 41152961.15799323,
    --     "K5": -37691179.97197951,
    --     "K6": 37248019.4871507,
    --     "K7": -61783671.811570786,
    --     "K8": -65113835.56219079,
    --     "K9": 86137486.54255477,
    --     "K10": -97604917.38001269,
    --     "K11": 73425712.33905008,
    --     "K12": -59061705.795734555,
    --     "K13": -56881001.57020637,
    --     "K14": -47466125.92793769
    --   },
    --   "R24": {
    --     "K1": -64186291.216494285,
    --     "K2": -83305227.20933442,
    --     "K3": 53503641.04226798,
    --     "K4": -50656608.48282012,
    --     "K5": -25874959.899284855,
    --     "K6": -62644722.089890294,
    --     "K7": 63134394.523483545,
    --     "K8": -59453634.06175947,
    --     "K9": -31060326.300383955,
    --     "K10": -31153766.347998247,
    --     "K11": 89533822.61051491,
    --     "K12": -19243642.19083658,
    --     "K13": 94005029.76220295,
    --     "K14": 44516845.5056757
    --   },
    --   "R25": {
    --     "K1": 92770381.90924597,
    --     "K2": 11570001.736082822,
    --     "K3": -32699195.284047946,
    --     "K4": 47183646.989736915,
    --     "K5": -22710307.495794117,
    --     "K6": 75059937.70602837,
    --     "K7": -43894333.32359518,
    --     "K8": -46158982.57446141,
    --     "K9": -39621091.302581176,
    --     "K10": 66142672.7465778,
    --     "K11": -94763845.84140103,
    --     "K12": -19601754.819558352,
    --     "K13": -68273088.57244864,
    --     "K14": -70021039.05606587
    --   },
    --   "R26": {
    --     "K1": 5479023.058112815,
    --     "K2": -16144148.649422526,
    --     "K3": 92356278.51082578,
    --     "K4": 71937687.4844769,
    --     "K5": -58735251.07325035,
    --     "K6": -78062747.68285051,
    --     "K7": -42538350.474337295,
    --     "K8": 81963948.51947674,
    --     "K9": 50115787.22611162,
    --     "K10": -21279103.95818749,
    --     "K11": 91906699.16348094,
    --     "K12": 8173628.878673881,
    --     "K13": 19599053.827129513,
    --     "K14": -20409830.631593227
    --   },
    --   "R28": {
    --     "K1": 27802824.4817369,
    --     "K2": 57483621.117706686,
    --     "K3": -94055614.35754932,
    --     "K4": 31278615.521112666,
    --     "K5": -57256663.77426109,
    --     "K6": -86284230.47141798,
    --     "K7": -77966924.13428846,
    --     "K8": 29059518.567262903,
    --     "K9": -626417.887666136,
    --     "K10": 16127939.34188512,
    --     "K11": -92741977.60641591,
    --     "K12": -37449230.602469005,
    --     "K13": 23743115.89019072,
    --     "K14": 25348097.465739846
    --   },
    --   "R29": {
    --     "K1": -26805933.001731753,
    --     "K2": 68614109.15667254,
    --     "K3": 39318710.516957104,
    --     "K4": 65114293.695658386,
    --     "K5": 3361705.3758636266,
    --     "K6": -24250737.994428203,
    --     "K7": -24482391.725730762,
    --     "K8": 69213131.07645726,
    --     "K9": 98994516.66830412,
    --     "K10": 16318538.220121413,
    --     "K11": -39487739.918237664,
    --     "K12": 23647693.49156104,
    --     "K13": -42685984.04562951,
    --     "K14": 41164769.500938356
    --   },
    --   "R30": {
    --     "K1": -63256798.03913951,
    --     "K2": 43227214.69477776,
    --     "K3": 79578351.32033616,
    --     "K4": 98818949.30158022,
    --     "K5": 27555041.199536085,
    --     "K6": 88347565.3809239,
    --     "K7": 5235623.800466314,
    --     "K8": 24721617.44543673,
    --     "K9": 7060462.209249213,
    --     "K10": 17991236.655961007,
    --     "K11": -69646182.24027772,
    --     "K12": 36158026.4288972,
    --     "K13": -79383721.70767868,
    --     "K14": 81028976.94582391
    --   },
    --   "R32": {
    --     "K1": 31205521.080257088,
    --     "K2": -12791422.659774244,
    --     "K3": 65063299.81043598,
    --     "K4": 96432860.03663039,
    --     "K5": 24261563.373552784,
    --     "K6": 38756825.458310574,
    --     "K7": -51854073.51408102,
    --     "K8": 7952914.523519799,
    --     "K9": 64386293.989827216,
    --     "K10": 91928227.3491365,
    --     "K11": 50376752.217782915,
    --     "K12": 88220172.05391788,
    --     "K13": 56179167.76171127,
    --     "K14": 13114951.633577794
    --   },
    --   "R33": {
    --     "K1": 6142398.668532684,
    --     "K2": 74213263.48210445,
    --     "K3": 10291611.262824312,
    --     "K4": -469834.8591835201,
    --     "K5": 21967230.55064194,
    --     "K6": 24678138.21367471,
    --     "K7": -6414155.855680585,
    --     "K8": 51617515.31377107,
    --     "K9": 8284031.226150021,
    --     "K10": 37384115.87626752,
    --     "K11": -42756302.25619489,
    --     "K12": -30493572.636986554,
    --     "K13": -78399037.82294405,
    --     "K14": -67537940.57563232
    --   },
    --   "R34": {
    --     "K1": 64857833.56420404,
    --     "K2": -39383123.74424857,
    --     "K3": -57488769.57930183,
    --     "K4": -97456218.11787331,
    --     "K5": 4888285.57401742,
    --     "K6": 47317022.039203346,
    --     "K7": -34053874.08307234,
    --     "K8": -99488372.68254448,
    --     "K9": 5470736.222669229,
    --     "K10": -28197931.342249304,
    --     "K11": -8283463.507176012,
    --     "K12": 26302022.63644965,
    --     "K13": 9780237.253865525,
    --     "K14": -23319176.731722638
    --   },
    --   "R35": {
    --     "K1": 82506019.39402068,
    --     "K2": 631082.3158593327,
    --     "K3": -20836808.962187365,
    --     "K4": -2300894.134821221,
    --     "K5": -40667652.1991391,
    --     "K6": 63042896.616030395,
    --     "K7": 94071690.71470508,
    --     "K8": -25739548.96542205,
    --     "K9": 67142903.6215783,
    --     "K10": 45574581.499938786,
    --     "K11": 81487317.12965742,
    --     "K12": 15577501.990702644,
    --     "K13": 71876456.76464695,
    --     "K14": -56063095.661939144
    --   },
    --   "R37": {
    --     "PielikumsRindai15": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "PielikumsRindai16": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "PielikumsRindai17": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "PielikumsRindai18": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "PielikumsRindai19": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "PielikumsRindai33": {
    --       "Fails": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       "Komentars": {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     },
    --     "CitiDokumenti": [
    --       {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       },
    --       {
    --         "value": "<Error: Too many levels of nesting to fake this schema>"
    --       }
    --     ]
    --   },
    --   "Id": 368338,
    --   "UID": "culpa",
    --   "NmrKods": "proiden",
    --   "Precizejums": true,
    --   "PrecizejamaisDokuments": -7690412,
    --   "PrecizejumaPamatojums": "sit reprehenderit"
    -- }

    -- Sample code for parsing the JSON response...
    -- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

    DECLARE @value nvarchar(4000)

    DECLARE @Epasts nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Epasts OUT, 'Epasts'
    DECLARE @Talrunis nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Talrunis OUT, 'Talrunis'
    DECLARE @Gads int
    EXEC sp_OAMethod @jResp, 'IntOf', @Gads OUT, 'Gads'
    DECLARE @Menesis int
    EXEC sp_OAMethod @jResp, 'IntOf', @Menesis OUT, 'Menesis'
    DECLARE @Datums nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Datums OUT, 'Datums'
    DECLARE @MaksTerm nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MaksTerm OUT, 'MaksTerm'
    DECLARE @NmStatuss nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @NmStatuss OUT, 'NmStatuss'
    DECLARE @R08 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R08 OUT, 'R08'
    DECLARE @R09 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R09 OUT, 'R09'
    DECLARE @Sagatavotajs nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Sagatavotajs OUT, 'Sagatavotajs'
    DECLARE @K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K1 OUT, 'R10.K1'
    DECLARE @K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K2 OUT, 'R10.K2'
    DECLARE @K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K3 OUT, 'R10.K3'
    DECLARE @K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K4 OUT, 'R10.K4'
    DECLARE @K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K5 OUT, 'R10.K5'
    DECLARE @K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K6 OUT, 'R10.K6'
    DECLARE @K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K7 OUT, 'R10.K7'
    DECLARE @K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K8 OUT, 'R10.K8'
    DECLARE @K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K9 OUT, 'R10.K9'
    DECLARE @K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K10 OUT, 'R10.K10'
    DECLARE @K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K11 OUT, 'R10.K11'
    DECLARE @K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K12 OUT, 'R10.K12'
    DECLARE @K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K13 OUT, 'R10.K13'
    DECLARE @K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @K14 OUT, 'R10.K14'
    DECLARE @R11K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K1 OUT, 'R11.K1'
    DECLARE @R11K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K2 OUT, 'R11.K2'
    DECLARE @R11K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K3 OUT, 'R11.K3'
    DECLARE @R11K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K4 OUT, 'R11.K4'
    DECLARE @R11K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K5 OUT, 'R11.K5'
    DECLARE @R11K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K6 OUT, 'R11.K6'
    DECLARE @R11K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K7 OUT, 'R11.K7'
    DECLARE @R11K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K8 OUT, 'R11.K8'
    DECLARE @R11K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K9 OUT, 'R11.K9'
    DECLARE @R11K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K10 OUT, 'R11.K10'
    DECLARE @R11K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K11 OUT, 'R11.K11'
    DECLARE @R11K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K12 OUT, 'R11.K12'
    DECLARE @R11K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K13 OUT, 'R11.K13'
    DECLARE @R11K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R11K14 OUT, 'R11.K14'
    DECLARE @R12K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K1 OUT, 'R12.K1'
    DECLARE @R12K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K2 OUT, 'R12.K2'
    DECLARE @R12K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K3 OUT, 'R12.K3'
    DECLARE @R12K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K4 OUT, 'R12.K4'
    DECLARE @R12K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K5 OUT, 'R12.K5'
    DECLARE @R12K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K6 OUT, 'R12.K6'
    DECLARE @R12K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K7 OUT, 'R12.K7'
    DECLARE @R12K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K8 OUT, 'R12.K8'
    DECLARE @R12K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K9 OUT, 'R12.K9'
    DECLARE @R12K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K10 OUT, 'R12.K10'
    DECLARE @R12K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K11 OUT, 'R12.K11'
    DECLARE @R12K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K12 OUT, 'R12.K12'
    DECLARE @R12K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K13 OUT, 'R12.K13'
    DECLARE @R12K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R12K14 OUT, 'R12.K14'
    DECLARE @R13K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K1 OUT, 'R13.K1'
    DECLARE @R13K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K2 OUT, 'R13.K2'
    DECLARE @R13K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K3 OUT, 'R13.K3'
    DECLARE @R13K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K4 OUT, 'R13.K4'
    DECLARE @R13K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K5 OUT, 'R13.K5'
    DECLARE @R13K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K6 OUT, 'R13.K6'
    DECLARE @R13K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K7 OUT, 'R13.K7'
    DECLARE @R13K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K8 OUT, 'R13.K8'
    DECLARE @R13K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K9 OUT, 'R13.K9'
    DECLARE @R13K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K10 OUT, 'R13.K10'
    DECLARE @R13K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K11 OUT, 'R13.K11'
    DECLARE @R13K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K12 OUT, 'R13.K12'
    DECLARE @R13K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K13 OUT, 'R13.K13'
    DECLARE @R13K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R13K14 OUT, 'R13.K14'
    DECLARE @R14K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K1 OUT, 'R14.K1'
    DECLARE @R14K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K2 OUT, 'R14.K2'
    DECLARE @R14K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K3 OUT, 'R14.K3'
    DECLARE @R14K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K4 OUT, 'R14.K4'
    DECLARE @R14K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K5 OUT, 'R14.K5'
    DECLARE @R14K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K6 OUT, 'R14.K6'
    DECLARE @R14K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K7 OUT, 'R14.K7'
    DECLARE @R14K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K8 OUT, 'R14.K8'
    DECLARE @R14K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K9 OUT, 'R14.K9'
    DECLARE @R14K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K10 OUT, 'R14.K10'
    DECLARE @R14K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K11 OUT, 'R14.K11'
    DECLARE @R14K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K12 OUT, 'R14.K12'
    DECLARE @R14K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K13 OUT, 'R14.K13'
    DECLARE @R14K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R14K14 OUT, 'R14.K14'
    DECLARE @R15K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K1 OUT, 'R15.K1'
    DECLARE @R15K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K2 OUT, 'R15.K2'
    DECLARE @R15K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K3 OUT, 'R15.K3'
    DECLARE @R15K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K4 OUT, 'R15.K4'
    DECLARE @R15K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K5 OUT, 'R15.K5'
    DECLARE @R15K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K6 OUT, 'R15.K6'
    DECLARE @R15K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K7 OUT, 'R15.K7'
    DECLARE @R15K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K8 OUT, 'R15.K8'
    DECLARE @R15K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K9 OUT, 'R15.K9'
    DECLARE @R15K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K10 OUT, 'R15.K10'
    DECLARE @R15K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K11 OUT, 'R15.K11'
    DECLARE @R15K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K12 OUT, 'R15.K12'
    DECLARE @R15K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K13 OUT, 'R15.K13'
    DECLARE @R15K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R15K14 OUT, 'R15.K14'
    DECLARE @R16K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K1 OUT, 'R16.K1'
    DECLARE @R16K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K2 OUT, 'R16.K2'
    DECLARE @R16K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K3 OUT, 'R16.K3'
    DECLARE @R16K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K4 OUT, 'R16.K4'
    DECLARE @R16K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K5 OUT, 'R16.K5'
    DECLARE @R16K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K6 OUT, 'R16.K6'
    DECLARE @R16K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K7 OUT, 'R16.K7'
    DECLARE @R16K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K8 OUT, 'R16.K8'
    DECLARE @R16K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K9 OUT, 'R16.K9'
    DECLARE @R16K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K10 OUT, 'R16.K10'
    DECLARE @R16K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K11 OUT, 'R16.K11'
    DECLARE @R16K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K12 OUT, 'R16.K12'
    DECLARE @R16K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K13 OUT, 'R16.K13'
    DECLARE @R16K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R16K14 OUT, 'R16.K14'
    DECLARE @R17K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K1 OUT, 'R17.K1'
    DECLARE @R17K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K2 OUT, 'R17.K2'
    DECLARE @R17K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K3 OUT, 'R17.K3'
    DECLARE @R17K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K4 OUT, 'R17.K4'
    DECLARE @R17K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K5 OUT, 'R17.K5'
    DECLARE @R17K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K6 OUT, 'R17.K6'
    DECLARE @R17K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K7 OUT, 'R17.K7'
    DECLARE @R17K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K8 OUT, 'R17.K8'
    DECLARE @R17K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K9 OUT, 'R17.K9'
    DECLARE @R17K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K10 OUT, 'R17.K10'
    DECLARE @R17K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K11 OUT, 'R17.K11'
    DECLARE @R17K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K12 OUT, 'R17.K12'
    DECLARE @R17K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K13 OUT, 'R17.K13'
    DECLARE @R17K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R17K14 OUT, 'R17.K14'
    DECLARE @R18K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K1 OUT, 'R18.K1'
    DECLARE @R18K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K2 OUT, 'R18.K2'
    DECLARE @R18K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K3 OUT, 'R18.K3'
    DECLARE @R18K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K4 OUT, 'R18.K4'
    DECLARE @R18K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K5 OUT, 'R18.K5'
    DECLARE @R18K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K6 OUT, 'R18.K6'
    DECLARE @R18K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K7 OUT, 'R18.K7'
    DECLARE @R18K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K8 OUT, 'R18.K8'
    DECLARE @R18K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K9 OUT, 'R18.K9'
    DECLARE @R18K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K10 OUT, 'R18.K10'
    DECLARE @R18K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K11 OUT, 'R18.K11'
    DECLARE @R18K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K12 OUT, 'R18.K12'
    DECLARE @R18K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K13 OUT, 'R18.K13'
    DECLARE @R18K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R18K14 OUT, 'R18.K14'
    DECLARE @R19K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K1 OUT, 'R19.K1'
    DECLARE @R19K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K2 OUT, 'R19.K2'
    DECLARE @R19K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K3 OUT, 'R19.K3'
    DECLARE @R19K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K4 OUT, 'R19.K4'
    DECLARE @R19K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K5 OUT, 'R19.K5'
    DECLARE @R19K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K6 OUT, 'R19.K6'
    DECLARE @R19K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K7 OUT, 'R19.K7'
    DECLARE @R19K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K8 OUT, 'R19.K8'
    DECLARE @R19K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K9 OUT, 'R19.K9'
    DECLARE @R19K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K10 OUT, 'R19.K10'
    DECLARE @R19K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K11 OUT, 'R19.K11'
    DECLARE @R19K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K12 OUT, 'R19.K12'
    DECLARE @R19K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K13 OUT, 'R19.K13'
    DECLARE @R19K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R19K14 OUT, 'R19.K14'
    DECLARE @R21K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K1 OUT, 'R21.K1'
    DECLARE @R21K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K2 OUT, 'R21.K2'
    DECLARE @R21K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K3 OUT, 'R21.K3'
    DECLARE @R21K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K4 OUT, 'R21.K4'
    DECLARE @R21K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K5 OUT, 'R21.K5'
    DECLARE @R21K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K6 OUT, 'R21.K6'
    DECLARE @R21K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K7 OUT, 'R21.K7'
    DECLARE @R21K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K8 OUT, 'R21.K8'
    DECLARE @R21K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K9 OUT, 'R21.K9'
    DECLARE @R21K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K10 OUT, 'R21.K10'
    DECLARE @R21K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K11 OUT, 'R21.K11'
    DECLARE @R21K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K12 OUT, 'R21.K12'
    DECLARE @R21K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K13 OUT, 'R21.K13'
    DECLARE @R21K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R21K14 OUT, 'R21.K14'
    DECLARE @R22K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K1 OUT, 'R22.K1'
    DECLARE @R22K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K2 OUT, 'R22.K2'
    DECLARE @R22K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K3 OUT, 'R22.K3'
    DECLARE @R22K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K4 OUT, 'R22.K4'
    DECLARE @R22K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K5 OUT, 'R22.K5'
    DECLARE @R22K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K6 OUT, 'R22.K6'
    DECLARE @R22K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K7 OUT, 'R22.K7'
    DECLARE @R22K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K8 OUT, 'R22.K8'
    DECLARE @R22K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K9 OUT, 'R22.K9'
    DECLARE @R22K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K10 OUT, 'R22.K10'
    DECLARE @R22K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K11 OUT, 'R22.K11'
    DECLARE @R22K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K12 OUT, 'R22.K12'
    DECLARE @R22K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K13 OUT, 'R22.K13'
    DECLARE @R22K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R22K14 OUT, 'R22.K14'
    DECLARE @R23K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K1 OUT, 'R23.K1'
    DECLARE @R23K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K2 OUT, 'R23.K2'
    DECLARE @R23K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K3 OUT, 'R23.K3'
    DECLARE @R23K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K4 OUT, 'R23.K4'
    DECLARE @R23K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K5 OUT, 'R23.K5'
    DECLARE @R23K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K6 OUT, 'R23.K6'
    DECLARE @R23K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K7 OUT, 'R23.K7'
    DECLARE @R23K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K8 OUT, 'R23.K8'
    DECLARE @R23K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K9 OUT, 'R23.K9'
    DECLARE @R23K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K10 OUT, 'R23.K10'
    DECLARE @R23K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K11 OUT, 'R23.K11'
    DECLARE @R23K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K12 OUT, 'R23.K12'
    DECLARE @R23K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K13 OUT, 'R23.K13'
    DECLARE @R23K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R23K14 OUT, 'R23.K14'
    DECLARE @R24K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K1 OUT, 'R24.K1'
    DECLARE @R24K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K2 OUT, 'R24.K2'
    DECLARE @R24K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K3 OUT, 'R24.K3'
    DECLARE @R24K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K4 OUT, 'R24.K4'
    DECLARE @R24K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K5 OUT, 'R24.K5'
    DECLARE @R24K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K6 OUT, 'R24.K6'
    DECLARE @R24K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K7 OUT, 'R24.K7'
    DECLARE @R24K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K8 OUT, 'R24.K8'
    DECLARE @R24K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K9 OUT, 'R24.K9'
    DECLARE @R24K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K10 OUT, 'R24.K10'
    DECLARE @R24K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K11 OUT, 'R24.K11'
    DECLARE @R24K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K12 OUT, 'R24.K12'
    DECLARE @R24K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K13 OUT, 'R24.K13'
    DECLARE @R24K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R24K14 OUT, 'R24.K14'
    DECLARE @R25K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K1 OUT, 'R25.K1'
    DECLARE @R25K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K2 OUT, 'R25.K2'
    DECLARE @R25K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K3 OUT, 'R25.K3'
    DECLARE @R25K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K4 OUT, 'R25.K4'
    DECLARE @R25K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K5 OUT, 'R25.K5'
    DECLARE @R25K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K6 OUT, 'R25.K6'
    DECLARE @R25K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K7 OUT, 'R25.K7'
    DECLARE @R25K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K8 OUT, 'R25.K8'
    DECLARE @R25K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K9 OUT, 'R25.K9'
    DECLARE @R25K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K10 OUT, 'R25.K10'
    DECLARE @R25K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K11 OUT, 'R25.K11'
    DECLARE @R25K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K12 OUT, 'R25.K12'
    DECLARE @R25K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K13 OUT, 'R25.K13'
    DECLARE @R25K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R25K14 OUT, 'R25.K14'
    DECLARE @R26K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K1 OUT, 'R26.K1'
    DECLARE @R26K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K2 OUT, 'R26.K2'
    DECLARE @R26K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K3 OUT, 'R26.K3'
    DECLARE @R26K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K4 OUT, 'R26.K4'
    DECLARE @R26K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K5 OUT, 'R26.K5'
    DECLARE @R26K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K6 OUT, 'R26.K6'
    DECLARE @R26K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K7 OUT, 'R26.K7'
    DECLARE @R26K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K8 OUT, 'R26.K8'
    DECLARE @R26K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K9 OUT, 'R26.K9'
    DECLARE @R26K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K10 OUT, 'R26.K10'
    DECLARE @R26K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K11 OUT, 'R26.K11'
    DECLARE @R26K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K12 OUT, 'R26.K12'
    DECLARE @R26K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K13 OUT, 'R26.K13'
    DECLARE @R26K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R26K14 OUT, 'R26.K14'
    DECLARE @R28K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K1 OUT, 'R28.K1'
    DECLARE @R28K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K2 OUT, 'R28.K2'
    DECLARE @R28K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K3 OUT, 'R28.K3'
    DECLARE @R28K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K4 OUT, 'R28.K4'
    DECLARE @R28K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K5 OUT, 'R28.K5'
    DECLARE @R28K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K6 OUT, 'R28.K6'
    DECLARE @R28K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K7 OUT, 'R28.K7'
    DECLARE @R28K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K8 OUT, 'R28.K8'
    DECLARE @R28K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K9 OUT, 'R28.K9'
    DECLARE @R28K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K10 OUT, 'R28.K10'
    DECLARE @R28K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K11 OUT, 'R28.K11'
    DECLARE @R28K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K12 OUT, 'R28.K12'
    DECLARE @R28K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K13 OUT, 'R28.K13'
    DECLARE @R28K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R28K14 OUT, 'R28.K14'
    DECLARE @R29K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K1 OUT, 'R29.K1'
    DECLARE @R29K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K2 OUT, 'R29.K2'
    DECLARE @R29K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K3 OUT, 'R29.K3'
    DECLARE @R29K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K4 OUT, 'R29.K4'
    DECLARE @R29K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K5 OUT, 'R29.K5'
    DECLARE @R29K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K6 OUT, 'R29.K6'
    DECLARE @R29K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K7 OUT, 'R29.K7'
    DECLARE @R29K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K8 OUT, 'R29.K8'
    DECLARE @R29K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K9 OUT, 'R29.K9'
    DECLARE @R29K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K10 OUT, 'R29.K10'
    DECLARE @R29K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K11 OUT, 'R29.K11'
    DECLARE @R29K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K12 OUT, 'R29.K12'
    DECLARE @R29K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K13 OUT, 'R29.K13'
    DECLARE @R29K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R29K14 OUT, 'R29.K14'
    DECLARE @R30K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K1 OUT, 'R30.K1'
    DECLARE @R30K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K2 OUT, 'R30.K2'
    DECLARE @R30K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K3 OUT, 'R30.K3'
    DECLARE @R30K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K4 OUT, 'R30.K4'
    DECLARE @R30K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K5 OUT, 'R30.K5'
    DECLARE @R30K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K6 OUT, 'R30.K6'
    DECLARE @R30K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K7 OUT, 'R30.K7'
    DECLARE @R30K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K8 OUT, 'R30.K8'
    DECLARE @R30K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K9 OUT, 'R30.K9'
    DECLARE @R30K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K10 OUT, 'R30.K10'
    DECLARE @R30K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K11 OUT, 'R30.K11'
    DECLARE @R30K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K12 OUT, 'R30.K12'
    DECLARE @R30K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K13 OUT, 'R30.K13'
    DECLARE @R30K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R30K14 OUT, 'R30.K14'
    DECLARE @R32K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K1 OUT, 'R32.K1'
    DECLARE @R32K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K2 OUT, 'R32.K2'
    DECLARE @R32K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K3 OUT, 'R32.K3'
    DECLARE @R32K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K4 OUT, 'R32.K4'
    DECLARE @R32K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K5 OUT, 'R32.K5'
    DECLARE @R32K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K6 OUT, 'R32.K6'
    DECLARE @R32K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K7 OUT, 'R32.K7'
    DECLARE @R32K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K8 OUT, 'R32.K8'
    DECLARE @R32K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K9 OUT, 'R32.K9'
    DECLARE @R32K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K10 OUT, 'R32.K10'
    DECLARE @R32K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K11 OUT, 'R32.K11'
    DECLARE @R32K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K12 OUT, 'R32.K12'
    DECLARE @R32K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K13 OUT, 'R32.K13'
    DECLARE @R32K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R32K14 OUT, 'R32.K14'
    DECLARE @R33K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K1 OUT, 'R33.K1'
    DECLARE @R33K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K2 OUT, 'R33.K2'
    DECLARE @R33K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K3 OUT, 'R33.K3'
    DECLARE @R33K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K4 OUT, 'R33.K4'
    DECLARE @R33K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K5 OUT, 'R33.K5'
    DECLARE @R33K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K6 OUT, 'R33.K6'
    DECLARE @R33K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K7 OUT, 'R33.K7'
    DECLARE @R33K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K8 OUT, 'R33.K8'
    DECLARE @R33K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K9 OUT, 'R33.K9'
    DECLARE @R33K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K10 OUT, 'R33.K10'
    DECLARE @R33K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K11 OUT, 'R33.K11'
    DECLARE @R33K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K12 OUT, 'R33.K12'
    DECLARE @R33K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K13 OUT, 'R33.K13'
    DECLARE @R33K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R33K14 OUT, 'R33.K14'
    DECLARE @R34K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K1 OUT, 'R34.K1'
    DECLARE @R34K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K2 OUT, 'R34.K2'
    DECLARE @R34K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K3 OUT, 'R34.K3'
    DECLARE @R34K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K4 OUT, 'R34.K4'
    DECLARE @R34K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K5 OUT, 'R34.K5'
    DECLARE @R34K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K6 OUT, 'R34.K6'
    DECLARE @R34K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K7 OUT, 'R34.K7'
    DECLARE @R34K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K8 OUT, 'R34.K8'
    DECLARE @R34K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K9 OUT, 'R34.K9'
    DECLARE @R34K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K10 OUT, 'R34.K10'
    DECLARE @R34K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K11 OUT, 'R34.K11'
    DECLARE @R34K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K12 OUT, 'R34.K12'
    DECLARE @R34K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K13 OUT, 'R34.K13'
    DECLARE @R34K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R34K14 OUT, 'R34.K14'
    DECLARE @R35K1 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K1 OUT, 'R35.K1'
    DECLARE @R35K2 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K2 OUT, 'R35.K2'
    DECLARE @R35K3 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K3 OUT, 'R35.K3'
    DECLARE @R35K4 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K4 OUT, 'R35.K4'
    DECLARE @R35K5 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K5 OUT, 'R35.K5'
    DECLARE @R35K6 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K6 OUT, 'R35.K6'
    DECLARE @R35K7 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K7 OUT, 'R35.K7'
    DECLARE @R35K8 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K8 OUT, 'R35.K8'
    DECLARE @R35K9 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K9 OUT, 'R35.K9'
    DECLARE @R35K10 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K10 OUT, 'R35.K10'
    DECLARE @R35K11 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K11 OUT, 'R35.K11'
    DECLARE @R35K12 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K12 OUT, 'R35.K12'
    DECLARE @R35K13 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K13 OUT, 'R35.K13'
    DECLARE @R35K14 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @R35K14 OUT, 'R35.K14'
    DECLARE @Value nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'R37.PielikumsRindai15.Fails.value'
    DECLARE @KomentarsValue nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai15.Komentars.value'
    DECLARE @FailsValue nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R37.PielikumsRindai16.Fails.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai16.Komentars.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R37.PielikumsRindai17.Fails.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai17.Komentars.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R37.PielikumsRindai18.Fails.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai18.Komentars.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R37.PielikumsRindai19.Fails.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai19.Komentars.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R37.PielikumsRindai33.Fails.value'
    EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R37.PielikumsRindai33.Komentars.value'
    DECLARE @Id int
    EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'Id'
    DECLARE @UID nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @UID OUT, 'UID'
    DECLARE @NmrKods nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @NmrKods OUT, 'NmrKods'
    DECLARE @Precizejums int
    EXEC sp_OAMethod @jResp, 'BoolOf', @Precizejums OUT, 'Precizejums'
    DECLARE @PrecizejamaisDokuments int
    EXEC sp_OAMethod @jResp, 'IntOf', @PrecizejamaisDokuments OUT, 'PrecizejamaisDokuments'
    DECLARE @PrecizejumaPamatojums nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @PrecizejumaPamatojums OUT, 'PrecizejumaPamatojums'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R37.CitiDokumenti'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R37.CitiDokumenti[i].value'
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @jResp


END
GO

Curl Command

curl -X GET
	-H "Accept: application/json"
https://eds.vid.gov.lv/api/doc/annv4/:id

Postman Collection Item JSON

{
  "name": "Dokuments \"Naftas produktu akcīzes nodokļa deklarācija\".",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/doc/annv4/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "doc",
        "annv4",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "25210683",
          "description": "(Required) Dokumenta id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv4/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv4",
            ":id"
          ],
          "variable": [
            {
              "key": "id",
              "value": "25210683",
              "description": "(Required) Dokumenta id."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"Epasts\": \"Lorem in eiusmod aliquip voluptate\",\n  \"Talrunis\": \"non deserunt vol\",\n  \"Gads\": -82184631,\n  \"Menesis\": 9,\n  \"Datums\": \"2000-01-31T00:00:00\",\n  \"MaksTerm\": \"2000-01-31T00:00:00\",\n  \"NmStatuss\": \"pariatur proident\",\n  \"R08\": \"minim\",\n  \"R09\": \"dolore sit velit mollit\",\n  \"Sagatavotajs\": \"ipsum dolor non\",\n  \"R10\": {\n    \"K1\": 16328653.724837586,\n    \"K2\": -87950817.9898314,\n    \"K3\": 3257414.3665181845,\n    \"K4\": 2394689.2126417607,\n    \"K5\": -24777365.814456195,\n    \"K6\": 18770070.284489423,\n    \"K7\": -91784300.62529133,\n    \"K8\": 70422771.01527569,\n    \"K9\": -61744581.7129465,\n    \"K10\": 86719181.78426033,\n    \"K11\": 68817542.37522736,\n    \"K12\": 17738553.890762135,\n    \"K13\": -62589633.93775363,\n    \"K14\": -75021119.05898628\n  },\n  \"R11\": {\n    \"K1\": -69769058.13043426,\n    \"K2\": -22538375.37679124,\n    \"K3\": 29341845.91991383,\n    \"K4\": -34763994.10235254,\n    \"K5\": 25905955.370100304,\n    \"K6\": 35927187.79492253,\n    \"K7\": 26232897.638250157,\n    \"K8\": 45676818.95360184,\n    \"K9\": -7741680.646063149,\n    \"K10\": 12673528.015534341,\n    \"K11\": -16997929.824192896,\n    \"K12\": 76869640.18793342,\n    \"K13\": 80234821.6924516,\n    \"K14\": -66331290.35164833\n  },\n  \"R12\": {\n    \"K1\": -87677419.0124578,\n    \"K2\": 25420989.805896714,\n    \"K3\": 55544761.99298918,\n    \"K4\": -4520012.362582192,\n    \"K5\": 49608714.00385019,\n    \"K6\": -85684047.11885807,\n    \"K7\": -14208737.808883637,\n    \"K8\": -74685139.35987593,\n    \"K9\": 75963902.07094994,\n    \"K10\": 33059041.79335788,\n    \"K11\": -30102683.49103278,\n    \"K12\": 18919426.742815882,\n    \"K13\": -48197777.87267841,\n    \"K14\": 60477294.91038045\n  },\n  \"R13\": {\n    \"K1\": 37996786.06479803,\n    \"K2\": -79388460.0479906,\n    \"K3\": -50691224.35651625,\n    \"K4\": 49668907.75893873,\n    \"K5\": -14662552.909173638,\n    \"K6\": 7011946.461176023,\n    \"K7\": 64045578.6923078,\n    \"K8\": 85927610.18557975,\n    \"K9\": 72242584.48766556,\n    \"K10\": -9367338.82431446,\n    \"K11\": 88407209.07040676,\n    \"K12\": -82244194.18180972,\n    \"K13\": -27869706.705521047,\n    \"K14\": -37458512.05595736\n  },\n  \"R14\": {\n    \"K1\": -82552340.35908301,\n    \"K2\": -76986648.24431378,\n    \"K3\": -14183588.083701432,\n    \"K4\": -86590588.6036936,\n    \"K5\": 81142943.85499617,\n    \"K6\": 7373716.631371915,\n    \"K7\": -41591381.47619949,\n    \"K8\": 86831738.48671126,\n    \"K9\": 29043101.68491344,\n    \"K10\": -96306803.84246513,\n    \"K11\": -39938170.19626902,\n    \"K12\": 13214252.948196888,\n    \"K13\": -53910787.287705466,\n    \"K14\": 75890132.15710837\n  },\n  \"R15\": {\n    \"K1\": 56218799.43265244,\n    \"K2\": 17484511.11899309,\n    \"K3\": 83931780.68462405,\n    \"K4\": -77977080.83588928,\n    \"K5\": -47522019.41539473,\n    \"K6\": 93316753.27175727,\n    \"K7\": 94091462.10675386,\n    \"K8\": 42147080.01023099,\n    \"K9\": -27120036.000980943,\n    \"K10\": 3139036.4073375016,\n    \"K11\": 74727534.62230012,\n    \"K12\": -73090419.95923331,\n    \"K13\": -85540072.87872797,\n    \"K14\": 8788261.774200782\n  },\n  \"R16\": {\n    \"K1\": 95844914.32977328,\n    \"K2\": 47519667.90724692,\n    \"K3\": 7728179.655423954,\n    \"K4\": -8365360.586450025,\n    \"K5\": 10599964.662404597,\n    \"K6\": -21309629.48953536,\n    \"K7\": 2050946.0627980828,\n    \"K8\": -85178499.05269709,\n    \"K9\": -46504773.23531632,\n    \"K10\": 98167003.51412368,\n    \"K11\": -60548282.585043676,\n    \"K12\": -74085171.35319452,\n    \"K13\": -58064063.25406552,\n    \"K14\": 42650385.29950726\n  },\n  \"R17\": {\n    \"K1\": 65775098.75594056,\n    \"K2\": 30696291.135660708,\n    \"K3\": -72830309.28755236,\n    \"K4\": -96577791.29292314,\n    \"K5\": 94802979.22747439,\n    \"K6\": -65211786.726446785,\n    \"K7\": -28678720.192400277,\n    \"K8\": 4629496.269421324,\n    \"K9\": 44472928.43451443,\n    \"K10\": -37639559.097108364,\n    \"K11\": -64463239.43126169,\n    \"K12\": 43341913.32631683,\n    \"K13\": 34870544.35076398,\n    \"K14\": 91513218.17405257\n  },\n  \"R18\": {\n    \"K1\": 34623946.292095006,\n    \"K2\": -77341977.41821456,\n    \"K3\": 88187647.13118777,\n    \"K4\": 82828077.92357829,\n    \"K5\": -89835481.16541749,\n    \"K6\": -61223499.628719755,\n    \"K7\": 12645700.801432997,\n    \"K8\": 2158960.846409783,\n    \"K9\": 79932087.35901889,\n    \"K10\": 18599091.86527142,\n    \"K11\": 47695563.875030875,\n    \"K12\": -33424832.508073978,\n    \"K13\": -99519925.48258577,\n    \"K14\": 58261675.10968125\n  },\n  \"R19\": {\n    \"K1\": -55629509.78202768,\n    \"K2\": 94647221.01314664,\n    \"K3\": -76028826.04196641,\n    \"K4\": 65404013.02994433,\n    \"K5\": -49660536.89266783,\n    \"K6\": 25273326.973483324,\n    \"K7\": 35955896.1050781,\n    \"K8\": 11466690.643244743,\n    \"K9\": -43277983.55096233,\n    \"K10\": -67342785.60243192,\n    \"K11\": 93988871.59945258,\n    \"K12\": 93940750.65659192,\n    \"K13\": -51361665.98857517,\n    \"K14\": 78941139.35570145\n  },\n  \"R21\": {\n    \"K1\": 27395240.943158686,\n    \"K2\": 70606060.86312711,\n    \"K3\": -22131413.5372535,\n    \"K4\": 85377691.96456128,\n    \"K5\": -69741292.71116145,\n    \"K6\": -85059526.54666911,\n    \"K7\": -24655423.400929302,\n    \"K8\": 89254563.010488,\n    \"K9\": 49150023.06885788,\n    \"K10\": 23179391.624741584,\n    \"K11\": 87865688.05695194,\n    \"K12\": -2847786.0169280767,\n    \"K13\": 91130827.18421376,\n    \"K14\": 82068324.82837763\n  },\n  \"R22\": {\n    \"K1\": -37953848.45602423,\n    \"K2\": 65314700.50226021,\n    \"K3\": 60856344.52899012,\n    \"K4\": 66185966.26782459,\n    \"K5\": -5512935.085172147,\n    \"K6\": -99053516.1854766,\n    \"K7\": 85592692.61948216,\n    \"K8\": 73920831.61064419,\n    \"K9\": 23010426.12183605,\n    \"K10\": -31701684.100666896,\n    \"K11\": 3047137.5906404555,\n    \"K12\": -49302373.42979588,\n    \"K13\": -25042474.251780033,\n    \"K14\": -66006049.109234735\n  },\n  \"R23\": {\n    \"K1\": -5767009.382611036,\n    \"K2\": 95566182.27854589,\n    \"K3\": 68731931.89284873,\n    \"K4\": 41152961.15799323,\n    \"K5\": -37691179.97197951,\n    \"K6\": 37248019.4871507,\n    \"K7\": -61783671.811570786,\n    \"K8\": -65113835.56219079,\n    \"K9\": 86137486.54255477,\n    \"K10\": -97604917.38001269,\n    \"K11\": 73425712.33905008,\n    \"K12\": -59061705.795734555,\n    \"K13\": -56881001.57020637,\n    \"K14\": -47466125.92793769\n  },\n  \"R24\": {\n    \"K1\": -64186291.216494285,\n    \"K2\": -83305227.20933442,\n    \"K3\": 53503641.04226798,\n    \"K4\": -50656608.48282012,\n    \"K5\": -25874959.899284855,\n    \"K6\": -62644722.089890294,\n    \"K7\": 63134394.523483545,\n    \"K8\": -59453634.06175947,\n    \"K9\": -31060326.300383955,\n    \"K10\": -31153766.347998247,\n    \"K11\": 89533822.61051491,\n    \"K12\": -19243642.19083658,\n    \"K13\": 94005029.76220295,\n    \"K14\": 44516845.5056757\n  },\n  \"R25\": {\n    \"K1\": 92770381.90924597,\n    \"K2\": 11570001.736082822,\n    \"K3\": -32699195.284047946,\n    \"K4\": 47183646.989736915,\n    \"K5\": -22710307.495794117,\n    \"K6\": 75059937.70602837,\n    \"K7\": -43894333.32359518,\n    \"K8\": -46158982.57446141,\n    \"K9\": -39621091.302581176,\n    \"K10\": 66142672.7465778,\n    \"K11\": -94763845.84140103,\n    \"K12\": -19601754.819558352,\n    \"K13\": -68273088.57244864,\n    \"K14\": -70021039.05606587\n  },\n  \"R26\": {\n    \"K1\": 5479023.058112815,\n    \"K2\": -16144148.649422526,\n    \"K3\": 92356278.51082578,\n    \"K4\": 71937687.4844769,\n    \"K5\": -58735251.07325035,\n    \"K6\": -78062747.68285051,\n    \"K7\": -42538350.474337295,\n    \"K8\": 81963948.51947674,\n    \"K9\": 50115787.22611162,\n    \"K10\": -21279103.95818749,\n    \"K11\": 91906699.16348094,\n    \"K12\": 8173628.878673881,\n    \"K13\": 19599053.827129513,\n    \"K14\": -20409830.631593227\n  },\n  \"R28\": {\n    \"K1\": 27802824.4817369,\n    \"K2\": 57483621.117706686,\n    \"K3\": -94055614.35754932,\n    \"K4\": 31278615.521112666,\n    \"K5\": -57256663.77426109,\n    \"K6\": -86284230.47141798,\n    \"K7\": -77966924.13428846,\n    \"K8\": 29059518.567262903,\n    \"K9\": -626417.887666136,\n    \"K10\": 16127939.34188512,\n    \"K11\": -92741977.60641591,\n    \"K12\": -37449230.602469005,\n    \"K13\": 23743115.89019072,\n    \"K14\": 25348097.465739846\n  },\n  \"R29\": {\n    \"K1\": -26805933.001731753,\n    \"K2\": 68614109.15667254,\n    \"K3\": 39318710.516957104,\n    \"K4\": 65114293.695658386,\n    \"K5\": 3361705.3758636266,\n    \"K6\": -24250737.994428203,\n    \"K7\": -24482391.725730762,\n    \"K8\": 69213131.07645726,\n    \"K9\": 98994516.66830412,\n    \"K10\": 16318538.220121413,\n    \"K11\": -39487739.918237664,\n    \"K12\": 23647693.49156104,\n    \"K13\": -42685984.04562951,\n    \"K14\": 41164769.500938356\n  },\n  \"R30\": {\n    \"K1\": -63256798.03913951,\n    \"K2\": 43227214.69477776,\n    \"K3\": 79578351.32033616,\n    \"K4\": 98818949.30158022,\n    \"K5\": 27555041.199536085,\n    \"K6\": 88347565.3809239,\n    \"K7\": 5235623.800466314,\n    \"K8\": 24721617.44543673,\n    \"K9\": 7060462.209249213,\n    \"K10\": 17991236.655961007,\n    \"K11\": -69646182.24027772,\n    \"K12\": 36158026.4288972,\n    \"K13\": -79383721.70767868,\n    \"K14\": 81028976.94582391\n  },\n  \"R32\": {\n    \"K1\": 31205521.080257088,\n    \"K2\": -12791422.659774244,\n    \"K3\": 65063299.81043598,\n    \"K4\": 96432860.03663039,\n    \"K5\": 24261563.373552784,\n    \"K6\": 38756825.458310574,\n    \"K7\": -51854073.51408102,\n    \"K8\": 7952914.523519799,\n    \"K9\": 64386293.989827216,\n    \"K10\": 91928227.3491365,\n    \"K11\": 50376752.217782915,\n    \"K12\": 88220172.05391788,\n    \"K13\": 56179167.76171127,\n    \"K14\": 13114951.633577794\n  },\n  \"R33\": {\n    \"K1\": 6142398.668532684,\n    \"K2\": 74213263.48210445,\n    \"K3\": 10291611.262824312,\n    \"K4\": -469834.8591835201,\n    \"K5\": 21967230.55064194,\n    \"K6\": 24678138.21367471,\n    \"K7\": -6414155.855680585,\n    \"K8\": 51617515.31377107,\n    \"K9\": 8284031.226150021,\n    \"K10\": 37384115.87626752,\n    \"K11\": -42756302.25619489,\n    \"K12\": -30493572.636986554,\n    \"K13\": -78399037.82294405,\n    \"K14\": -67537940.57563232\n  },\n  \"R34\": {\n    \"K1\": 64857833.56420404,\n    \"K2\": -39383123.74424857,\n    \"K3\": -57488769.57930183,\n    \"K4\": -97456218.11787331,\n    \"K5\": 4888285.57401742,\n    \"K6\": 47317022.039203346,\n    \"K7\": -34053874.08307234,\n    \"K8\": -99488372.68254448,\n    \"K9\": 5470736.222669229,\n    \"K10\": -28197931.342249304,\n    \"K11\": -8283463.507176012,\n    \"K12\": 26302022.63644965,\n    \"K13\": 9780237.253865525,\n    \"K14\": -23319176.731722638\n  },\n  \"R35\": {\n    \"K1\": 82506019.39402068,\n    \"K2\": 631082.3158593327,\n    \"K3\": -20836808.962187365,\n    \"K4\": -2300894.134821221,\n    \"K5\": -40667652.1991391,\n    \"K6\": 63042896.616030395,\n    \"K7\": 94071690.71470508,\n    \"K8\": -25739548.96542205,\n    \"K9\": 67142903.6215783,\n    \"K10\": 45574581.499938786,\n    \"K11\": 81487317.12965742,\n    \"K12\": 15577501.990702644,\n    \"K13\": 71876456.76464695,\n    \"K14\": -56063095.661939144\n  },\n  \"R37\": {\n    \"PielikumsRindai15\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai16\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai17\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai18\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai19\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai33\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"CitiDokumenti\": [\n      {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    ]\n  },\n  \"Id\": 368338,\n  \"UID\": \"culpa\",\n  \"NmrKods\": \"proiden\",\n  \"Precizejums\": true,\n  \"PrecizejamaisDokuments\": -7690412,\n  \"PrecizejumaPamatojums\": \"sit reprehenderit\"\n}"
    },
    {
      "name": "Lietotājs nav autentificēts.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv4/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv4",
            ":id"
          ],
          "variable": [
            {
              "key": "id",
              "value": "25210683",
              "description": "(Required) Dokumenta id."
            }
          ]
        }
      },
      "status": "Unauthorized",
      "code": 401,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    },
    {
      "name": "Dokuments neeksistē vai lietotājam nav tiesību.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv4/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv4",
            ":id"
          ],
          "variable": [
            {
              "key": "id",
              "value": "25210683",
              "description": "(Required) Dokumenta id."
            }
          ]
        }
      },
      "status": "Forbidden",
      "code": 403,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    },
    {
      "name": "Pārsniegts izsaukumu skaita ierobežojums.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv4/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv4",
            ":id"
          ],
          "variable": [
            {
              "key": "id",
              "value": "25210683",
              "description": "(Required) Dokumenta id."
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}