SQL Server / EDS API / Dokuments "Alkoholisko dzērienu 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/anav4/: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": "est enim pariatur deserunt culpa",
-- "Talrunis": "ad paria",
-- "Gads": 31478571,
-- "Menesis": 1,
-- "Datums": "2000-01-31T00:00:00",
-- "Statuss": "ex velit",
-- "R09": "eu ad",
-- "R10": "do Duis adipisicing eu elit",
-- "Sagatavotajs": "eiusmod cillum",
-- "SamTermins": "2000-01-31T00:00:00",
-- "R11": {
-- "K1": -75134466.33476177,
-- "K2": -48699298.3409114,
-- "K3": -99413150.3417543,
-- "K4": -83797417.80346124,
-- "K5": 28288547.42313686,
-- "K6": -22711058.977118492,
-- "K7": -96102912.59660086,
-- "K8": 4942839.422306016,
-- "K9": -26461448.129657894,
-- "K10": 71480797.22039315,
-- "K11": -24708223.086522803
-- },
-- "R12": {
-- "K1": 28120889.077360317,
-- "K2": 81997550.1489962,
-- "K3": 9609233.737401724,
-- "K4": -64718031.47915711,
-- "K5": -23025640.832763463,
-- "K6": -1126966.4816737622,
-- "K7": -84267430.25742783,
-- "K8": 9681010.73999405,
-- "K9": 42997776.21043238,
-- "K10": -96749200.78967935,
-- "K11": 70373006.00781378
-- },
-- "R13": {
-- "K1": -86449306.58052914,
-- "K2": 51824940.05330777,
-- "K3": -74881590.69828098,
-- "K4": 11313283.640554816,
-- "K5": 73477414.13531795,
-- "K6": 48080324.00782171,
-- "K7": -81208901.32493557,
-- "K8": 50433274.407880604,
-- "K9": 83485383.1475285,
-- "K10": 16668743.002714545,
-- "K11": 9836444.772695035
-- },
-- "R14": {
-- "K1": 57118881.02458906,
-- "K2": 79383003.06469691,
-- "K3": -89758030.0769056,
-- "K4": -61736046.07100072,
-- "K5": 23017023.721902728,
-- "K6": 6718577.627643317,
-- "K7": -57338279.37538596,
-- "K8": -16615799.931319281,
-- "K9": 56966279.19264859,
-- "K10": -27322626.639141887,
-- "K11": 44575223.26244584
-- },
-- "R15": {
-- "K1": 78093082.2168409,
-- "K2": 51440893.46983755,
-- "K3": -2922853.364090547,
-- "K4": -26492019.24007167,
-- "K5": -41793363.915394455,
-- "K6": 47294848.519970536,
-- "K7": 62323410.96574205,
-- "K8": -44115767.63375371,
-- "K9": -27485290.10509588,
-- "K10": 8894933.629735082,
-- "K11": 13036182.663037851
-- },
-- "R16": {
-- "K1": 23205848.268277228,
-- "K2": -85436802.97384508,
-- "K3": -38791307.51897493,
-- "K4": -51789609.51507707,
-- "K5": 36804389.740775436,
-- "K6": 82937448.4137449,
-- "K7": -85359352.69194126,
-- "K8": 5688247.845175847,
-- "K9": 22135687.707852364,
-- "K10": 70730228.67338988,
-- "K11": 9713027.399367258
-- },
-- "R17": {
-- "K1": 73469154.03595454,
-- "K2": -25777278.342222363,
-- "K3": 94631531.40675619,
-- "K4": -58187733.2635214,
-- "K5": 45918741.7641986,
-- "K6": -13651127.962059379,
-- "K7": -90928180.31327638,
-- "K8": -97489863.92535937,
-- "K9": 62078296.06969395,
-- "K10": 78336141.83939478,
-- "K11": -90528507.48485945
-- },
-- "R18": {
-- "K1": -5243205.639127746,
-- "K2": -44992745.268658265,
-- "K3": 27469212.084040955,
-- "K4": 2941478.7965110093,
-- "K5": 82611703.01163715,
-- "K6": -84447221.65674761,
-- "K7": 15883061.808513284,
-- "K8": 38745584.739284724,
-- "K9": -35394917.17324661,
-- "K10": 5179832.802335143,
-- "K11": -27895300.239142567
-- },
-- "R19": {
-- "K1": -76654909.25083923,
-- "K2": -84291476.46052751,
-- "K3": 24912878.74828933,
-- "K4": 88846738.96892026,
-- "K5": -48804069.191867016,
-- "K6": 23762640.644861624,
-- "K7": -96678535.12866524,
-- "K8": -78796766.80043142,
-- "K9": -46029646.71542966,
-- "K10": 90377340.98000577,
-- "K11": -66032488.22707224
-- },
-- "R20": {
-- "K1": 3813220.5633409023,
-- "K2": -75333315.58757487,
-- "K3": -81271204.60130826,
-- "K4": -19424929.180203736,
-- "K5": -46084342.55965781,
-- "K6": 80542382.74884117,
-- "K7": -76697022.753561,
-- "K8": 91189214.26495796,
-- "K9": 74509672.4875839,
-- "K10": -67519542.22286773,
-- "K11": 63609260.98256791
-- },
-- "R21": {
-- "K1": -67485419.35181591,
-- "K2": 59182237.15205687,
-- "K3": -42864712.90786809,
-- "K4": 89855511.76301253,
-- "K5": 8784579.926392138,
-- "K6": -11107298.829912841,
-- "K7": -71482933.24300243,
-- "K8": 50161004.21751064,
-- "K9": 47256722.74296865,
-- "K10": 35068511.14367682,
-- "K11": 97140216.9313682
-- },
-- "R22": {
-- "K1": 51611089.73318097,
-- "K2": 18530633.066504225,
-- "K3": 77758900.1615347,
-- "K4": -13680258.270694032,
-- "K5": -52031377.69422348,
-- "K6": 88628056.79937878,
-- "K7": 78358616.24079949,
-- "K8": -82664839.81997612,
-- "K9": -16917501.453631848,
-- "K10": -4080294.389188975,
-- "K11": -5085004.738127679
-- },
-- "R24": {
-- "K1": 30353571.889823347,
-- "K2": 81662305.44511649,
-- "K3": -26750365.96183458,
-- "K4": -97242914.9240976,
-- "K5": 88662566.52571255,
-- "K6": 8197201.516497105,
-- "K7": 89329155.81638014,
-- "K8": 24599136.53307493,
-- "K9": 23688695.184291884,
-- "K10": -75832800.81577733,
-- "K11": -88099985.45339087
-- },
-- "R25": {
-- "K1": -81063512.97571033,
-- "K2": -974978.6831183583,
-- "K3": 87076202.33061698,
-- "K4": -26942514.30015719,
-- "K5": -51557980.349297635,
-- "K6": 38007916.078596264,
-- "K7": -32566799.116636112,
-- "K8": -40944594.13948641,
-- "K9": -2073022.9192552418,
-- "K10": 10262325.06134677,
-- "K11": 61183835.85953021
-- },
-- "R26": {
-- "K1": 79220240.24234876,
-- "K2": -18523513.85371986,
-- "K3": -792647.3084940463,
-- "K4": 79478256.95248395,
-- "K5": -90531699.87374501,
-- "K6": -5898387.922647521,
-- "K7": 82610773.62906301,
-- "K8": 37744764.49042261,
-- "K9": 35916078.96586746,
-- "K10": 38238932.07087457,
-- "K11": -68753131.43338704
-- },
-- "R27": {
-- "K1": -69339849.91716105,
-- "K2": 65361271.97400886,
-- "K3": 52263946.74765307,
-- "K4": 80117406.95577565,
-- "K5": -78272376.1656011,
-- "K6": 80396538.92308447,
-- "K7": -70969768.7791527,
-- "K8": -22467075.121106014,
-- "K9": -83958093.9249363,
-- "K10": -83762346.09689175,
-- "K11": -60450925.01919953
-- },
-- "R28": {
-- "K1": 82192876.65358993,
-- "K2": -88366676.2700917,
-- "K3": -25131270.974725425,
-- "K4": 81848041.7233392,
-- "K5": 63651373.10281232,
-- "K6": 97717765.50277749,
-- "K7": -20350264.16622418,
-- "K8": 55467962.90263814,
-- "K9": -48377038.896852255,
-- "K10": 39530478.19681737,
-- "K11": -8736509.751999617
-- },
-- "R29": {
-- "K1": 1329546.4833407104,
-- "K2": -36428883.587767705,
-- "K3": 44381289.64497295,
-- "K4": 17367426.550662562,
-- "K5": -46067505.91279427,
-- "K6": -27602197.628391683,
-- "K7": -91076807.60094298,
-- "K8": -25404085.85834025,
-- "K9": -7307814.28149569,
-- "K10": -18085908.810195312,
-- "K11": -94758381.66935055
-- },
-- "R30": {
-- "K1": -17228220.54108998,
-- "K2": 82493255.9559797,
-- "K3": 65624194.775191605,
-- "K4": 59715467.76626924,
-- "K5": -91262576.58340618,
-- "K6": -67902848.77319577,
-- "K7": 11839832.907837257,
-- "K8": -9324648.076048091,
-- "K9": -45725377.365549356,
-- "K10": 85622472.44880953,
-- "K11": -75041540.89969379
-- },
-- "R32": {
-- "K1": 18191759.860879213,
-- "K2": 72892478.54482341,
-- "K3": -79952321.7926965,
-- "K4": -26872529.70128022,
-- "K5": -36315913.253182374,
-- "K6": -19314942.251303345,
-- "K7": -36562920.96460767,
-- "K8": -83005587.23185527,
-- "K9": 68808822.38204813,
-- "K10": 72011356.8115209,
-- "K11": 30073286.827217907
-- },
-- "R33": {
-- "K1": -14835858.73258084,
-- "K2": 9804775.715329587,
-- "K3": -56377072.15039449,
-- "K4": 20248372.602051973,
-- "K5": -17107749.42720841,
-- "K6": 12182595.031442747,
-- "K7": 10350040.97562702,
-- "K8": 77334501.59528625,
-- "K9": -63141456.213893935,
-- "K10": 5943805.486367688,
-- "K11": 76202159.89486194
-- },
-- "R34": {
-- "K1": -71077121.7601804,
-- "K2": -25607390.85821879,
-- "K3": 63164594.50739518,
-- "K4": 95149513.24353734,
-- "K5": 8148177.130351365,
-- "K6": 98384134.27733582,
-- "K7": 13483683.205103472,
-- "K8": 552331.8556017727,
-- "K9": 83004805.1109423,
-- "K10": -940385.4543728083,
-- "K11": 13477608.342944965
-- },
-- "R36": {
-- "K1": 99894890.53865567,
-- "K2": 15321458.483672813,
-- "K3": 46649100.38260701,
-- "K4": 92755760.68062004,
-- "K5": -57599717.14221859,
-- "K6": -71853434.37764624,
-- "K7": 25776944.369388714,
-- "K8": 41620820.185993254,
-- "K9": -53286044.09712141,
-- "K10": -47983292.444122046,
-- "K11": -12433275.961624444
-- },
-- "R37": {
-- "K1": 35420483.24655411,
-- "K2": -21070326.678702235,
-- "K3": -6616023.071576834,
-- "K4": 14520195.492538556,
-- "K5": -97476792.29387778,
-- "K6": 30216700.588341534,
-- "K7": 34421637.114123195,
-- "K8": -23359235.054106712,
-- "K9": -70397146.29079673,
-- "K10": -48736531.254686266,
-- "K11": 45438977.585956186
-- },
-- "R38": {
-- "K1": 1990165.0967748612,
-- "K2": 71097169.82269916,
-- "K3": -71556579.10749543,
-- "K4": -54881374.982076816,
-- "K5": -95119650.54293019,
-- "K6": -91858720.2102187,
-- "K7": -33936258.58035971,
-- "K8": 63999412.45529953,
-- "K9": 69908195.97680008,
-- "K10": 10211757.634596229,
-- "K11": -74412018.98690775
-- },
-- "R39": {
-- "K1": -52891754.88971054,
-- "K2": 70189272.17991248,
-- "K3": -27400905.146460548,
-- "K4": 86626425.88846663,
-- "K5": 19002254.956758246,
-- "K6": -90528263.15229324,
-- "K7": 87381182.28088698,
-- "K8": -76699006.77147949,
-- "K9": 96738554.32291925,
-- "K10": 40786294.43217343,
-- "K11": -34816268.67534917
-- },
-- "R40": {
-- "K1": 83837091.79189956,
-- "K2": -87915556.58802816,
-- "K3": 24417466.012435704,
-- "K4": -43880915.25518525,
-- "K5": -69034679.89739527,
-- "K6": -6685306.312743038,
-- "K7": -16981358.691801682,
-- "K8": 91910374.27698961,
-- "K9": 34669912.62813935,
-- "K10": -16728893.337160721,
-- "K11": 22398893.986314267
-- },
-- "R41": {
-- "K1": 98897696.46753588,
-- "K2": 99919824.97218785,
-- "K3": 11283166.054576471,
-- "K4": 81304598.9077251,
-- "K5": -53584524.608154014,
-- "K6": 97968581.58158943,
-- "K7": 96314560.32973632,
-- "K8": -19532400.235378593,
-- "K9": 12737966.89336364,
-- "K10": 12925298.53924194,
-- "K11": -13628181.880051568
-- },
-- "Pielikumi": {
-- "PielikumsRindai18": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai19": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai20": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai21": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai22": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai37": {
-- "Fails": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Komentars": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "PielikumsRindai40": {
-- "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": -1819993,
-- "UID": "aliqua dolore in consectetur",
-- "NmrKods": "si",
-- "Precizejums": false,
-- "PrecizejamaisDokuments": -2972997,
-- "PrecizejumaPamatojums": "enim proident Excepteur in"
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @value nvarchar(4000)
DECLARE @Epasts nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Epasts OUT, 'Epasts'
DECLARE @Talrunis nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Talrunis OUT, 'Talrunis'
DECLARE @Gads int
EXEC sp_OAMethod @jResp, 'IntOf', @Gads OUT, 'Gads'
DECLARE @Menesis int
EXEC sp_OAMethod @jResp, 'IntOf', @Menesis OUT, 'Menesis'
DECLARE @Datums nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Datums OUT, 'Datums'
DECLARE @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 @K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K1 OUT, 'R11.K1'
DECLARE @K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K2 OUT, 'R11.K2'
DECLARE @K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K3 OUT, 'R11.K3'
DECLARE @K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K4 OUT, 'R11.K4'
DECLARE @K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K5 OUT, 'R11.K5'
DECLARE @K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K6 OUT, 'R11.K6'
DECLARE @K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K7 OUT, 'R11.K7'
DECLARE @K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K8 OUT, 'R11.K8'
DECLARE @K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K9 OUT, 'R11.K9'
DECLARE @K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K10 OUT, 'R11.K10'
DECLARE @K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @K11 OUT, 'R11.K11'
DECLARE @R12K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K1 OUT, 'R12.K1'
DECLARE @R12K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K2 OUT, 'R12.K2'
DECLARE @R12K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K3 OUT, 'R12.K3'
DECLARE @R12K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K4 OUT, 'R12.K4'
DECLARE @R12K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K5 OUT, 'R12.K5'
DECLARE @R12K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K6 OUT, 'R12.K6'
DECLARE @R12K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K7 OUT, 'R12.K7'
DECLARE @R12K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K8 OUT, 'R12.K8'
DECLARE @R12K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K9 OUT, 'R12.K9'
DECLARE @R12K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K10 OUT, 'R12.K10'
DECLARE @R12K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R12K11 OUT, 'R12.K11'
DECLARE @R13K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K1 OUT, 'R13.K1'
DECLARE @R13K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K2 OUT, 'R13.K2'
DECLARE @R13K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K3 OUT, 'R13.K3'
DECLARE @R13K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K4 OUT, 'R13.K4'
DECLARE @R13K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K5 OUT, 'R13.K5'
DECLARE @R13K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K6 OUT, 'R13.K6'
DECLARE @R13K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K7 OUT, 'R13.K7'
DECLARE @R13K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K8 OUT, 'R13.K8'
DECLARE @R13K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K9 OUT, 'R13.K9'
DECLARE @R13K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K10 OUT, 'R13.K10'
DECLARE @R13K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R13K11 OUT, 'R13.K11'
DECLARE @R14K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K1 OUT, 'R14.K1'
DECLARE @R14K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K2 OUT, 'R14.K2'
DECLARE @R14K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K3 OUT, 'R14.K3'
DECLARE @R14K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K4 OUT, 'R14.K4'
DECLARE @R14K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K5 OUT, 'R14.K5'
DECLARE @R14K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K6 OUT, 'R14.K6'
DECLARE @R14K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K7 OUT, 'R14.K7'
DECLARE @R14K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K8 OUT, 'R14.K8'
DECLARE @R14K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K9 OUT, 'R14.K9'
DECLARE @R14K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K10 OUT, 'R14.K10'
DECLARE @R14K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R14K11 OUT, 'R14.K11'
DECLARE @R15K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K1 OUT, 'R15.K1'
DECLARE @R15K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K2 OUT, 'R15.K2'
DECLARE @R15K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K3 OUT, 'R15.K3'
DECLARE @R15K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K4 OUT, 'R15.K4'
DECLARE @R15K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K5 OUT, 'R15.K5'
DECLARE @R15K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K6 OUT, 'R15.K6'
DECLARE @R15K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K7 OUT, 'R15.K7'
DECLARE @R15K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K8 OUT, 'R15.K8'
DECLARE @R15K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K9 OUT, 'R15.K9'
DECLARE @R15K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K10 OUT, 'R15.K10'
DECLARE @R15K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R15K11 OUT, 'R15.K11'
DECLARE @R16K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K1 OUT, 'R16.K1'
DECLARE @R16K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K2 OUT, 'R16.K2'
DECLARE @R16K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K3 OUT, 'R16.K3'
DECLARE @R16K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K4 OUT, 'R16.K4'
DECLARE @R16K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K5 OUT, 'R16.K5'
DECLARE @R16K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K6 OUT, 'R16.K6'
DECLARE @R16K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K7 OUT, 'R16.K7'
DECLARE @R16K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K8 OUT, 'R16.K8'
DECLARE @R16K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K9 OUT, 'R16.K9'
DECLARE @R16K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K10 OUT, 'R16.K10'
DECLARE @R16K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R16K11 OUT, 'R16.K11'
DECLARE @R17K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K1 OUT, 'R17.K1'
DECLARE @R17K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K2 OUT, 'R17.K2'
DECLARE @R17K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K3 OUT, 'R17.K3'
DECLARE @R17K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K4 OUT, 'R17.K4'
DECLARE @R17K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K5 OUT, 'R17.K5'
DECLARE @R17K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K6 OUT, 'R17.K6'
DECLARE @R17K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K7 OUT, 'R17.K7'
DECLARE @R17K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K8 OUT, 'R17.K8'
DECLARE @R17K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K9 OUT, 'R17.K9'
DECLARE @R17K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K10 OUT, 'R17.K10'
DECLARE @R17K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R17K11 OUT, 'R17.K11'
DECLARE @R18K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K1 OUT, 'R18.K1'
DECLARE @R18K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K2 OUT, 'R18.K2'
DECLARE @R18K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K3 OUT, 'R18.K3'
DECLARE @R18K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K4 OUT, 'R18.K4'
DECLARE @R18K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K5 OUT, 'R18.K5'
DECLARE @R18K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K6 OUT, 'R18.K6'
DECLARE @R18K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K7 OUT, 'R18.K7'
DECLARE @R18K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K8 OUT, 'R18.K8'
DECLARE @R18K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K9 OUT, 'R18.K9'
DECLARE @R18K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K10 OUT, 'R18.K10'
DECLARE @R18K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R18K11 OUT, 'R18.K11'
DECLARE @R19K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K1 OUT, 'R19.K1'
DECLARE @R19K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K2 OUT, 'R19.K2'
DECLARE @R19K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K3 OUT, 'R19.K3'
DECLARE @R19K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K4 OUT, 'R19.K4'
DECLARE @R19K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K5 OUT, 'R19.K5'
DECLARE @R19K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K6 OUT, 'R19.K6'
DECLARE @R19K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K7 OUT, 'R19.K7'
DECLARE @R19K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K8 OUT, 'R19.K8'
DECLARE @R19K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K9 OUT, 'R19.K9'
DECLARE @R19K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K10 OUT, 'R19.K10'
DECLARE @R19K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R19K11 OUT, 'R19.K11'
DECLARE @R20K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K1 OUT, 'R20.K1'
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 @R20K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K7 OUT, 'R20.K7'
DECLARE @R20K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K8 OUT, 'R20.K8'
DECLARE @R20K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K9 OUT, 'R20.K9'
DECLARE @R20K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K10 OUT, 'R20.K10'
DECLARE @R20K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R20K11 OUT, 'R20.K11'
DECLARE @R21K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K1 OUT, 'R21.K1'
DECLARE @R21K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K2 OUT, 'R21.K2'
DECLARE @R21K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K3 OUT, 'R21.K3'
DECLARE @R21K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K4 OUT, 'R21.K4'
DECLARE @R21K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K5 OUT, 'R21.K5'
DECLARE @R21K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K6 OUT, 'R21.K6'
DECLARE @R21K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K7 OUT, 'R21.K7'
DECLARE @R21K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K8 OUT, 'R21.K8'
DECLARE @R21K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K9 OUT, 'R21.K9'
DECLARE @R21K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K10 OUT, 'R21.K10'
DECLARE @R21K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R21K11 OUT, 'R21.K11'
DECLARE @R22K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K1 OUT, 'R22.K1'
DECLARE @R22K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K2 OUT, 'R22.K2'
DECLARE @R22K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K3 OUT, 'R22.K3'
DECLARE @R22K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K4 OUT, 'R22.K4'
DECLARE @R22K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K5 OUT, 'R22.K5'
DECLARE @R22K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K6 OUT, 'R22.K6'
DECLARE @R22K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K7 OUT, 'R22.K7'
DECLARE @R22K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K8 OUT, 'R22.K8'
DECLARE @R22K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K9 OUT, 'R22.K9'
DECLARE @R22K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K10 OUT, 'R22.K10'
DECLARE @R22K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R22K11 OUT, 'R22.K11'
DECLARE @R24K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K1 OUT, 'R24.K1'
DECLARE @R24K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K2 OUT, 'R24.K2'
DECLARE @R24K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K3 OUT, 'R24.K3'
DECLARE @R24K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K4 OUT, 'R24.K4'
DECLARE @R24K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K5 OUT, 'R24.K5'
DECLARE @R24K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K6 OUT, 'R24.K6'
DECLARE @R24K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K7 OUT, 'R24.K7'
DECLARE @R24K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K8 OUT, 'R24.K8'
DECLARE @R24K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K9 OUT, 'R24.K9'
DECLARE @R24K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K10 OUT, 'R24.K10'
DECLARE @R24K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R24K11 OUT, 'R24.K11'
DECLARE @R25K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K1 OUT, 'R25.K1'
DECLARE @R25K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K2 OUT, 'R25.K2'
DECLARE @R25K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K3 OUT, 'R25.K3'
DECLARE @R25K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K4 OUT, 'R25.K4'
DECLARE @R25K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K5 OUT, 'R25.K5'
DECLARE @R25K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K6 OUT, 'R25.K6'
DECLARE @R25K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K7 OUT, 'R25.K7'
DECLARE @R25K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K8 OUT, 'R25.K8'
DECLARE @R25K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K9 OUT, 'R25.K9'
DECLARE @R25K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K10 OUT, 'R25.K10'
DECLARE @R25K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R25K11 OUT, 'R25.K11'
DECLARE @R26K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K1 OUT, 'R26.K1'
DECLARE @R26K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K2 OUT, 'R26.K2'
DECLARE @R26K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K3 OUT, 'R26.K3'
DECLARE @R26K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K4 OUT, 'R26.K4'
DECLARE @R26K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K5 OUT, 'R26.K5'
DECLARE @R26K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K6 OUT, 'R26.K6'
DECLARE @R26K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K7 OUT, 'R26.K7'
DECLARE @R26K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K8 OUT, 'R26.K8'
DECLARE @R26K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K9 OUT, 'R26.K9'
DECLARE @R26K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K10 OUT, 'R26.K10'
DECLARE @R26K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R26K11 OUT, 'R26.K11'
DECLARE @R27K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K1 OUT, 'R27.K1'
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 @R27K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K7 OUT, 'R27.K7'
DECLARE @R27K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K8 OUT, 'R27.K8'
DECLARE @R27K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K9 OUT, 'R27.K9'
DECLARE @R27K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K10 OUT, 'R27.K10'
DECLARE @R27K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R27K11 OUT, 'R27.K11'
DECLARE @R28K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K1 OUT, 'R28.K1'
DECLARE @R28K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K2 OUT, 'R28.K2'
DECLARE @R28K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K3 OUT, 'R28.K3'
DECLARE @R28K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K4 OUT, 'R28.K4'
DECLARE @R28K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K5 OUT, 'R28.K5'
DECLARE @R28K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K6 OUT, 'R28.K6'
DECLARE @R28K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K7 OUT, 'R28.K7'
DECLARE @R28K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K8 OUT, 'R28.K8'
DECLARE @R28K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K9 OUT, 'R28.K9'
DECLARE @R28K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K10 OUT, 'R28.K10'
DECLARE @R28K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R28K11 OUT, 'R28.K11'
DECLARE @R29K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K1 OUT, 'R29.K1'
DECLARE @R29K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K2 OUT, 'R29.K2'
DECLARE @R29K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K3 OUT, 'R29.K3'
DECLARE @R29K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K4 OUT, 'R29.K4'
DECLARE @R29K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K5 OUT, 'R29.K5'
DECLARE @R29K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K6 OUT, 'R29.K6'
DECLARE @R29K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K7 OUT, 'R29.K7'
DECLARE @R29K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K8 OUT, 'R29.K8'
DECLARE @R29K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K9 OUT, 'R29.K9'
DECLARE @R29K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K10 OUT, 'R29.K10'
DECLARE @R29K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R29K11 OUT, 'R29.K11'
DECLARE @R30K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K1 OUT, 'R30.K1'
DECLARE @R30K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K2 OUT, 'R30.K2'
DECLARE @R30K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K3 OUT, 'R30.K3'
DECLARE @R30K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K4 OUT, 'R30.K4'
DECLARE @R30K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K5 OUT, 'R30.K5'
DECLARE @R30K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K6 OUT, 'R30.K6'
DECLARE @R30K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K7 OUT, 'R30.K7'
DECLARE @R30K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K8 OUT, 'R30.K8'
DECLARE @R30K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K9 OUT, 'R30.K9'
DECLARE @R30K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K10 OUT, 'R30.K10'
DECLARE @R30K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R30K11 OUT, 'R30.K11'
DECLARE @R32K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K1 OUT, 'R32.K1'
DECLARE @R32K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K2 OUT, 'R32.K2'
DECLARE @R32K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K3 OUT, 'R32.K3'
DECLARE @R32K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K4 OUT, 'R32.K4'
DECLARE @R32K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K5 OUT, 'R32.K5'
DECLARE @R32K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K6 OUT, 'R32.K6'
DECLARE @R32K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K7 OUT, 'R32.K7'
DECLARE @R32K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K8 OUT, 'R32.K8'
DECLARE @R32K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K9 OUT, 'R32.K9'
DECLARE @R32K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K10 OUT, 'R32.K10'
DECLARE @R32K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R32K11 OUT, 'R32.K11'
DECLARE @R33K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K1 OUT, 'R33.K1'
DECLARE @R33K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K2 OUT, 'R33.K2'
DECLARE @R33K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K3 OUT, 'R33.K3'
DECLARE @R33K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K4 OUT, 'R33.K4'
DECLARE @R33K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K5 OUT, 'R33.K5'
DECLARE @R33K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K6 OUT, 'R33.K6'
DECLARE @R33K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K7 OUT, 'R33.K7'
DECLARE @R33K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K8 OUT, 'R33.K8'
DECLARE @R33K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K9 OUT, 'R33.K9'
DECLARE @R33K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K10 OUT, 'R33.K10'
DECLARE @R33K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R33K11 OUT, 'R33.K11'
DECLARE @R34K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K1 OUT, 'R34.K1'
DECLARE @R34K2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K2 OUT, 'R34.K2'
DECLARE @R34K3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K3 OUT, 'R34.K3'
DECLARE @R34K4 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K4 OUT, 'R34.K4'
DECLARE @R34K5 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K5 OUT, 'R34.K5'
DECLARE @R34K6 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K6 OUT, 'R34.K6'
DECLARE @R34K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K7 OUT, 'R34.K7'
DECLARE @R34K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K8 OUT, 'R34.K8'
DECLARE @R34K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K9 OUT, 'R34.K9'
DECLARE @R34K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K10 OUT, 'R34.K10'
DECLARE @R34K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R34K11 OUT, 'R34.K11'
DECLARE @R36K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K1 OUT, 'R36.K1'
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 @R36K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K7 OUT, 'R36.K7'
DECLARE @R36K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K8 OUT, 'R36.K8'
DECLARE @R36K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K9 OUT, 'R36.K9'
DECLARE @R36K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K10 OUT, 'R36.K10'
DECLARE @R36K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R36K11 OUT, 'R36.K11'
DECLARE @R37K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K1 OUT, 'R37.K1'
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 @R37K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K7 OUT, 'R37.K7'
DECLARE @R37K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K8 OUT, 'R37.K8'
DECLARE @R37K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K9 OUT, 'R37.K9'
DECLARE @R37K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K10 OUT, 'R37.K10'
DECLARE @R37K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R37K11 OUT, 'R37.K11'
DECLARE @R38K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K1 OUT, 'R38.K1'
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 @R38K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K7 OUT, 'R38.K7'
DECLARE @R38K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K8 OUT, 'R38.K8'
DECLARE @R38K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K9 OUT, 'R38.K9'
DECLARE @R38K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K10 OUT, 'R38.K10'
DECLARE @R38K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R38K11 OUT, 'R38.K11'
DECLARE @R39K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K1 OUT, 'R39.K1'
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 @R39K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K7 OUT, 'R39.K7'
DECLARE @R39K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K8 OUT, 'R39.K8'
DECLARE @R39K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K9 OUT, 'R39.K9'
DECLARE @R39K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K10 OUT, 'R39.K10'
DECLARE @R39K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R39K11 OUT, 'R39.K11'
DECLARE @R40K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K1 OUT, 'R40.K1'
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 @R40K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K7 OUT, 'R40.K7'
DECLARE @R40K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K8 OUT, 'R40.K8'
DECLARE @R40K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K9 OUT, 'R40.K9'
DECLARE @R40K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K10 OUT, 'R40.K10'
DECLARE @R40K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R40K11 OUT, 'R40.K11'
DECLARE @R41K1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K1 OUT, 'R41.K1'
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 @R41K7 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K7 OUT, 'R41.K7'
DECLARE @R41K8 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K8 OUT, 'R41.K8'
DECLARE @R41K9 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K9 OUT, 'R41.K9'
DECLARE @R41K10 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K10 OUT, 'R41.K10'
DECLARE @R41K11 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @R41K11 OUT, 'R41.K11'
DECLARE @Value nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Pielikumi.PielikumsRindai18.Fails.value'
DECLARE @KomentarsValue nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai18.Komentars.value'
DECLARE @FailsValue nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai19.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai19.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai20.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai20.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai21.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai21.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai22.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai22.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai37.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai37.Komentars.value'
EXEC sp_OAMethod @jResp, 'StringOf', @FailsValue OUT, 'Pielikumi.PielikumsRindai40.Fails.value'
EXEC sp_OAMethod @jResp, 'StringOf', @KomentarsValue OUT, 'Pielikumi.PielikumsRindai40.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, 'Pielikumi.CitiDokumenti'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'Pielikumi.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/anav4/:id
Postman Collection Item JSON
{
"name": "Dokuments \"Alkoholisko dzērienu akcīzes nodokļa deklarācija\".",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/doc/anav4/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"anav4",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/anav4/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"anav4",
":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\": \"est enim pariatur deserunt culpa\",\n \"Talrunis\": \"ad paria\",\n \"Gads\": 31478571,\n \"Menesis\": 1,\n \"Datums\": \"2000-01-31T00:00:00\",\n \"Statuss\": \"ex velit\",\n \"R09\": \"eu ad\",\n \"R10\": \"do Duis adipisicing eu elit\",\n \"Sagatavotajs\": \"eiusmod cillum\",\n \"SamTermins\": \"2000-01-31T00:00:00\",\n \"R11\": {\n \"K1\": -75134466.33476177,\n \"K2\": -48699298.3409114,\n \"K3\": -99413150.3417543,\n \"K4\": -83797417.80346124,\n \"K5\": 28288547.42313686,\n \"K6\": -22711058.977118492,\n \"K7\": -96102912.59660086,\n \"K8\": 4942839.422306016,\n \"K9\": -26461448.129657894,\n \"K10\": 71480797.22039315,\n \"K11\": -24708223.086522803\n },\n \"R12\": {\n \"K1\": 28120889.077360317,\n \"K2\": 81997550.1489962,\n \"K3\": 9609233.737401724,\n \"K4\": -64718031.47915711,\n \"K5\": -23025640.832763463,\n \"K6\": -1126966.4816737622,\n \"K7\": -84267430.25742783,\n \"K8\": 9681010.73999405,\n \"K9\": 42997776.21043238,\n \"K10\": -96749200.78967935,\n \"K11\": 70373006.00781378\n },\n \"R13\": {\n \"K1\": -86449306.58052914,\n \"K2\": 51824940.05330777,\n \"K3\": -74881590.69828098,\n \"K4\": 11313283.640554816,\n \"K5\": 73477414.13531795,\n \"K6\": 48080324.00782171,\n \"K7\": -81208901.32493557,\n \"K8\": 50433274.407880604,\n \"K9\": 83485383.1475285,\n \"K10\": 16668743.002714545,\n \"K11\": 9836444.772695035\n },\n \"R14\": {\n \"K1\": 57118881.02458906,\n \"K2\": 79383003.06469691,\n \"K3\": -89758030.0769056,\n \"K4\": -61736046.07100072,\n \"K5\": 23017023.721902728,\n \"K6\": 6718577.627643317,\n \"K7\": -57338279.37538596,\n \"K8\": -16615799.931319281,\n \"K9\": 56966279.19264859,\n \"K10\": -27322626.639141887,\n \"K11\": 44575223.26244584\n },\n \"R15\": {\n \"K1\": 78093082.2168409,\n \"K2\": 51440893.46983755,\n \"K3\": -2922853.364090547,\n \"K4\": -26492019.24007167,\n \"K5\": -41793363.915394455,\n \"K6\": 47294848.519970536,\n \"K7\": 62323410.96574205,\n \"K8\": -44115767.63375371,\n \"K9\": -27485290.10509588,\n \"K10\": 8894933.629735082,\n \"K11\": 13036182.663037851\n },\n \"R16\": {\n \"K1\": 23205848.268277228,\n \"K2\": -85436802.97384508,\n \"K3\": -38791307.51897493,\n \"K4\": -51789609.51507707,\n \"K5\": 36804389.740775436,\n \"K6\": 82937448.4137449,\n \"K7\": -85359352.69194126,\n \"K8\": 5688247.845175847,\n \"K9\": 22135687.707852364,\n \"K10\": 70730228.67338988,\n \"K11\": 9713027.399367258\n },\n \"R17\": {\n \"K1\": 73469154.03595454,\n \"K2\": -25777278.342222363,\n \"K3\": 94631531.40675619,\n \"K4\": -58187733.2635214,\n \"K5\": 45918741.7641986,\n \"K6\": -13651127.962059379,\n \"K7\": -90928180.31327638,\n \"K8\": -97489863.92535937,\n \"K9\": 62078296.06969395,\n \"K10\": 78336141.83939478,\n \"K11\": -90528507.48485945\n },\n \"R18\": {\n \"K1\": -5243205.639127746,\n \"K2\": -44992745.268658265,\n \"K3\": 27469212.084040955,\n \"K4\": 2941478.7965110093,\n \"K5\": 82611703.01163715,\n \"K6\": -84447221.65674761,\n \"K7\": 15883061.808513284,\n \"K8\": 38745584.739284724,\n \"K9\": -35394917.17324661,\n \"K10\": 5179832.802335143,\n \"K11\": -27895300.239142567\n },\n \"R19\": {\n \"K1\": -76654909.25083923,\n \"K2\": -84291476.46052751,\n \"K3\": 24912878.74828933,\n \"K4\": 88846738.96892026,\n \"K5\": -48804069.191867016,\n \"K6\": 23762640.644861624,\n \"K7\": -96678535.12866524,\n \"K8\": -78796766.80043142,\n \"K9\": -46029646.71542966,\n \"K10\": 90377340.98000577,\n \"K11\": -66032488.22707224\n },\n \"R20\": {\n \"K1\": 3813220.5633409023,\n \"K2\": -75333315.58757487,\n \"K3\": -81271204.60130826,\n \"K4\": -19424929.180203736,\n \"K5\": -46084342.55965781,\n \"K6\": 80542382.74884117,\n \"K7\": -76697022.753561,\n \"K8\": 91189214.26495796,\n \"K9\": 74509672.4875839,\n \"K10\": -67519542.22286773,\n \"K11\": 63609260.98256791\n },\n \"R21\": {\n \"K1\": -67485419.35181591,\n \"K2\": 59182237.15205687,\n \"K3\": -42864712.90786809,\n \"K4\": 89855511.76301253,\n \"K5\": 8784579.926392138,\n \"K6\": -11107298.829912841,\n \"K7\": -71482933.24300243,\n \"K8\": 50161004.21751064,\n \"K9\": 47256722.74296865,\n \"K10\": 35068511.14367682,\n \"K11\": 97140216.9313682\n },\n \"R22\": {\n \"K1\": 51611089.73318097,\n \"K2\": 18530633.066504225,\n \"K3\": 77758900.1615347,\n \"K4\": -13680258.270694032,\n \"K5\": -52031377.69422348,\n \"K6\": 88628056.79937878,\n \"K7\": 78358616.24079949,\n \"K8\": -82664839.81997612,\n \"K9\": -16917501.453631848,\n \"K10\": -4080294.389188975,\n \"K11\": -5085004.738127679\n },\n \"R24\": {\n \"K1\": 30353571.889823347,\n \"K2\": 81662305.44511649,\n \"K3\": -26750365.96183458,\n \"K4\": -97242914.9240976,\n \"K5\": 88662566.52571255,\n \"K6\": 8197201.516497105,\n \"K7\": 89329155.81638014,\n \"K8\": 24599136.53307493,\n \"K9\": 23688695.184291884,\n \"K10\": -75832800.81577733,\n \"K11\": -88099985.45339087\n },\n \"R25\": {\n \"K1\": -81063512.97571033,\n \"K2\": -974978.6831183583,\n \"K3\": 87076202.33061698,\n \"K4\": -26942514.30015719,\n \"K5\": -51557980.349297635,\n \"K6\": 38007916.078596264,\n \"K7\": -32566799.116636112,\n \"K8\": -40944594.13948641,\n \"K9\": -2073022.9192552418,\n \"K10\": 10262325.06134677,\n \"K11\": 61183835.85953021\n },\n \"R26\": {\n \"K1\": 79220240.24234876,\n \"K2\": -18523513.85371986,\n \"K3\": -792647.3084940463,\n \"K4\": 79478256.95248395,\n \"K5\": -90531699.87374501,\n \"K6\": -5898387.922647521,\n \"K7\": 82610773.62906301,\n \"K8\": 37744764.49042261,\n \"K9\": 35916078.96586746,\n \"K10\": 38238932.07087457,\n \"K11\": -68753131.43338704\n },\n \"R27\": {\n \"K1\": -69339849.91716105,\n \"K2\": 65361271.97400886,\n \"K3\": 52263946.74765307,\n \"K4\": 80117406.95577565,\n \"K5\": -78272376.1656011,\n \"K6\": 80396538.92308447,\n \"K7\": -70969768.7791527,\n \"K8\": -22467075.121106014,\n \"K9\": -83958093.9249363,\n \"K10\": -83762346.09689175,\n \"K11\": -60450925.01919953\n },\n \"R28\": {\n \"K1\": 82192876.65358993,\n \"K2\": -88366676.2700917,\n \"K3\": -25131270.974725425,\n \"K4\": 81848041.7233392,\n \"K5\": 63651373.10281232,\n \"K6\": 97717765.50277749,\n \"K7\": -20350264.16622418,\n \"K8\": 55467962.90263814,\n \"K9\": -48377038.896852255,\n \"K10\": 39530478.19681737,\n \"K11\": -8736509.751999617\n },\n \"R29\": {\n \"K1\": 1329546.4833407104,\n \"K2\": -36428883.587767705,\n \"K3\": 44381289.64497295,\n \"K4\": 17367426.550662562,\n \"K5\": -46067505.91279427,\n \"K6\": -27602197.628391683,\n \"K7\": -91076807.60094298,\n \"K8\": -25404085.85834025,\n \"K9\": -7307814.28149569,\n \"K10\": -18085908.810195312,\n \"K11\": -94758381.66935055\n },\n \"R30\": {\n \"K1\": -17228220.54108998,\n \"K2\": 82493255.9559797,\n \"K3\": 65624194.775191605,\n \"K4\": 59715467.76626924,\n \"K5\": -91262576.58340618,\n \"K6\": -67902848.77319577,\n \"K7\": 11839832.907837257,\n \"K8\": -9324648.076048091,\n \"K9\": -45725377.365549356,\n \"K10\": 85622472.44880953,\n \"K11\": -75041540.89969379\n },\n \"R32\": {\n \"K1\": 18191759.860879213,\n \"K2\": 72892478.54482341,\n \"K3\": -79952321.7926965,\n \"K4\": -26872529.70128022,\n \"K5\": -36315913.253182374,\n \"K6\": -19314942.251303345,\n \"K7\": -36562920.96460767,\n \"K8\": -83005587.23185527,\n \"K9\": 68808822.38204813,\n \"K10\": 72011356.8115209,\n \"K11\": 30073286.827217907\n },\n \"R33\": {\n \"K1\": -14835858.73258084,\n \"K2\": 9804775.715329587,\n \"K3\": -56377072.15039449,\n \"K4\": 20248372.602051973,\n \"K5\": -17107749.42720841,\n \"K6\": 12182595.031442747,\n \"K7\": 10350040.97562702,\n \"K8\": 77334501.59528625,\n \"K9\": -63141456.213893935,\n \"K10\": 5943805.486367688,\n \"K11\": 76202159.89486194\n },\n \"R34\": {\n \"K1\": -71077121.7601804,\n \"K2\": -25607390.85821879,\n \"K3\": 63164594.50739518,\n \"K4\": 95149513.24353734,\n \"K5\": 8148177.130351365,\n \"K6\": 98384134.27733582,\n \"K7\": 13483683.205103472,\n \"K8\": 552331.8556017727,\n \"K9\": 83004805.1109423,\n \"K10\": -940385.4543728083,\n \"K11\": 13477608.342944965\n },\n \"R36\": {\n \"K1\": 99894890.53865567,\n \"K2\": 15321458.483672813,\n \"K3\": 46649100.38260701,\n \"K4\": 92755760.68062004,\n \"K5\": -57599717.14221859,\n \"K6\": -71853434.37764624,\n \"K7\": 25776944.369388714,\n \"K8\": 41620820.185993254,\n \"K9\": -53286044.09712141,\n \"K10\": -47983292.444122046,\n \"K11\": -12433275.961624444\n },\n \"R37\": {\n \"K1\": 35420483.24655411,\n \"K2\": -21070326.678702235,\n \"K3\": -6616023.071576834,\n \"K4\": 14520195.492538556,\n \"K5\": -97476792.29387778,\n \"K6\": 30216700.588341534,\n \"K7\": 34421637.114123195,\n \"K8\": -23359235.054106712,\n \"K9\": -70397146.29079673,\n \"K10\": -48736531.254686266,\n \"K11\": 45438977.585956186\n },\n \"R38\": {\n \"K1\": 1990165.0967748612,\n \"K2\": 71097169.82269916,\n \"K3\": -71556579.10749543,\n \"K4\": -54881374.982076816,\n \"K5\": -95119650.54293019,\n \"K6\": -91858720.2102187,\n \"K7\": -33936258.58035971,\n \"K8\": 63999412.45529953,\n \"K9\": 69908195.97680008,\n \"K10\": 10211757.634596229,\n \"K11\": -74412018.98690775\n },\n \"R39\": {\n \"K1\": -52891754.88971054,\n \"K2\": 70189272.17991248,\n \"K3\": -27400905.146460548,\n \"K4\": 86626425.88846663,\n \"K5\": 19002254.956758246,\n \"K6\": -90528263.15229324,\n \"K7\": 87381182.28088698,\n \"K8\": -76699006.77147949,\n \"K9\": 96738554.32291925,\n \"K10\": 40786294.43217343,\n \"K11\": -34816268.67534917\n },\n \"R40\": {\n \"K1\": 83837091.79189956,\n \"K2\": -87915556.58802816,\n \"K3\": 24417466.012435704,\n \"K4\": -43880915.25518525,\n \"K5\": -69034679.89739527,\n \"K6\": -6685306.312743038,\n \"K7\": -16981358.691801682,\n \"K8\": 91910374.27698961,\n \"K9\": 34669912.62813935,\n \"K10\": -16728893.337160721,\n \"K11\": 22398893.986314267\n },\n \"R41\": {\n \"K1\": 98897696.46753588,\n \"K2\": 99919824.97218785,\n \"K3\": 11283166.054576471,\n \"K4\": 81304598.9077251,\n \"K5\": -53584524.608154014,\n \"K6\": 97968581.58158943,\n \"K7\": 96314560.32973632,\n \"K8\": -19532400.235378593,\n \"K9\": 12737966.89336364,\n \"K10\": 12925298.53924194,\n \"K11\": -13628181.880051568\n },\n \"Pielikumi\": {\n \"PielikumsRindai18\": {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"PielikumsRindai19\": {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"PielikumsRindai20\": {\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 \"PielikumsRindai21\": {\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 \"PielikumsRindai22\": {\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 \"PielikumsRindai37\": {\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 \"PielikumsRindai40\": {\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\": -1819993,\n \"UID\": \"aliqua dolore in consectetur\",\n \"NmrKods\": \"si\",\n \"Precizejums\": false,\n \"PrecizejamaisDokuments\": -2972997,\n \"PrecizejumaPamatojums\": \"enim proident Excepteur in\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/anav4/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"anav4",
":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/anav4/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"anav4",
":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/anav4/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"anav4",
":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": ""
}
]
}
