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/antv3/: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": "culpa eiusmod dolore",
-- "Talrunis": "es",
-- "Gads": 47933838,
-- "Menesis": 1,
-- "Datums": "2000-01-31T00:00:00",
-- "Statuss": "in",
-- "R09": "laborum consectetur proident deserunt amet",
-- "R10": "amet elit reprehenderit",
-- "Sagatavotajs": "occaecat cillum in",
-- "SamTermins": "2000-01-31T00:00:00",
-- "R11": -11114159.014709607,
-- "R12": {
-- "K1": [
-- 93953028.36152482,
-- -65008596.446891434
-- ],
-- "K2": 75134836.41380084,
-- "K3": -52298287.47061216,
-- "K4": -96038579.82111105,
-- "K5": -98111146.25151935,
-- "K6": -70487657.38121934
-- },
-- "R13": -20681971.227454588,
-- "R14": {
-- "K1": [
-- -47176724.78716488,
-- -10879536.717188194
-- ],
-- "K2": 64269411.776504904,
-- "K3": -23154017.519810617,
-- "K4": 78933525.62091711,
-- "K5": -92174228.8484051,
-- "K6": 56106271.64190039
-- },
-- "R15": {
-- "K1": [
-- 59822303.67664111,
-- 7249267.532072425
-- ],
-- "K2": -71759130.39300954,
-- "K3": 4803254.869803026,
-- "K4": -88226780.88284524,
-- "K5": 84428390.98888579,
-- "K6": 85692299.15125632
-- },
-- "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": 17024326.371954232,
-- "K3": -72769479.52106814,
-- "K4": 96285860.05148315,
-- "K5": -1573379.5589383245,
-- "K6": -34119468.88885082
-- },
-- "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": -87985678.9304903,
-- "K3": 15179124.87882787,
-- "K4": -87593334.87756237,
-- "K5": 81202338.51156792,
-- "K6": -64056751.535340115
-- },
-- "R18": {
-- "K1": [
-- -96888574.36309597,
-- -43435791.12560372
-- ],
-- "K2": -66590273.75065989,
-- "K3": 60636259.18909258,
-- "K4": -32012732.21736276,
-- "K5": 15896095.030586466,
-- "K6": -68427994.13451672
-- },
-- "R19": {
-- "K1": [
-- -26217884.78196439,
-- 30794349.880667225
-- ],
-- "K2": -99543385.2253969,
-- "K3": 42374215.68276036,
-- "K4": 74071829.58361241,
-- "K5": -41467620.14228171,
-- "K6": 13462985.172314346
-- },
-- "R20": {
-- "K1": [
-- 1967907.8468105793,
-- 32801975.459351286
-- ],
-- "K2": 95551681.48910603,
-- "K3": -37376589.94355018,
-- "K4": 86797641.156618,
-- "K5": -33926430.37728997,
-- "K6": -58684413.667397894
-- },
-- "R21": {
-- "K1": [
-- -84326872.7478427,
-- -79099690.29392707
-- ],
-- "K2": 40321930.90888682,
-- "K3": 65447771.02093935,
-- "K4": 57754941.70589638,
-- "K5": -92724630.08845589,
-- "K6": -6776381.825107291
-- },
-- "R22": {
-- "K1": [
-- 43016130.32658467,
-- 88271231.89453223
-- ],
-- "K2": 58228483.22719234,
-- "K3": 1709067.216455251,
-- "K4": -54786588.516483456,
-- "K5": 62114688.752978295,
-- "K6": 97078035.98679331
-- },
-- "R23": {
-- "K1": [
-- 60403871.07803774,
-- -19127069.157093897
-- ],
-- "K2": 79416132.09341303,
-- "K3": 48543627.79238045,
-- "K4": 76931659.30271983,
-- "K5": 33377574.77562934,
-- "K6": 93725269.66591841
-- },
-- "R24": {
-- "K1": [
-- 53578648.644761145,
-- -88537046.66771187
-- ],
-- "K2": -72540264.9546611,
-- "K3": 13650541.755281553,
-- "K4": -18968558.77633463,
-- "K5": 70845437.77477238,
-- "K6": 30452938.3146587
-- },
-- "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": -55777851.302425854,
-- "K3": -84321009.90249683,
-- "K4": -51851963.80789452,
-- "K5": 88085660.29928339,
-- "K6": -19382522.955699682
-- },
-- "R26": {
-- "K1": [
-- 79338348.71504587,
-- -49461200.6343035
-- ],
-- "K2": 50977572.0186314,
-- "K3": -50739449.26093157,
-- "K4": 78627784.28159517,
-- "K5": -44294600.31378851,
-- "K6": 13899049.374730632
-- },
-- "R27": {
-- "K1": [
-- -95645898.48641644,
-- 56814939.23327142
-- ],
-- "K2": -50214454.265600495,
-- "K3": -38270777.84355408,
-- "K4": -35033983.08520187,
-- "K5": 25087516.93764113,
-- "K6": 783443.6200878471
-- },
-- "R28": {
-- "K1": [
-- -30855281.205273107,
-- 71456282.59544298
-- ],
-- "K2": -82420565.77388829,
-- "K3": 79360963.13206372,
-- "K4": 17556960.783118665,
-- "K5": -39985089.35508989,
-- "K6": -88464403.8893168
-- },
-- "R29": {
-- "K1": [
-- -16202438.428395867,
-- 22162520.230124637
-- ],
-- "K2": -59461858.33023407,
-- "K3": -81784549.14355382,
-- "K4": -40336399.974376924,
-- "K5": 16463856.714859843,
-- "K6": 15228710.770068556
-- },
-- "R30": {
-- "K1": [
-- 39589694.27043885,
-- 47349607.60847008
-- ],
-- "K2": 70519235.68374515,
-- "K3": -15850490.988809302,
-- "K4": 55102594.956315845,
-- "K5": -9561875.885224015,
-- "K6": -22735613.68601209
-- },
-- "R31": {
-- "K1": [
-- 55521037.29837489,
-- 22635827.388498962
-- ],
-- "K2": 5275333.811540112,
-- "K3": -69262026.98770143,
-- "K4": -72698862.98212205,
-- "K5": 67504090.93319285,
-- "K6": -44488572.50111496
-- },
-- "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": 21641068.799510866,
-- "K3": -85128699.0540392,
-- "K4": -92946518.8182553,
-- "K5": 50903736.87779376,
-- "K6": -87709597.80293962
-- },
-- "R33": {
-- "K1": [
-- 42390082.53749135,
-- 22590149.63425523
-- ],
-- "K2": -42836502.34090421,
-- "K3": -84144574.77053764,
-- "K4": 53264791.07034543,
-- "K5": -16093705.959762514,
-- "K6": -83197865.57138915
-- },
-- "R34": {
-- "K1": [
-- -30591476.918286726,
-- -57342761.7471975
-- ],
-- "K2": 63381715.89566225,
-- "K3": 90832059.45392913,
-- "K4": -75343114.81749989,
-- "K5": 30466316.238888115,
-- "K6": 59045124.55128595
-- },
-- "R35": {
-- "K1": [
-- 84549154.30514628,
-- 65285043.795383096
-- ],
-- "K2": -70500634.72365537,
-- "K3": 35942183.29884845,
-- "K4": -39577424.685108565,
-- "K5": -64711846.74928718,
-- "K6": 25109017.034134105
-- },
-- "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": -21565138.432464257,
-- "K3": -91345038.05815908,
-- "K4": -94043282.97333881,
-- "K5": -72877074.7425068,
-- "K6": 73952900.24763778
-- },
-- "R37": {
-- "K1": [
-- 25533685.674229905,
-- 70742483.74929252
-- ],
-- "K2": -5534790.123072803,
-- "K3": 86593376.27984217,
-- "K4": -4538419.893676922,
-- "K5": -64381931.18857538,
-- "K6": -93958545.62867525
-- },
-- "R38": {
-- "K1": [
-- -27326018.296371445,
-- -77423855.33064468
-- ],
-- "K2": -22072561.63234867,
-- "K3": 9262280.469531298,
-- "K4": -80270941.64703517,
-- "K5": 18641569.762177438,
-- "K6": 7340470.673906818
-- },
-- "R39": {
-- "K1": [
-- 49877567.71444246,
-- 7907770.2645217925
-- ],
-- "K2": 61699438.66595596,
-- "K3": -19693.25648279488,
-- "K4": -69569660.7636616,
-- "K5": 2301080.0803869218,
-- "K6": 24011476.807759672
-- },
-- "R40": {
-- "K1": [
-- 55282603.23224807,
-- -66415415.16032099
-- ],
-- "K2": 81868404.40510118,
-- "K3": -70241957.56071526,
-- "K4": 47118593.359558314,
-- "K5": 21161274.082392946,
-- "K6": -73708077.6631499
-- },
-- "R41": {
-- "K1": [
-- -37209458.25072697,
-- -15835879.259030074
-- ],
-- "K2": 62440121.34000081,
-- "K3": 54273054.795594424,
-- "K4": 5262992.562319726,
-- "K5": -15929559.723377734,
-- "K6": 11397683.13452962
-- },
-- "R42": {
-- "K1": [
-- -24814330.734300956,
-- 34102730.58582121
-- ],
-- "K2": 24114320.74535726,
-- "K3": -43733895.905811206,
-- "K4": -85999197.20288529,
-- "K5": -99521183.75025822,
-- "K6": -46966718.78773064
-- },
-- "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": 49597116.12759814,
-- "K3": 9803977.79413411,
-- "K4": -77352391.36494827,
-- "K5": -96523720.10868482,
-- "K6": -41064033.26456829
-- },
-- "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>"
-- }
-- },
-- "PielikumsRindai38": {
-- "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": 42039573,
-- "UID": "laboris",
-- "NmrKods": "fugiat ad",
-- "Precizejums": true,
-- "PrecizejamaisDokuments": 44687366,
-- "PrecizejumaPamatojums": "in sed dolore"
-- }
-- 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.PielikumsRindai38.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'R45.PielikumsRindai38.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/antv3/: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/antv3/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv3",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/antv3/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv3",
":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\": \"culpa eiusmod dolore\",\n \"Talrunis\": \"es\",\n \"Gads\": 47933838,\n \"Menesis\": 1,\n \"Datums\": \"2000-01-31T00:00:00\",\n \"Statuss\": \"in\",\n \"R09\": \"laborum consectetur proident deserunt amet\",\n \"R10\": \"amet elit reprehenderit\",\n \"Sagatavotajs\": \"occaecat cillum in\",\n \"SamTermins\": \"2000-01-31T00:00:00\",\n \"R11\": -11114159.014709607,\n \"R12\": {\n \"K1\": [\n 93953028.36152482,\n -65008596.446891434\n ],\n \"K2\": 75134836.41380084,\n \"K3\": -52298287.47061216,\n \"K4\": -96038579.82111105,\n \"K5\": -98111146.25151935,\n \"K6\": -70487657.38121934\n },\n \"R13\": -20681971.227454588,\n \"R14\": {\n \"K1\": [\n -47176724.78716488,\n -10879536.717188194\n ],\n \"K2\": 64269411.776504904,\n \"K3\": -23154017.519810617,\n \"K4\": 78933525.62091711,\n \"K5\": -92174228.8484051,\n \"K6\": 56106271.64190039\n },\n \"R15\": {\n \"K1\": [\n 59822303.67664111,\n 7249267.532072425\n ],\n \"K2\": -71759130.39300954,\n \"K3\": 4803254.869803026,\n \"K4\": -88226780.88284524,\n \"K5\": 84428390.98888579,\n \"K6\": 85692299.15125632\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\": 17024326.371954232,\n \"K3\": -72769479.52106814,\n \"K4\": 96285860.05148315,\n \"K5\": -1573379.5589383245,\n \"K6\": -34119468.88885082\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\": -87985678.9304903,\n \"K3\": 15179124.87882787,\n \"K4\": -87593334.87756237,\n \"K5\": 81202338.51156792,\n \"K6\": -64056751.535340115\n },\n \"R18\": {\n \"K1\": [\n -96888574.36309597,\n -43435791.12560372\n ],\n \"K2\": -66590273.75065989,\n \"K3\": 60636259.18909258,\n \"K4\": -32012732.21736276,\n \"K5\": 15896095.030586466,\n \"K6\": -68427994.13451672\n },\n \"R19\": {\n \"K1\": [\n -26217884.78196439,\n 30794349.880667225\n ],\n \"K2\": -99543385.2253969,\n \"K3\": 42374215.68276036,\n \"K4\": 74071829.58361241,\n \"K5\": -41467620.14228171,\n \"K6\": 13462985.172314346\n },\n \"R20\": {\n \"K1\": [\n 1967907.8468105793,\n 32801975.459351286\n ],\n \"K2\": 95551681.48910603,\n \"K3\": -37376589.94355018,\n \"K4\": 86797641.156618,\n \"K5\": -33926430.37728997,\n \"K6\": -58684413.667397894\n },\n \"R21\": {\n \"K1\": [\n -84326872.7478427,\n -79099690.29392707\n ],\n \"K2\": 40321930.90888682,\n \"K3\": 65447771.02093935,\n \"K4\": 57754941.70589638,\n \"K5\": -92724630.08845589,\n \"K6\": -6776381.825107291\n },\n \"R22\": {\n \"K1\": [\n 43016130.32658467,\n 88271231.89453223\n ],\n \"K2\": 58228483.22719234,\n \"K3\": 1709067.216455251,\n \"K4\": -54786588.516483456,\n \"K5\": 62114688.752978295,\n \"K6\": 97078035.98679331\n },\n \"R23\": {\n \"K1\": [\n 60403871.07803774,\n -19127069.157093897\n ],\n \"K2\": 79416132.09341303,\n \"K3\": 48543627.79238045,\n \"K4\": 76931659.30271983,\n \"K5\": 33377574.77562934,\n \"K6\": 93725269.66591841\n },\n \"R24\": {\n \"K1\": [\n 53578648.644761145,\n -88537046.66771187\n ],\n \"K2\": -72540264.9546611,\n \"K3\": 13650541.755281553,\n \"K4\": -18968558.77633463,\n \"K5\": 70845437.77477238,\n \"K6\": 30452938.3146587\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\": -55777851.302425854,\n \"K3\": -84321009.90249683,\n \"K4\": -51851963.80789452,\n \"K5\": 88085660.29928339,\n \"K6\": -19382522.955699682\n },\n \"R26\": {\n \"K1\": [\n 79338348.71504587,\n -49461200.6343035\n ],\n \"K2\": 50977572.0186314,\n \"K3\": -50739449.26093157,\n \"K4\": 78627784.28159517,\n \"K5\": -44294600.31378851,\n \"K6\": 13899049.374730632\n },\n \"R27\": {\n \"K1\": [\n -95645898.48641644,\n 56814939.23327142\n ],\n \"K2\": -50214454.265600495,\n \"K3\": -38270777.84355408,\n \"K4\": -35033983.08520187,\n \"K5\": 25087516.93764113,\n \"K6\": 783443.6200878471\n },\n \"R28\": {\n \"K1\": [\n -30855281.205273107,\n 71456282.59544298\n ],\n \"K2\": -82420565.77388829,\n \"K3\": 79360963.13206372,\n \"K4\": 17556960.783118665,\n \"K5\": -39985089.35508989,\n \"K6\": -88464403.8893168\n },\n \"R29\": {\n \"K1\": [\n -16202438.428395867,\n 22162520.230124637\n ],\n \"K2\": -59461858.33023407,\n \"K3\": -81784549.14355382,\n \"K4\": -40336399.974376924,\n \"K5\": 16463856.714859843,\n \"K6\": 15228710.770068556\n },\n \"R30\": {\n \"K1\": [\n 39589694.27043885,\n 47349607.60847008\n ],\n \"K2\": 70519235.68374515,\n \"K3\": -15850490.988809302,\n \"K4\": 55102594.956315845,\n \"K5\": -9561875.885224015,\n \"K6\": -22735613.68601209\n },\n \"R31\": {\n \"K1\": [\n 55521037.29837489,\n 22635827.388498962\n ],\n \"K2\": 5275333.811540112,\n \"K3\": -69262026.98770143,\n \"K4\": -72698862.98212205,\n \"K5\": 67504090.93319285,\n \"K6\": -44488572.50111496\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\": 21641068.799510866,\n \"K3\": -85128699.0540392,\n \"K4\": -92946518.8182553,\n \"K5\": 50903736.87779376,\n \"K6\": -87709597.80293962\n },\n \"R33\": {\n \"K1\": [\n 42390082.53749135,\n 22590149.63425523\n ],\n \"K2\": -42836502.34090421,\n \"K3\": -84144574.77053764,\n \"K4\": 53264791.07034543,\n \"K5\": -16093705.959762514,\n \"K6\": -83197865.57138915\n },\n \"R34\": {\n \"K1\": [\n -30591476.918286726,\n -57342761.7471975\n ],\n \"K2\": 63381715.89566225,\n \"K3\": 90832059.45392913,\n \"K4\": -75343114.81749989,\n \"K5\": 30466316.238888115,\n \"K6\": 59045124.55128595\n },\n \"R35\": {\n \"K1\": [\n 84549154.30514628,\n 65285043.795383096\n ],\n \"K2\": -70500634.72365537,\n \"K3\": 35942183.29884845,\n \"K4\": -39577424.685108565,\n \"K5\": -64711846.74928718,\n \"K6\": 25109017.034134105\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\": -21565138.432464257,\n \"K3\": -91345038.05815908,\n \"K4\": -94043282.97333881,\n \"K5\": -72877074.7425068,\n \"K6\": 73952900.24763778\n },\n \"R37\": {\n \"K1\": [\n 25533685.674229905,\n 70742483.74929252\n ],\n \"K2\": -5534790.123072803,\n \"K3\": 86593376.27984217,\n \"K4\": -4538419.893676922,\n \"K5\": -64381931.18857538,\n \"K6\": -93958545.62867525\n },\n \"R38\": {\n \"K1\": [\n -27326018.296371445,\n -77423855.33064468\n ],\n \"K2\": -22072561.63234867,\n \"K3\": 9262280.469531298,\n \"K4\": -80270941.64703517,\n \"K5\": 18641569.762177438,\n \"K6\": 7340470.673906818\n },\n \"R39\": {\n \"K1\": [\n 49877567.71444246,\n 7907770.2645217925\n ],\n \"K2\": 61699438.66595596,\n \"K3\": -19693.25648279488,\n \"K4\": -69569660.7636616,\n \"K5\": 2301080.0803869218,\n \"K6\": 24011476.807759672\n },\n \"R40\": {\n \"K1\": [\n 55282603.23224807,\n -66415415.16032099\n ],\n \"K2\": 81868404.40510118,\n \"K3\": -70241957.56071526,\n \"K4\": 47118593.359558314,\n \"K5\": 21161274.082392946,\n \"K6\": -73708077.6631499\n },\n \"R41\": {\n \"K1\": [\n -37209458.25072697,\n -15835879.259030074\n ],\n \"K2\": 62440121.34000081,\n \"K3\": 54273054.795594424,\n \"K4\": 5262992.562319726,\n \"K5\": -15929559.723377734,\n \"K6\": 11397683.13452962\n },\n \"R42\": {\n \"K1\": [\n -24814330.734300956,\n 34102730.58582121\n ],\n \"K2\": 24114320.74535726,\n \"K3\": -43733895.905811206,\n \"K4\": -85999197.20288529,\n \"K5\": -99521183.75025822,\n \"K6\": -46966718.78773064\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\": 49597116.12759814,\n \"K3\": 9803977.79413411,\n \"K4\": -77352391.36494827,\n \"K5\": -96523720.10868482,\n \"K6\": -41064033.26456829\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 \"PielikumsRindai38\": {\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\": 42039573,\n \"UID\": \"laboris\",\n \"NmrKods\": \"fugiat ad\",\n \"Precizejums\": true,\n \"PrecizejamaisDokuments\": 44687366,\n \"PrecizejumaPamatojums\": \"in sed dolore\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/antv3/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv3",
":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/antv3/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv3",
":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/antv3/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"antv3",
":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": ""
}
]
}
