SQL Server / EDS API / Dokuments "Tabakas izstrādājumu 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/antv2/: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": "voluptate occaecat",
-- "Talrunis": "ex consectetur Duis",
-- "Gads": -32148500,
-- "Menesis": 2,
-- "Datums": "2000-01-31T00:00:00",
-- "Statuss": "dolore magna labore officia eu",
-- "R09": "ullamco",
-- "R10": "aliqua culpa amet",
-- "Sagatavotajs": "null",
-- "SamTermins": "2000-01-31T00:00:00",
-- "R11": 81423595.70472443,
-- "R12": {
-- "K1": [
-- -55811926.783076115,
-- -27489309.773506805
-- ],
-- "K2": -26322052.92684917,
-- "K3": 91174115.78638771,
-- "K4": 35366928.168783605,
-- "K5": -63052196.125354506,
-- "K6": 88344391.9584584
-- },
-- "R13": 75942378.56973031,
-- "R14": {
-- "K1": [
-- 26108959.669708163,
-- 30000676.883922324
-- ],
-- "K2": -62948703.60251017,
-- "K3": -15085804.986262992,
-- "K4": 89325549.9340074,
-- "K5": 93578258.4711434,
-- "K6": 58122267.3771978
-- },
-- "R15": {
-- "K1": [
-- -53549562.084918186,
-- -52391830.55384977
-- ],
-- "K2": 73073577.90459305,
-- "K3": 93252599.71330437,
-- "K4": 96630828.6844967,
-- "K5": -59104722.17959515,
-- "K6": 47800364.3893016
-- },
-- "R16": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": -12878883.614582688,
-- "K3": 12706690.488478586,
-- "K4": -75246122.74759002,
-- "K5": 87824033.11856943,
-- "K6": -63738506.158957444
-- },
-- "R17": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": -70081933.48710057,
-- "K3": 19623571.714400694,
-- "K4": 12719784.349283665,
-- "K5": 82147118.90444493,
-- "K6": 47603667.86847773
-- },
-- "R18": {
-- "K1": [
-- 37739087.89398542,
-- 97914440.56552196
-- ],
-- "K2": -90705356.27924223,
-- "K3": 33857901.930648014,
-- "K4": 52453802.14974919,
-- "K5": 73146172.62024462,
-- "K6": 43846302.66323057
-- },
-- "R19": {
-- "K1": [
-- -63677793.2657322,
-- -91206284.23958439
-- ],
-- "K2": 71513919.77603555,
-- "K3": -9137312.499590859,
-- "K4": -37686515.15663821,
-- "K5": 25333286.294983417,
-- "K6": 51858062.98208436
-- },
-- "R20": {
-- "K1": [
-- 98360931.77446848,
-- 8679234.612219483
-- ],
-- "K2": -18642642.643749908,
-- "K3": -77183434.29918173,
-- "K4": 90459163.26731893,
-- "K5": -73029424.2331607,
-- "K6": 11492309.633789107
-- },
-- "R21": {
-- "K1": [
-- 82511439.01985362,
-- 16550496.732448712
-- ],
-- "K2": 85092300.85531518,
-- "K3": -58041295.05955951,
-- "K4": 13462282.540345252,
-- "K5": 35693227.5672932,
-- "K6": -94760140.3623878
-- },
-- "R22": {
-- "K1": [
-- -57193918.6417274,
-- -51259984.62950685
-- ],
-- "K2": -26225907.387124494,
-- "K3": 43383612.80265048,
-- "K4": -25665701.362420768,
-- "K5": -60535473.966974474,
-- "K6": 64362308.2559205
-- },
-- "R23": {
-- "K1": [
-- 47747017.14676356,
-- 97841845.28650352
-- ],
-- "K2": -57883347.43486074,
-- "K3": -36267097.137551606,
-- "K4": 32578224.640988246,
-- "K5": 56652514.14358893,
-- "K6": -1971379.2314175516
-- },
-- "R24": {
-- "K1": [
-- -53115093.01483266,
-- -4249478.346100107
-- ],
-- "K2": 26549690.05980234,
-- "K3": 708372.2164720148,
-- "K4": 46212213.90224978,
-- "K5": -46888876.51303286,
-- "K6": -16455607.936146647
-- },
-- "R25": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": 10306119.523437962,
-- "K3": 35425419.29494351,
-- "K4": -89110798.34651288,
-- "K5": 10905626.923329279,
-- "K6": -12052196.963526279
-- },
-- "R26": {
-- "K1": [
-- -29901885.596135795,
-- 30890036.587786883
-- ],
-- "K2": 80122776.35614228,
-- "K3": 35537801.582769126,
-- "K4": 37959092.780569494,
-- "K5": 49698671.38823742,
-- "K6": -78384948.58507419
-- },
-- "R27": {
-- "K1": [
-- 77565426.05743447,
-- 61397934.726113856
-- ],
-- "K2": 24413167.19357501,
-- "K3": -87569194.60042968,
-- "K4": -97905977.16883345,
-- "K5": 37932475.16228306,
-- "K6": -84751824.0648602
-- },
-- "R28": {
-- "K1": [
-- -52488802.50292824,
-- -55391641.32316285
-- ],
-- "K2": 75823495.38102835,
-- "K3": -82261071.98753448,
-- "K4": -77750925.80206864,
-- "K5": 1715291.8924190402,
-- "K6": 13227610.745488063
-- },
-- "R29": {
-- "K1": [
-- -79898446.27441585,
-- 9195174.4429636
-- ],
-- "K2": 220840.8984989822,
-- "K3": 31643752.3795667,
-- "K4": 87412806.44297901,
-- "K5": 74392115.9406603,
-- "K6": -8235233.853508815
-- },
-- "R30": {
-- "K1": [
-- -22111789.470781535,
-- 49907211.93263447
-- ],
-- "K2": 93460681.43746567,
-- "K3": -19869683.428597048,
-- "K4": -88504456.29682878,
-- "K5": 69151681.42332351,
-- "K6": 176675.95043580234
-- },
-- "R31": {
-- "K1": [
-- -34839205.42402092,
-- -94428404.20908998
-- ],
-- "K2": 42225310.49026236,
-- "K3": -55047037.82652038,
-- "K4": 29137854.76134953,
-- "K5": -77915743.40625095,
-- "K6": 85797199.07378092
-- },
-- "R32": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": 33452809.523544148,
-- "K3": -61618706.95068687,
-- "K4": 71222472.2602568,
-- "K5": -39961199.77180004,
-- "K6": 27574224.469748512
-- },
-- "R33": {
-- "K1": [
-- -22221033.132086277,
-- 45930755.19282287
-- ],
-- "K2": -31623257.278335124,
-- "K3": -44587566.69523667,
-- "K4": -32897341.768002965,
-- "K5": 21382843.684254736,
-- "K6": 12904324.22194776
-- },
-- "R34": {
-- "K1": [
-- 76458756.48614231,
-- -58513100.52231868
-- ],
-- "K2": 57445143.39397973,
-- "K3": -58697479.574024715,
-- "K4": 27092183.765359133,
-- "K5": 86066991.8588464,
-- "K6": -12833072.944992319
-- },
-- "R35": {
-- "K1": [
-- -8418549.476541415,
-- 62481344.35299781
-- ],
-- "K2": -66422896.68134742,
-- "K3": -83257669.32965006,
-- "K4": -87739028.30112684,
-- "K5": -57737419.363189615,
-- "K6": 97682440.17745689
-- },
-- "R36": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": -94454655.66888656,
-- "K3": 67173283.14724523,
-- "K4": -4148351.342897743,
-- "K5": -95381705.52963567,
-- "K6": -80931570.280611
-- },
-- "R37": {
-- "K1": [
-- 63160416.69133371,
-- -74272468.97875252
-- ],
-- "K2": 9389552.512223348,
-- "K3": 41754567.86103323,
-- "K4": 4400298.588936955,
-- "K5": 54009612.11361089,
-- "K6": 19751522.711799607
-- },
-- "R38": {
-- "K1": [
-- 46349209.06335789,
-- 2689107.4215914756
-- ],
-- "K2": 72435433.36861923,
-- "K3": -30382746.357975468,
-- "K4": 10530707.49252081,
-- "K5": 72845973.66811547,
-- "K6": -45102508.378410414
-- },
-- "R39": {
-- "K1": [
-- -95710836.08108011,
-- 24694331.222817034
-- ],
-- "K2": -17105935.26779495,
-- "K3": 98217302.10397539,
-- "K4": -50541253.18172864,
-- "K5": -75188791.4295811,
-- "K6": -46448283.423055425
-- },
-- "R40": {
-- "K1": [
-- -79850713.27785406,
-- 55745695.276213944
-- ],
-- "K2": -64122316.10616858,
-- "K3": -86672583.02313714,
-- "K4": -99222724.6089044,
-- "K5": 57856672.56958261,
-- "K6": 969177.2817018926
-- },
-- "R41": {
-- "K1": [
-- 24653325.6340757,
-- 7180838.149691254
-- ],
-- "K2": 25373244.701280043,
-- "K3": 35127412.50044766,
-- "K4": 40534851.33730477,
-- "K5": -4047027.083976522,
-- "K6": -17155792.308277056
-- },
-- "R42": {
-- "K1": [
-- -38690510.176178925,
-- -85269778.33996937
-- ],
-- "K2": -40254476.16227353,
-- "K3": -98644014.64634968,
-- "K4": -98703629.2642716,
-- "K5": -47199938.69715049,
-- "K6": -8503708.515376866
-- },
-- "R43": {
-- "K1": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "K2": -66756176.53218451,
-- "K3": 32904250.256045,
-- "K4": -11235742.305885792,
-- "K5": -1029500.6580825001,
-- "K6": -66150697.60184098
-- },
-- "R45": {
-- "PielikumsRindai14": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai23": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai24": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai41": {
-- "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": 68859334,
-- "UID": "labore sit ut",
-- "NmrKods": "veniam ",
-- "Precizejums": false,
-- "PrecizejamaisDokuments": -69162291,
-- "PrecizejumaPamatojums": "ex"
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @intVal int
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 @Statuss nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Statuss OUT, 'Statuss'
DECLARE @R09 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R09 OUT, 'R09'
DECLARE @R10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R10 OUT, 'R10'
DECLARE @Sagatavotajs nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Sagatavotajs OUT, 'Sagatavotajs'
DECLARE @SamTermins nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @SamTermins OUT, 'SamTermins'
DECLARE @R11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R11 OUT, 'R11'
DECLARE @K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K2 OUT, 'R12.K2'
DECLARE @K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K3 OUT, 'R12.K3'
DECLARE @K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K4 OUT, 'R12.K4'
DECLARE @K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K5 OUT, 'R12.K5'
DECLARE @K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K6 OUT, 'R12.K6'
DECLARE @R13 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13 OUT, 'R13'
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 @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 @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 @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 @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 @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 @R20K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K2 OUT, 'R20.K2'
DECLARE @R20K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K3 OUT, 'R20.K3'
DECLARE @R20K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K4 OUT, 'R20.K4'
DECLARE @R20K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K5 OUT, 'R20.K5'
DECLARE @R20K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K6 OUT, 'R20.K6'
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 @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 @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 @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 @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 @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 @R27K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K2 OUT, 'R27.K2'
DECLARE @R27K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K3 OUT, 'R27.K3'
DECLARE @R27K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K4 OUT, 'R27.K4'
DECLARE @R27K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K5 OUT, 'R27.K5'
DECLARE @R27K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K6 OUT, 'R27.K6'
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 @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 @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 @R31K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R31K2 OUT, 'R31.K2'
DECLARE @R31K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R31K3 OUT, 'R31.K3'
DECLARE @R31K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R31K4 OUT, 'R31.K4'
DECLARE @R31K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R31K5 OUT, 'R31.K5'
DECLARE @R31K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R31K6 OUT, 'R31.K6'
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 @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 @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 @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 @R36K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K2 OUT, 'R36.K2'
DECLARE @R36K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K3 OUT, 'R36.K3'
DECLARE @R36K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K4 OUT, 'R36.K4'
DECLARE @R36K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K5 OUT, 'R36.K5'
DECLARE @R36K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K6 OUT, 'R36.K6'
DECLARE @R37K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K2 OUT, 'R37.K2'
DECLARE @R37K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K3 OUT, 'R37.K3'
DECLARE @R37K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K4 OUT, 'R37.K4'
DECLARE @R37K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K5 OUT, 'R37.K5'
DECLARE @R37K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K6 OUT, 'R37.K6'
DECLARE @R38K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K2 OUT, 'R38.K2'
DECLARE @R38K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K3 OUT, 'R38.K3'
DECLARE @R38K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K4 OUT, 'R38.K4'
DECLARE @R38K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K5 OUT, 'R38.K5'
DECLARE @R38K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K6 OUT, 'R38.K6'
DECLARE @R39K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K2 OUT, 'R39.K2'
DECLARE @R39K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K3 OUT, 'R39.K3'
DECLARE @R39K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K4 OUT, 'R39.K4'
DECLARE @R39K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K5 OUT, 'R39.K5'
DECLARE @R39K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K6 OUT, 'R39.K6'
DECLARE @R40K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K2 OUT, 'R40.K2'
DECLARE @R40K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K3 OUT, 'R40.K3'
DECLARE @R40K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K4 OUT, 'R40.K4'
DECLARE @R40K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K5 OUT, 'R40.K5'
DECLARE @R40K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K6 OUT, 'R40.K6'
DECLARE @R41K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K2 OUT, 'R41.K2'
DECLARE @R41K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K3 OUT, 'R41.K3'
DECLARE @R41K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K4 OUT, 'R41.K4'
DECLARE @R41K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K5 OUT, 'R41.K5'
DECLARE @R41K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K6 OUT, 'R41.K6'
DECLARE @R42K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R42K2 OUT, 'R42.K2'
DECLARE @R42K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R42K3 OUT, 'R42.K3'
DECLARE @R42K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R42K4 OUT, 'R42.K4'
DECLARE @R42K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R42K5 OUT, 'R42.K5'
DECLARE @R42K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R42K6 OUT, 'R42.K6'
DECLARE @R43K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R43K2 OUT, 'R43.K2'
DECLARE @R43K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R43K3 OUT, 'R43.K3'
DECLARE @R43K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R43K4 OUT, 'R43.K4'
DECLARE @R43K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R43K5 OUT, 'R43.K5'
DECLARE @R43K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R43K6 OUT, 'R43.K6'
DECLARE @Value nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'R45.PielikumsRindai14.Fails.value'
DECLARE @KomentarsValue nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R45.PielikumsRindai14.Komentars.value'
DECLARE @FailsValue nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R45.PielikumsRindai23.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R45.PielikumsRindai23.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R45.PielikumsRindai24.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R45.PielikumsRindai24.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'R45.PielikumsRindai41.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R45.PielikumsRindai41.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, 'R12.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R12.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R14.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R14.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R15.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R15.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R16.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R16.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R17.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R17.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R18.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R18.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R19.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R19.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R20.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R20.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R21.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R21.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R22.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R22.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R23.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R23.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R24.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R24.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R25.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R25.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R26.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R26.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R27.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R27.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R28.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R28.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R29.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R29.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R30.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R30.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R31.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R31.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R32.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R32.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R33.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R33.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R34.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R34.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R35.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R35.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R36.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R36.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R37.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R37.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R38.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R38.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R39.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R39.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R40.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R40.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R41.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R41.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R42.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'R42.K1[i]'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R43.K1'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R43.K1[i].value'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'R45.CitiDokumenti'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'R45.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/antv2/:id
Postman Collection Item JSON
{
"name": "Dokuments \"Tabakas izstrādājumu akcīzes nodokļa deklarācija\".",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/doc/antv2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv2",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/antv2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv2",
":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\": \"voluptate occaecat\",\n \"Talrunis\": \"ex consectetur Duis\",\n \"Gads\": -32148500,\n \"Menesis\": 2,\n \"Datums\": \"2000-01-31T00:00:00\",\n \"Statuss\": \"dolore magna labore officia eu\",\n \"R09\": \"ullamco\",\n \"R10\": \"aliqua culpa amet\",\n \"Sagatavotajs\": \"null\",\n \"SamTermins\": \"2000-01-31T00:00:00\",\n \"R11\": 81423595.70472443,\n \"R12\": {\n \"K1\": [\n -55811926.783076115,\n -27489309.773506805\n ],\n \"K2\": -26322052.92684917,\n \"K3\": 91174115.78638771,\n \"K4\": 35366928.168783605,\n \"K5\": -63052196.125354506,\n \"K6\": 88344391.9584584\n },\n \"R13\": 75942378.56973031,\n \"R14\": {\n \"K1\": [\n 26108959.669708163,\n 30000676.883922324\n ],\n \"K2\": -62948703.60251017,\n \"K3\": -15085804.986262992,\n \"K4\": 89325549.9340074,\n \"K5\": 93578258.4711434,\n \"K6\": 58122267.3771978\n },\n \"R15\": {\n \"K1\": [\n -53549562.084918186,\n -52391830.55384977\n ],\n \"K2\": 73073577.90459305,\n \"K3\": 93252599.71330437,\n \"K4\": 96630828.6844967,\n \"K5\": -59104722.17959515,\n \"K6\": 47800364.3893016\n },\n \"R16\": {\n \"K1\": [\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 \"K2\": -12878883.614582688,\n \"K3\": 12706690.488478586,\n \"K4\": -75246122.74759002,\n \"K5\": 87824033.11856943,\n \"K6\": -63738506.158957444\n },\n \"R17\": {\n \"K1\": [\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 \"K2\": -70081933.48710057,\n \"K3\": 19623571.714400694,\n \"K4\": 12719784.349283665,\n \"K5\": 82147118.90444493,\n \"K6\": 47603667.86847773\n },\n \"R18\": {\n \"K1\": [\n 37739087.89398542,\n 97914440.56552196\n ],\n \"K2\": -90705356.27924223,\n \"K3\": 33857901.930648014,\n \"K4\": 52453802.14974919,\n \"K5\": 73146172.62024462,\n \"K6\": 43846302.66323057\n },\n \"R19\": {\n \"K1\": [\n -63677793.2657322,\n -91206284.23958439\n ],\n \"K2\": 71513919.77603555,\n \"K3\": -9137312.499590859,\n \"K4\": -37686515.15663821,\n \"K5\": 25333286.294983417,\n \"K6\": 51858062.98208436\n },\n \"R20\": {\n \"K1\": [\n 98360931.77446848,\n 8679234.612219483\n ],\n \"K2\": -18642642.643749908,\n \"K3\": -77183434.29918173,\n \"K4\": 90459163.26731893,\n \"K5\": -73029424.2331607,\n \"K6\": 11492309.633789107\n },\n \"R21\": {\n \"K1\": [\n 82511439.01985362,\n 16550496.732448712\n ],\n \"K2\": 85092300.85531518,\n \"K3\": -58041295.05955951,\n \"K4\": 13462282.540345252,\n \"K5\": 35693227.5672932,\n \"K6\": -94760140.3623878\n },\n \"R22\": {\n \"K1\": [\n -57193918.6417274,\n -51259984.62950685\n ],\n \"K2\": -26225907.387124494,\n \"K3\": 43383612.80265048,\n \"K4\": -25665701.362420768,\n \"K5\": -60535473.966974474,\n \"K6\": 64362308.2559205\n },\n \"R23\": {\n \"K1\": [\n 47747017.14676356,\n 97841845.28650352\n ],\n \"K2\": -57883347.43486074,\n \"K3\": -36267097.137551606,\n \"K4\": 32578224.640988246,\n \"K5\": 56652514.14358893,\n \"K6\": -1971379.2314175516\n },\n \"R24\": {\n \"K1\": [\n -53115093.01483266,\n -4249478.346100107\n ],\n \"K2\": 26549690.05980234,\n \"K3\": 708372.2164720148,\n \"K4\": 46212213.90224978,\n \"K5\": -46888876.51303286,\n \"K6\": -16455607.936146647\n },\n \"R25\": {\n \"K1\": [\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 \"K2\": 10306119.523437962,\n \"K3\": 35425419.29494351,\n \"K4\": -89110798.34651288,\n \"K5\": 10905626.923329279,\n \"K6\": -12052196.963526279\n },\n \"R26\": {\n \"K1\": [\n -29901885.596135795,\n 30890036.587786883\n ],\n \"K2\": 80122776.35614228,\n \"K3\": 35537801.582769126,\n \"K4\": 37959092.780569494,\n \"K5\": 49698671.38823742,\n \"K6\": -78384948.58507419\n },\n \"R27\": {\n \"K1\": [\n 77565426.05743447,\n 61397934.726113856\n ],\n \"K2\": 24413167.19357501,\n \"K3\": -87569194.60042968,\n \"K4\": -97905977.16883345,\n \"K5\": 37932475.16228306,\n \"K6\": -84751824.0648602\n },\n \"R28\": {\n \"K1\": [\n -52488802.50292824,\n -55391641.32316285\n ],\n \"K2\": 75823495.38102835,\n \"K3\": -82261071.98753448,\n \"K4\": -77750925.80206864,\n \"K5\": 1715291.8924190402,\n \"K6\": 13227610.745488063\n },\n \"R29\": {\n \"K1\": [\n -79898446.27441585,\n 9195174.4429636\n ],\n \"K2\": 220840.8984989822,\n \"K3\": 31643752.3795667,\n \"K4\": 87412806.44297901,\n \"K5\": 74392115.9406603,\n \"K6\": -8235233.853508815\n },\n \"R30\": {\n \"K1\": [\n -22111789.470781535,\n 49907211.93263447\n ],\n \"K2\": 93460681.43746567,\n \"K3\": -19869683.428597048,\n \"K4\": -88504456.29682878,\n \"K5\": 69151681.42332351,\n \"K6\": 176675.95043580234\n },\n \"R31\": {\n \"K1\": [\n -34839205.42402092,\n -94428404.20908998\n ],\n \"K2\": 42225310.49026236,\n \"K3\": -55047037.82652038,\n \"K4\": 29137854.76134953,\n \"K5\": -77915743.40625095,\n \"K6\": 85797199.07378092\n },\n \"R32\": {\n \"K1\": [\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 \"K2\": 33452809.523544148,\n \"K3\": -61618706.95068687,\n \"K4\": 71222472.2602568,\n \"K5\": -39961199.77180004,\n \"K6\": 27574224.469748512\n },\n \"R33\": {\n \"K1\": [\n -22221033.132086277,\n 45930755.19282287\n ],\n \"K2\": -31623257.278335124,\n \"K3\": -44587566.69523667,\n \"K4\": -32897341.768002965,\n \"K5\": 21382843.684254736,\n \"K6\": 12904324.22194776\n },\n \"R34\": {\n \"K1\": [\n 76458756.48614231,\n -58513100.52231868\n ],\n \"K2\": 57445143.39397973,\n \"K3\": -58697479.574024715,\n \"K4\": 27092183.765359133,\n \"K5\": 86066991.8588464,\n \"K6\": -12833072.944992319\n },\n \"R35\": {\n \"K1\": [\n -8418549.476541415,\n 62481344.35299781\n ],\n \"K2\": -66422896.68134742,\n \"K3\": -83257669.32965006,\n \"K4\": -87739028.30112684,\n \"K5\": -57737419.363189615,\n \"K6\": 97682440.17745689\n },\n \"R36\": {\n \"K1\": [\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 \"K2\": -94454655.66888656,\n \"K3\": 67173283.14724523,\n \"K4\": -4148351.342897743,\n \"K5\": -95381705.52963567,\n \"K6\": -80931570.280611\n },\n \"R37\": {\n \"K1\": [\n 63160416.69133371,\n -74272468.97875252\n ],\n \"K2\": 9389552.512223348,\n \"K3\": 41754567.86103323,\n \"K4\": 4400298.588936955,\n \"K5\": 54009612.11361089,\n \"K6\": 19751522.711799607\n },\n \"R38\": {\n \"K1\": [\n 46349209.06335789,\n 2689107.4215914756\n ],\n \"K2\": 72435433.36861923,\n \"K3\": -30382746.357975468,\n \"K4\": 10530707.49252081,\n \"K5\": 72845973.66811547,\n \"K6\": -45102508.378410414\n },\n \"R39\": {\n \"K1\": [\n -95710836.08108011,\n 24694331.222817034\n ],\n \"K2\": -17105935.26779495,\n \"K3\": 98217302.10397539,\n \"K4\": -50541253.18172864,\n \"K5\": -75188791.4295811,\n \"K6\": -46448283.423055425\n },\n \"R40\": {\n \"K1\": [\n -79850713.27785406,\n 55745695.276213944\n ],\n \"K2\": -64122316.10616858,\n \"K3\": -86672583.02313714,\n \"K4\": -99222724.6089044,\n \"K5\": 57856672.56958261,\n \"K6\": 969177.2817018926\n },\n \"R41\": {\n \"K1\": [\n 24653325.6340757,\n 7180838.149691254\n ],\n \"K2\": 25373244.701280043,\n \"K3\": 35127412.50044766,\n \"K4\": 40534851.33730477,\n \"K5\": -4047027.083976522,\n \"K6\": -17155792.308277056\n },\n \"R42\": {\n \"K1\": [\n -38690510.176178925,\n -85269778.33996937\n ],\n \"K2\": -40254476.16227353,\n \"K3\": -98644014.64634968,\n \"K4\": -98703629.2642716,\n \"K5\": -47199938.69715049,\n \"K6\": -8503708.515376866\n },\n \"R43\": {\n \"K1\": [\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 \"K2\": -66756176.53218451,\n \"K3\": 32904250.256045,\n \"K4\": -11235742.305885792,\n \"K5\": -1029500.6580825001,\n \"K6\": -66150697.60184098\n },\n \"R45\": {\n \"PielikumsRindai14\": {\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 \"PielikumsRindai23\": {\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 \"PielikumsRindai24\": {\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 \"PielikumsRindai41\": {\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\": 68859334,\n \"UID\": \"labore sit ut\",\n \"NmrKods\": \"veniam \",\n \"Precizejums\": false,\n \"PrecizejamaisDokuments\": -69162291,\n \"PrecizejumaPamatojums\": \"ex\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/antv2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv2",
":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/antv2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv2",
":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/antv2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv2",
":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": ""
}
]
}
