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
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT

    EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://eds.vid.gov.lv/api/doc/annv3/: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
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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": "amet nulla incididunt velit",
    --   "Talrunis": "cupidatat",
    --   "Gads": 65123793,
    --   "Menesis": 1,
    --   "Datums": "2000-01-31T00:00:00",
    --   "MaksTerm": "2000-01-31T00:00:00",
    --   "NmStatuss": "culpa deserunt eiusmod",
    --   "R08": "eiusmod ex Exce",
    --   "R09": "incididunt ipsum",
    --   "Sagatavotajs": "ipsum occaecat velit deserunt elit",
    --   "R10": {
    --     "K1": 69011754.90285358,
    --     "K2": -286474.6996511519,
    --     "K3": -11770878.493984953,
    --     "K4": 41719405.189673424,
    --     "K5": 85870200.14192808,
    --     "K6": 39589872.04420751,
    --     "K7": 51397767.8996591,
    --     "K8": 55571455.62865502,
    --     "K9": -76702183.1212379,
    --     "K10": -28474693.97053413,
    --     "K11": -46737859.039462306,
    --     "K12": -82573888.63207585,
    --     "K13": -70158761.36809416,
    --     "K14": 85900068.49806038
    --   },
    --   "R11": {
    --     "K1": -29800804.37247619,
    --     "K2": -35066503.0054643,
    --     "K3": -69175786.56213808,
    --     "K4": -4016157.839073837,
    --     "K5": 97099183.8659884,
    --     "K6": -58101739.06038889,
    --     "K7": -78979160.79295988,
    --     "K8": -70096428.85637559,
    --     "K9": 34582920.550558865,
    --     "K10": -6122790.466697082,
    --     "K11": -62807023.9465063,
    --     "K12": 19535726.419573158,
    --     "K13": -23693003.608283818,
    --     "K14": 96377854.71285895
    --   },
    --   "R12": {
    --     "K1": 87378012.40657729,
    --     "K2": -27350911.810965165,
    --     "K3": 94527050.58391708,
    --     "K4": 21360404.99224791,
    --     "K5": -29808198.645335168,
    --     "K6": 39156776.223213136,
    --     "K7": 24129726.045016974,
    --     "K8": 9296475.717829809,
    --     "K9": 82658090.11044899,
    --     "K10": -30666.993065729737,
    --     "K11": -4882017.379342288,
    --     "K12": 13961508.645864919,
    --     "K13": 18741577.605267107,
    --     "K14": 59150614.8674168
    --   },
    --   "R13": {
    --     "K1": -65103989.44215647,
    --     "K2": 22918342.522944972,
    --     "K3": 13346606.449489862,
    --     "K4": 78681659.25435358,
    --     "K5": 99538886.19077235,
    --     "K6": -70227435.85379434,
    --     "K7": -34755089.54101198,
    --     "K8": -60635259.987631105,
    --     "K9": -12036440.340121105,
    --     "K10": -90600607.56641927,
    --     "K11": 3602952.135728106,
    --     "K12": -30626183.083574563,
    --     "K13": 2766316.3714336753,
    --     "K14": -90986638.1227932
    --   },
    --   "R14": {
    --     "K1": 40765863.954432696,
    --     "K2": -67182370.45010902,
    --     "K3": 11704952.64645721,
    --     "K4": -84999057.04654682,
    --     "K5": -36048290.58649277,
    --     "K6": 62443585.84163031,
    --     "K7": -32091709.58579573,
    --     "K8": 43625042.31660575,
    --     "K9": 16885544.619369015,
    --     "K10": 80251259.64512235,
    --     "K11": 27318731.967805788,
    --     "K12": -14319355.59212181,
    --     "K13": 41539796.58688739,
    --     "K14": 88701128.01173308
    --   },
    --   "R15": {
    --     "K1": -73742078.22814016,
    --     "K2": 69693131.667204,
    --     "K3": -12824841.672871351,
    --     "K4": -22432843.69190924,
    --     "K5": -25380617.015425906,
    --     "K6": 84675620.93220896,
    --     "K7": 99203348.01453814,
    --     "K8": 70724303.85988456,
    --     "K9": -98075512.73943722,
    --     "K10": -47586259.396855325,
    --     "K11": -50142282.39072187,
    --     "K12": -21101219.808153406,
    --     "K13": 1297868.7648593038,
    --     "K14": -24502689.533988237
    --   },
    --   "R16": {
    --     "K1": -74716385.73514321,
    --     "K2": -30943767.37516588,
    --     "K3": -44399932.76375906,
    --     "K4": 97725275.84666863,
    --     "K5": 66676996.76606268,
    --     "K6": 70624436.77358449,
    --     "K7": -7465955.914643452,
    --     "K8": 54575323.67242882,
    --     "K9": -8226899.7871031165,
    --     "K10": 22459047.79521121,
    --     "K11": 62984419.460039735,
    --     "K12": -38206328.807595424,
    --     "K13": 4590092.543481678,
    --     "K14": 13438461.298249975
    --   },
    --   "R17": {
    --     "K1": -79276235.37118165,
    --     "K2": 88310970.07092902,
    --     "K3": 45338636.402314276,
    --     "K4": -12069175.57364422,
    --     "K5": -51247006.81518837,
    --     "K6": -29487667.020108163,
    --     "K7": -73308992.77850014,
    --     "K8": -33074376.447444066,
    --     "K9": -177327.0789398104,
    --     "K10": 29802067.812471345,
    --     "K11": -88333827.83231154,
    --     "K12": 4541758.027439117,
    --     "K13": -94479383.87846522,
    --     "K14": 71061466.05379507
    --   },
    --   "R18": {
    --     "K1": 49157671.97426507,
    --     "K2": 69861262.56142816,
    --     "K3": 71178403.34087607,
    --     "K4": 92454364.55228323,
    --     "K5": 57063199.17423582,
    --     "K6": 92226720.2758199,
    --     "K7": 36492133.54092264,
    --     "K8": -40110671.71385498,
    --     "K9": -60517419.6178218,
    --     "K10": -54041375.469130725,
    --     "K11": -33424556.83445298,
    --     "K12": 62335423.58725083,
    --     "K13": -94396793.40749945,
    --     "K14": 80252277.86649683
    --   },
    --   "R19": {
    --     "K1": 123715.51453527808,
    --     "K2": -30024289.465088308,
    --     "K3": 20831821.576838523,
    --     "K4": 13751186.00750947,
    --     "K5": -82562248.40154359,
    --     "K6": -91918658.27465749,
    --     "K7": 53664426.47689101,
    --     "K8": -98266332.30762978,
    --     "K9": 83178105.28106353,
    --     "K10": -99333857.54222001,
    --     "K11": 53695967.461390644,
    --     "K12": -28408415.947372362,
    --     "K13": 76269594.75703493,
    --     "K14": 31912799.067684934
    --   },
    --   "R21": {
    --     "K1": -44715463.05692659,
    --     "K2": 35259445.42232731,
    --     "K3": -73543212.95697933,
    --     "K4": 51062825.70996052,
    --     "K5": -24866924.962759823,
    --     "K6": -99782144.91487187,
    --     "K7": 34426916.9880867,
    --     "K8": 80196114.54963037,
    --     "K9": -82033296.18403381,
    --     "K10": 51632187.13585627,
    --     "K11": -31052880.19715458,
    --     "K12": -84933115.76651567,
    --     "K13": -18239617.81592995,
    --     "K14": -79838514.38359855
    --   },
    --   "R22": {
    --     "K1": -40657959.122213595,
    --     "K2": -35666457.192132436,
    --     "K3": -54900133.81453851,
    --     "K4": -50660550.33409076,
    --     "K5": 56372959.6100699,
    --     "K6": -22617966.86505577,
    --     "K7": -25785132.50306958,
    --     "K8": -80599255.28435676,
    --     "K9": 34162524.82784064,
    --     "K10": 60312008.3953411,
    --     "K11": -78494808.23443687,
    --     "K12": -54561406.25574868,
    --     "K13": -95947709.11534333,
    --     "K14": -50199990.21337842
    --   },
    --   "R23": {
    --     "K1": 41675545.57682341,
    --     "K2": -8213686.921727166,
    --     "K3": 52303188.87026709,
    --     "K4": 35451686.00720307,
    --     "K5": -70464918.60214852,
    --     "K6": 83371946.7007502,
    --     "K7": -72710355.44172299,
    --     "K8": -70039250.24744335,
    --     "K9": -5124505.089271426,
    --     "K10": 52554245.53818181,
    --     "K11": -9546174.943117559,
    --     "K12": -97484758.60810348,
    --     "K13": -4113345.3718183786,
    --     "K14": -50426233.13131713
    --   },
    --   "R24": {
    --     "K1": 66133466.26420823,
    --     "K2": -91964569.1839817,
    --     "K3": -4096172.611068338,
    --     "K4": 32181593.09547071,
    --     "K5": -76106645.14385906,
    --     "K6": -95263921.22593985,
    --     "K7": 48077115.43286115,
    --     "K8": -63433082.57376678,
    --     "K9": 98066585.07445216,
    --     "K10": 73490964.03584486,
    --     "K11": 47120763.647226095,
    --     "K12": 2914591.4395706058,
    --     "K13": 47568164.221423656,
    --     "K14": -18514471.703478158
    --   },
    --   "R25": {
    --     "K1": -62046475.12956058,
    --     "K2": -38748807.6190357,
    --     "K3": 49463934.0935137,
    --     "K4": -58401680.16387279,
    --     "K5": 29052171.52058515,
    --     "K6": -11062992.885137752,
    --     "K7": 43145282.76044333,
    --     "K8": -36580995.051727384,
    --     "K9": 99778589.80893427,
    --     "K10": -68592671.16203561,
    --     "K11": 2687004.18798095,
    --     "K12": -86400621.13214996,
    --     "K13": 77518804.34014541,
    --     "K14": -12645410.150312617
    --   },
    --   "R26": {
    --     "K1": -78591896.14125341,
    --     "K2": -33541977.987893023,
    --     "K3": -7126957.559500501,
    --     "K4": -81283519.89619827,
    --     "K5": 62149847.61238295,
    --     "K6": -55398211.15769437,
    --     "K7": -62452233.28487213,
    --     "K8": -7969978.069563672,
    --     "K9": -11435938.536992833,
    --     "K10": -88980847.07671581,
    --     "K11": 18580757.84160991,
    --     "K12": -38332654.85404911,
    --     "K13": -69024700.81814651,
    --     "K14": -97678730.99893686
    --   },
    --   "R28": {
    --     "K1": 92344399.21691194,
    --     "K2": 10253142.701950192,
    --     "K3": 84221877.49756199,
    --     "K4": -93633150.34182805,
    --     "K5": -1870238.6556153148,
    --     "K6": -23360941.28930016,
    --     "K7": 83081373.79069,
    --     "K8": 14986066.553176299,
    --     "K9": -53534597.61668642,
    --     "K10": 91966957.19912711,
    --     "K11": 828880.8995863944,
    --     "K12": -22621159.383924723,
    --     "K13": -57517677.94118683,
    --     "K14": -43960533.52528262
    --   },
    --   "R29": {
    --     "K1": 65098068.548140675,
    --     "K2": -62628847.71550619,
    --     "K3": -44645096.38325689,
    --     "K4": -70382336.380874,
    --     "K5": 77764871.23749784,
    --     "K6": 85471988.04898414,
    --     "K7": -92682519.16448605,
    --     "K8": 14477516.365955934,
    --     "K9": -54485567.545958124,
    --     "K10": -58390662.08840067,
    --     "K11": -25786685.54566148,
    --     "K12": -12775479.956604004,
    --     "K13": -24986968.96927038,
    --     "K14": 61530633.76396072
    --   },
    --   "R30": {
    --     "K1": -60408540.21200048,
    --     "K2": -95382025.37231442,
    --     "K3": -82203699.10495462,
    --     "K4": -13019465.837596565,
    --     "K5": 48909150.779518306,
    --     "K6": 35851167.10334942,
    --     "K7": 40932012.4235768,
    --     "K8": 69260655.89888439,
    --     "K9": -3802098.942574486,
    --     "K10": 45939169.58042014,
    --     "K11": 76142036.76493588,
    --     "K12": 673525.662062645,
    --     "K13": -41669688.51011612,
    --     "K14": 53421817.67200649
    --   },
    --   "R32": {
    --     "K1": -89219505.33041811,
    --     "K2": 84086950.08672878,
    --     "K3": -47621981.65450138,
    --     "K4": -43320449.76828926,
    --     "K5": -32075059.245812193,
    --     "K6": 46658032.035206795,
    --     "K7": 74567283.10016194,
    --     "K8": -39210983.69562697,
    --     "K9": -94627388.8717959,
    --     "K10": 51416151.03172833,
    --     "K11": -67059563.23692037,
    --     "K12": 14054536.63035208,
    --     "K13": 1584464.747822255,
    --     "K14": 6139643.822236434
    --   },
    --   "R33": {
    --     "K1": 8509480.473880112,
    --     "K2": 54038030.33899832,
    --     "K3": -67320688.18142922,
    --     "K4": 157803.89888755977,
    --     "K5": -93464588.74322496,
    --     "K6": -73086803.47495252,
    --     "K7": 28811001.462504923,
    --     "K8": -858734.274120152,
    --     "K9": -83736640.3299682,
    --     "K10": -30443417.911967963,
    --     "K11": -59182930.12059839,
    --     "K12": 90991775.95187068,
    --     "K13": -93258202.86744104,
    --     "K14": 75065806.16454467
    --   },
    --   "R34": {
    --     "K1": 64366266.04542029,
    --     "K2": 55875279.07302797,
    --     "K3": -30412639.03126569,
    --     "K4": 20928264.1107547,
    --     "K5": 96073421.19970256,
    --     "K6": 6238152.798862994,
    --     "K7": 82602234.65809983,
    --     "K8": -51657176.4649302,
    --     "K9": 78178158.87128153,
    --     "K10": -49439763.84407458,
    --     "K11": -33046722.950156137,
    --     "K12": -49408589.47432081,
    --     "K13": -17148102.76511787,
    --     "K14": 30072675.67667733
    --   },
    --   "R35": {
    --     "K1": -75256865.62902214,
    --     "K2": -14233162.403070495,
    --     "K3": 89920332.7760945,
    --     "K4": -27753270.94936633,
    --     "K5": -19643007.61510174,
    --     "K6": 16777781.736409515,
    --     "K7": 17366393.979396924,
    --     "K8": 13701608.75001809,
    --     "K9": 43470850.388211966,
    --     "K10": -81511501.13858594,
    --     "K11": -68098284.54304525,
    --     "K12": 10830500.441741318,
    --     "K13": 69405383.63544184,
    --     "K14": -37015749.94596557
    --   },
    --   "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": 64149875,
    --   "UID": "ipsum culpa",
    --   "NmrKods": "anim proi",
    --   "Precizejums": false,
    --   "PrecizejamaisDokuments": -88089515,
    --   "PrecizejumaPamatojums": "Lorem officia"
    -- }

    -- 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/annv3/: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/annv3/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "doc",
        "annv3",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "25210683",
          "description": "(Required) Dokumenta id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv3",
            ":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\": \"amet nulla incididunt velit\",\n  \"Talrunis\": \"cupidatat\",\n  \"Gads\": 65123793,\n  \"Menesis\": 1,\n  \"Datums\": \"2000-01-31T00:00:00\",\n  \"MaksTerm\": \"2000-01-31T00:00:00\",\n  \"NmStatuss\": \"culpa deserunt eiusmod\",\n  \"R08\": \"eiusmod ex Exce\",\n  \"R09\": \"incididunt ipsum\",\n  \"Sagatavotajs\": \"ipsum occaecat velit deserunt elit\",\n  \"R10\": {\n    \"K1\": 69011754.90285358,\n    \"K2\": -286474.6996511519,\n    \"K3\": -11770878.493984953,\n    \"K4\": 41719405.189673424,\n    \"K5\": 85870200.14192808,\n    \"K6\": 39589872.04420751,\n    \"K7\": 51397767.8996591,\n    \"K8\": 55571455.62865502,\n    \"K9\": -76702183.1212379,\n    \"K10\": -28474693.97053413,\n    \"K11\": -46737859.039462306,\n    \"K12\": -82573888.63207585,\n    \"K13\": -70158761.36809416,\n    \"K14\": 85900068.49806038\n  },\n  \"R11\": {\n    \"K1\": -29800804.37247619,\n    \"K2\": -35066503.0054643,\n    \"K3\": -69175786.56213808,\n    \"K4\": -4016157.839073837,\n    \"K5\": 97099183.8659884,\n    \"K6\": -58101739.06038889,\n    \"K7\": -78979160.79295988,\n    \"K8\": -70096428.85637559,\n    \"K9\": 34582920.550558865,\n    \"K10\": -6122790.466697082,\n    \"K11\": -62807023.9465063,\n    \"K12\": 19535726.419573158,\n    \"K13\": -23693003.608283818,\n    \"K14\": 96377854.71285895\n  },\n  \"R12\": {\n    \"K1\": 87378012.40657729,\n    \"K2\": -27350911.810965165,\n    \"K3\": 94527050.58391708,\n    \"K4\": 21360404.99224791,\n    \"K5\": -29808198.645335168,\n    \"K6\": 39156776.223213136,\n    \"K7\": 24129726.045016974,\n    \"K8\": 9296475.717829809,\n    \"K9\": 82658090.11044899,\n    \"K10\": -30666.993065729737,\n    \"K11\": -4882017.379342288,\n    \"K12\": 13961508.645864919,\n    \"K13\": 18741577.605267107,\n    \"K14\": 59150614.8674168\n  },\n  \"R13\": {\n    \"K1\": -65103989.44215647,\n    \"K2\": 22918342.522944972,\n    \"K3\": 13346606.449489862,\n    \"K4\": 78681659.25435358,\n    \"K5\": 99538886.19077235,\n    \"K6\": -70227435.85379434,\n    \"K7\": -34755089.54101198,\n    \"K8\": -60635259.987631105,\n    \"K9\": -12036440.340121105,\n    \"K10\": -90600607.56641927,\n    \"K11\": 3602952.135728106,\n    \"K12\": -30626183.083574563,\n    \"K13\": 2766316.3714336753,\n    \"K14\": -90986638.1227932\n  },\n  \"R14\": {\n    \"K1\": 40765863.954432696,\n    \"K2\": -67182370.45010902,\n    \"K3\": 11704952.64645721,\n    \"K4\": -84999057.04654682,\n    \"K5\": -36048290.58649277,\n    \"K6\": 62443585.84163031,\n    \"K7\": -32091709.58579573,\n    \"K8\": 43625042.31660575,\n    \"K9\": 16885544.619369015,\n    \"K10\": 80251259.64512235,\n    \"K11\": 27318731.967805788,\n    \"K12\": -14319355.59212181,\n    \"K13\": 41539796.58688739,\n    \"K14\": 88701128.01173308\n  },\n  \"R15\": {\n    \"K1\": -73742078.22814016,\n    \"K2\": 69693131.667204,\n    \"K3\": -12824841.672871351,\n    \"K4\": -22432843.69190924,\n    \"K5\": -25380617.015425906,\n    \"K6\": 84675620.93220896,\n    \"K7\": 99203348.01453814,\n    \"K8\": 70724303.85988456,\n    \"K9\": -98075512.73943722,\n    \"K10\": -47586259.396855325,\n    \"K11\": -50142282.39072187,\n    \"K12\": -21101219.808153406,\n    \"K13\": 1297868.7648593038,\n    \"K14\": -24502689.533988237\n  },\n  \"R16\": {\n    \"K1\": -74716385.73514321,\n    \"K2\": -30943767.37516588,\n    \"K3\": -44399932.76375906,\n    \"K4\": 97725275.84666863,\n    \"K5\": 66676996.76606268,\n    \"K6\": 70624436.77358449,\n    \"K7\": -7465955.914643452,\n    \"K8\": 54575323.67242882,\n    \"K9\": -8226899.7871031165,\n    \"K10\": 22459047.79521121,\n    \"K11\": 62984419.460039735,\n    \"K12\": -38206328.807595424,\n    \"K13\": 4590092.543481678,\n    \"K14\": 13438461.298249975\n  },\n  \"R17\": {\n    \"K1\": -79276235.37118165,\n    \"K2\": 88310970.07092902,\n    \"K3\": 45338636.402314276,\n    \"K4\": -12069175.57364422,\n    \"K5\": -51247006.81518837,\n    \"K6\": -29487667.020108163,\n    \"K7\": -73308992.77850014,\n    \"K8\": -33074376.447444066,\n    \"K9\": -177327.0789398104,\n    \"K10\": 29802067.812471345,\n    \"K11\": -88333827.83231154,\n    \"K12\": 4541758.027439117,\n    \"K13\": -94479383.87846522,\n    \"K14\": 71061466.05379507\n  },\n  \"R18\": {\n    \"K1\": 49157671.97426507,\n    \"K2\": 69861262.56142816,\n    \"K3\": 71178403.34087607,\n    \"K4\": 92454364.55228323,\n    \"K5\": 57063199.17423582,\n    \"K6\": 92226720.2758199,\n    \"K7\": 36492133.54092264,\n    \"K8\": -40110671.71385498,\n    \"K9\": -60517419.6178218,\n    \"K10\": -54041375.469130725,\n    \"K11\": -33424556.83445298,\n    \"K12\": 62335423.58725083,\n    \"K13\": -94396793.40749945,\n    \"K14\": 80252277.86649683\n  },\n  \"R19\": {\n    \"K1\": 123715.51453527808,\n    \"K2\": -30024289.465088308,\n    \"K3\": 20831821.576838523,\n    \"K4\": 13751186.00750947,\n    \"K5\": -82562248.40154359,\n    \"K6\": -91918658.27465749,\n    \"K7\": 53664426.47689101,\n    \"K8\": -98266332.30762978,\n    \"K9\": 83178105.28106353,\n    \"K10\": -99333857.54222001,\n    \"K11\": 53695967.461390644,\n    \"K12\": -28408415.947372362,\n    \"K13\": 76269594.75703493,\n    \"K14\": 31912799.067684934\n  },\n  \"R21\": {\n    \"K1\": -44715463.05692659,\n    \"K2\": 35259445.42232731,\n    \"K3\": -73543212.95697933,\n    \"K4\": 51062825.70996052,\n    \"K5\": -24866924.962759823,\n    \"K6\": -99782144.91487187,\n    \"K7\": 34426916.9880867,\n    \"K8\": 80196114.54963037,\n    \"K9\": -82033296.18403381,\n    \"K10\": 51632187.13585627,\n    \"K11\": -31052880.19715458,\n    \"K12\": -84933115.76651567,\n    \"K13\": -18239617.81592995,\n    \"K14\": -79838514.38359855\n  },\n  \"R22\": {\n    \"K1\": -40657959.122213595,\n    \"K2\": -35666457.192132436,\n    \"K3\": -54900133.81453851,\n    \"K4\": -50660550.33409076,\n    \"K5\": 56372959.6100699,\n    \"K6\": -22617966.86505577,\n    \"K7\": -25785132.50306958,\n    \"K8\": -80599255.28435676,\n    \"K9\": 34162524.82784064,\n    \"K10\": 60312008.3953411,\n    \"K11\": -78494808.23443687,\n    \"K12\": -54561406.25574868,\n    \"K13\": -95947709.11534333,\n    \"K14\": -50199990.21337842\n  },\n  \"R23\": {\n    \"K1\": 41675545.57682341,\n    \"K2\": -8213686.921727166,\n    \"K3\": 52303188.87026709,\n    \"K4\": 35451686.00720307,\n    \"K5\": -70464918.60214852,\n    \"K6\": 83371946.7007502,\n    \"K7\": -72710355.44172299,\n    \"K8\": -70039250.24744335,\n    \"K9\": -5124505.089271426,\n    \"K10\": 52554245.53818181,\n    \"K11\": -9546174.943117559,\n    \"K12\": -97484758.60810348,\n    \"K13\": -4113345.3718183786,\n    \"K14\": -50426233.13131713\n  },\n  \"R24\": {\n    \"K1\": 66133466.26420823,\n    \"K2\": -91964569.1839817,\n    \"K3\": -4096172.611068338,\n    \"K4\": 32181593.09547071,\n    \"K5\": -76106645.14385906,\n    \"K6\": -95263921.22593985,\n    \"K7\": 48077115.43286115,\n    \"K8\": -63433082.57376678,\n    \"K9\": 98066585.07445216,\n    \"K10\": 73490964.03584486,\n    \"K11\": 47120763.647226095,\n    \"K12\": 2914591.4395706058,\n    \"K13\": 47568164.221423656,\n    \"K14\": -18514471.703478158\n  },\n  \"R25\": {\n    \"K1\": -62046475.12956058,\n    \"K2\": -38748807.6190357,\n    \"K3\": 49463934.0935137,\n    \"K4\": -58401680.16387279,\n    \"K5\": 29052171.52058515,\n    \"K6\": -11062992.885137752,\n    \"K7\": 43145282.76044333,\n    \"K8\": -36580995.051727384,\n    \"K9\": 99778589.80893427,\n    \"K10\": -68592671.16203561,\n    \"K11\": 2687004.18798095,\n    \"K12\": -86400621.13214996,\n    \"K13\": 77518804.34014541,\n    \"K14\": -12645410.150312617\n  },\n  \"R26\": {\n    \"K1\": -78591896.14125341,\n    \"K2\": -33541977.987893023,\n    \"K3\": -7126957.559500501,\n    \"K4\": -81283519.89619827,\n    \"K5\": 62149847.61238295,\n    \"K6\": -55398211.15769437,\n    \"K7\": -62452233.28487213,\n    \"K8\": -7969978.069563672,\n    \"K9\": -11435938.536992833,\n    \"K10\": -88980847.07671581,\n    \"K11\": 18580757.84160991,\n    \"K12\": -38332654.85404911,\n    \"K13\": -69024700.81814651,\n    \"K14\": -97678730.99893686\n  },\n  \"R28\": {\n    \"K1\": 92344399.21691194,\n    \"K2\": 10253142.701950192,\n    \"K3\": 84221877.49756199,\n    \"K4\": -93633150.34182805,\n    \"K5\": -1870238.6556153148,\n    \"K6\": -23360941.28930016,\n    \"K7\": 83081373.79069,\n    \"K8\": 14986066.553176299,\n    \"K9\": -53534597.61668642,\n    \"K10\": 91966957.19912711,\n    \"K11\": 828880.8995863944,\n    \"K12\": -22621159.383924723,\n    \"K13\": -57517677.94118683,\n    \"K14\": -43960533.52528262\n  },\n  \"R29\": {\n    \"K1\": 65098068.548140675,\n    \"K2\": -62628847.71550619,\n    \"K3\": -44645096.38325689,\n    \"K4\": -70382336.380874,\n    \"K5\": 77764871.23749784,\n    \"K6\": 85471988.04898414,\n    \"K7\": -92682519.16448605,\n    \"K8\": 14477516.365955934,\n    \"K9\": -54485567.545958124,\n    \"K10\": -58390662.08840067,\n    \"K11\": -25786685.54566148,\n    \"K12\": -12775479.956604004,\n    \"K13\": -24986968.96927038,\n    \"K14\": 61530633.76396072\n  },\n  \"R30\": {\n    \"K1\": -60408540.21200048,\n    \"K2\": -95382025.37231442,\n    \"K3\": -82203699.10495462,\n    \"K4\": -13019465.837596565,\n    \"K5\": 48909150.779518306,\n    \"K6\": 35851167.10334942,\n    \"K7\": 40932012.4235768,\n    \"K8\": 69260655.89888439,\n    \"K9\": -3802098.942574486,\n    \"K10\": 45939169.58042014,\n    \"K11\": 76142036.76493588,\n    \"K12\": 673525.662062645,\n    \"K13\": -41669688.51011612,\n    \"K14\": 53421817.67200649\n  },\n  \"R32\": {\n    \"K1\": -89219505.33041811,\n    \"K2\": 84086950.08672878,\n    \"K3\": -47621981.65450138,\n    \"K4\": -43320449.76828926,\n    \"K5\": -32075059.245812193,\n    \"K6\": 46658032.035206795,\n    \"K7\": 74567283.10016194,\n    \"K8\": -39210983.69562697,\n    \"K9\": -94627388.8717959,\n    \"K10\": 51416151.03172833,\n    \"K11\": -67059563.23692037,\n    \"K12\": 14054536.63035208,\n    \"K13\": 1584464.747822255,\n    \"K14\": 6139643.822236434\n  },\n  \"R33\": {\n    \"K1\": 8509480.473880112,\n    \"K2\": 54038030.33899832,\n    \"K3\": -67320688.18142922,\n    \"K4\": 157803.89888755977,\n    \"K5\": -93464588.74322496,\n    \"K6\": -73086803.47495252,\n    \"K7\": 28811001.462504923,\n    \"K8\": -858734.274120152,\n    \"K9\": -83736640.3299682,\n    \"K10\": -30443417.911967963,\n    \"K11\": -59182930.12059839,\n    \"K12\": 90991775.95187068,\n    \"K13\": -93258202.86744104,\n    \"K14\": 75065806.16454467\n  },\n  \"R34\": {\n    \"K1\": 64366266.04542029,\n    \"K2\": 55875279.07302797,\n    \"K3\": -30412639.03126569,\n    \"K4\": 20928264.1107547,\n    \"K5\": 96073421.19970256,\n    \"K6\": 6238152.798862994,\n    \"K7\": 82602234.65809983,\n    \"K8\": -51657176.4649302,\n    \"K9\": 78178158.87128153,\n    \"K10\": -49439763.84407458,\n    \"K11\": -33046722.950156137,\n    \"K12\": -49408589.47432081,\n    \"K13\": -17148102.76511787,\n    \"K14\": 30072675.67667733\n  },\n  \"R35\": {\n    \"K1\": -75256865.62902214,\n    \"K2\": -14233162.403070495,\n    \"K3\": 89920332.7760945,\n    \"K4\": -27753270.94936633,\n    \"K5\": -19643007.61510174,\n    \"K6\": 16777781.736409515,\n    \"K7\": 17366393.979396924,\n    \"K8\": 13701608.75001809,\n    \"K9\": 43470850.388211966,\n    \"K10\": -81511501.13858594,\n    \"K11\": -68098284.54304525,\n    \"K12\": 10830500.441741318,\n    \"K13\": 69405383.63544184,\n    \"K14\": -37015749.94596557\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\": 64149875,\n  \"UID\": \"ipsum culpa\",\n  \"NmrKods\": \"anim proi\",\n  \"Precizejums\": false,\n  \"PrecizejamaisDokuments\": -88089515,\n  \"PrecizejumaPamatojums\": \"Lorem officia\"\n}"
    },
    {
      "name": "Lietotājs nav autentificēts.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/annv3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv3",
            ":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/annv3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv3",
            ":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/annv3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "annv3",
            ":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": ""
    }
  ]
}