SQL Server / EDS API / Izveidot dokumentu "Informācija par izmaksātajām mācību maksas kompensācijām".
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
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @req int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.HttpRequest', @req OUT
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Epasts', 'culpa est eu'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Talrunis', 'ipsum ei'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Sagatavotajs', 'id labore'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'TaksGads', '-69406522'
DECLARE @jsonParam5 int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jsonParam5 OUT
EXEC sp_OAMethod @jsonParam5, 'UpdateString', @success OUT, 'PersonasKods', 'i'
EXEC sp_OAMethod @jsonParam5, 'UpdateString', @success OUT, 'VardsUzvards', 'incididunt veniam amet dolor sunt'
EXEC sp_OAMethod @jsonParam5, 'UpdateNumber', @success OUT, 'IzmaksataSumma', '12131622.977891028'
EXEC sp_OAMethod @jsonParam5, 'UpdateString', @success OUT, 'IzmaksasDatums', '2000-01-31T00:00:00'
EXEC sp_OAMethod @jsonParam5, 'UpdateString', @success OUT, 'KalendaraGads', 'aliquip esse'
EXEC sp_OAMethod @jsonParam5, 'Emit', @sTmp0 OUT
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Tabula', @sTmp0
DECLARE @jsonParam6 int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jsonParam6 OUT
EXEC sp_OAMethod @jsonParam6, 'UpdateString', @success OUT, 'PersonasKods', 'veni'
EXEC sp_OAMethod @jsonParam6, 'UpdateString', @success OUT, 'VardsUzvards', 'ea occaecat'
EXEC sp_OAMethod @jsonParam6, 'UpdateNumber', @success OUT, 'IzmaksataSumma', '62345567.95502934'
EXEC sp_OAMethod @jsonParam6, 'UpdateString', @success OUT, 'IzmaksasDatums', '2000-01-31T00:00:00'
EXEC sp_OAMethod @jsonParam6, 'UpdateString', @success OUT, 'KalendaraGads', 'non nulla Lorem tempor ea'
EXEC sp_OAMethod @jsonParam6, 'Emit', @sTmp0 OUT
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Tabula', @sTmp0
EXEC sp_OAMethod @req, 'AddParam', NULL, 'NmrKods', 'sunt e'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'Precizejums', 'true'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'PrecizejamaisDokuments', '96224726'
EXEC sp_OAMethod @req, 'AddParam', NULL, 'PrecizejumaPamatojums', 'ullamco'
EXEC sp_OAMethod @req, 'AddHeader', NULL, 'Accept', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostUrlEncoded', @resp OUT, 'https://eds.vid.gov.lv/api/doc/mmkv1', @req
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @jsonParam5
EXEC @hr = sp_OADestroy @jsonParam6
RETURN
END
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @jsonParam5
EXEC @hr = sp_OADestroy @jsonParam6
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @jsonParam5
EXEC @hr = sp_OADestroy @jsonParam6
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -X POST
-H "Content-Type: application/x-www-form-urlencoded"
-H "Accept: application/json"
--data-urlencode 'Epasts=culpa est eu'
--data-urlencode 'Talrunis=ipsum ei'
--data-urlencode 'Sagatavotajs=id labore'
--data-urlencode 'TaksGads=-69406522'
--data-urlencode 'Tabula={"PersonasKods":"i","VardsUzvards":"incididunt veniam amet dolor sunt","IzmaksataSumma":12131622.977891028,"IzmaksasDatums":"2000-01-31T00:00:00","KalendaraGads":"aliquip esse"}'
--data-urlencode 'Tabula={"PersonasKods":"veni","VardsUzvards":"ea occaecat","IzmaksataSumma":62345567.95502934,"IzmaksasDatums":"2000-01-31T00:00:00","KalendaraGads":"non nulla Lorem tempor ea"}'
--data-urlencode 'NmrKods=sunt e'
--data-urlencode 'Precizejums=true'
--data-urlencode 'PrecizejamaisDokuments=96224726'
--data-urlencode 'PrecizejumaPamatojums=ullamco'
https://eds.vid.gov.lv/api/doc/mmkv1
Postman Collection Item JSON
{
"name": "Izveidot dokumentu \"Informācija par izmaksātajām mācību maksas kompensācijām\".",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/x-www-form-urlencoded"
},
{
"key": "Accept",
"value": "application/json"
}
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "culpa est eu",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "ipsum ei",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "id labore",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "-69406522",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"i\",\"VardsUzvards\":\"incididunt veniam amet dolor sunt\",\"IzmaksataSumma\":12131622.977891028,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"aliquip esse\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"veni\",\"VardsUzvards\":\"ea occaecat\",\"IzmaksataSumma\":62345567.95502934,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"non nulla Lorem tempor ea\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "sunt e",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "96224726",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "ullamco",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Created",
"code": 201,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "-12855709"
},
{
"name": "Pieprasījuma dati ir kļūdaini.",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Lietotājam nav tiesību veikt šo darbību.",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Forbidden",
"code": 403,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Dokumenta unikalitātes ierobežojums. Dokuments par norādīto periodu jau izveidots. Lai izveidotu atkārtoti, izmantojiet jaunu drošības talonu.",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Conflict",
"code": 409,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Pārsniegts izsaukumu skaita ierobežojums.",
"originalRequest": {
"method": "POST",
"header": [
],
"body": {
"mode": "urlencoded",
"urlencoded": [
{
"key": "Epasts",
"value": "fugiat eu mollit",
"description": "(Required) Epasta adrese."
},
{
"key": "Talrunis",
"value": "elit",
"description": "(Required) Iesniedzēja tālrunis."
},
{
"key": "Sagatavotajs",
"value": "mollit tempor labore laboris ullamco",
"description": "(Required) Sagatavotāja vārds, uzvārds."
},
{
"key": "TaksGads",
"value": "47093049",
"description": "(Required) Taksācijas gads."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"aliquip\",\"VardsUzvards\":\"voluptate\",\"IzmaksataSumma\":-12139701.987933502,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"mollit commodo occaecat\"}",
"description": "Tabula."
},
{
"key": "Tabula",
"value": "{\"PersonasKods\":\"id aliqu\",\"VardsUzvards\":\"fugiat est in dolor\",\"IzmaksataSumma\":-87261623.4254953,\"IzmaksasDatums\":\"2000-01-31T00:00:00\",\"KalendaraGads\":\"dolor minim\"}",
"description": "Tabula."
},
{
"key": "NmrKods",
"value": "consequat ",
"description": "Nodokļu maksātāja kods."
},
{
"key": "Precizejums",
"value": "true",
"description": "Vai dokuments ir precizējums."
},
{
"key": "PrecizejamaisDokuments",
"value": "19626243",
"description": "Precizējamā dokumenta numurs."
},
{
"key": "PrecizejumaPamatojums",
"value": "qui mollit",
"description": "Precizējuma pamatojums."
}
]
},
"url": {
"raw": "{{baseUrl}}/api/doc/mmkv1",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"mmkv1"
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
}
]
}
