Powershell / EDS API / Dokuments "Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai".
Back to Collection Items
Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"
# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
$http = New-Object Chilkat.Http
$http.SetRequestHeader("Accept","application/json")
$sbResponseBody = New-Object Chilkat.StringBuilder
$success = $http.QuickGetSb("https://eds.vid.gov.lv/api/doc/tnav2/:id",$sbResponseBody)
if ($success -eq $false) {
$($http.LastErrorText)
exit
}
$jResp = New-Object Chilkat.JsonObject
$jResp.LoadSb($sbResponseBody)
$jResp.EmitCompact = $false
$("Response Body:")
$($jResp.Emit())
$respStatusCode = $http.LastStatus
$("Response Status Code = " + $respStatusCode)
if ($respStatusCode -ge 400) {
$("Response Header:")
$($http.LastHeader)
$("Failed.")
exit
}
# Sample JSON response:
# (Sample code for parsing the JSON response is shown below)
# {
# "TaksNo": "2000-01-31T00:00:00",
# "TaksLidz": "2000-01-31T00:00:00",
# "Epasts": "sed",
# "Talrunis": "Duis u",
# "Sagatavotajs": "culpa",
# "R021": 20315906.116601974,
# "R022": -61851466.616407834,
# "R023": -3784754.811457798,
# "R027Proc": -43191991.81540565,
# "R027": 81749181.92572099,
# "R028": 89221232.42839152,
# "R029Proc": 87194117.8460764,
# "R029": -2589640.38362439,
# "R031": 60624455.21640742,
# "R032": 63693008.897661984,
# "R041": 55072033.556542635,
# "R042": -74719243.59231457,
# "R043": -49153745.67511059,
# "R044": 77388360.48374161,
# "R045": 93163563.6837829,
# "R046": -11213941.923736036,
# "R047": 40192475.45927173,
# "R048Text": "quis in",
# "R048": -85044547.56044617,
# "R05": -20502042.2216855,
# "R06": 18732287.88817753,
# "R07": 44739889.77206805,
# "R081": 96001089.93872571,
# "R082": -76951175.44924127,
# "R083": 2955251.3419849128,
# "R09_Tabula": [
# {
# "IeguldSumma": 86276282.75377223,
# "Kods": "officia nostrud cillum labore"
# },
# {
# "IeguldSumma": 28942915.74151948,
# "Kods": "aliqua"
# }
# ],
# "R10_Tabula": [
# {
# "IeguldSumma": -31721504.967451915,
# "Kods": "esse culpa "
# },
# {
# "IeguldSumma": -58642566.252877384,
# "Kods": "dolore aliqua quis"
# }
# ],
# "R11_Tabula": [
# {
# "IeguldSumma": 81499190.51709351,
# "Kods": "dolor aliquip occaecat do ea"
# },
# {
# "IeguldSumma": 76755454.40086395,
# "Kods": "nostrud"
# }
# ],
# "R12_Tabula": [
# {
# "NINA": 79796877.36835039,
# "UINA": 30331571.006744444,
# "Kods": "irure in et ex",
# "IeguldSumma": 54630688.33858213
# },
# {
# "NINA": -6240697.226656616,
# "UINA": 23590322.479562834,
# "Kods": "consequat do ut",
# "IeguldSumma": 63786168.45582652
# }
# ],
# "R13_Tabula": [
# {
# "IeguldSumma": 30523200.60888873,
# "Kods": "pariatur occaecat nostrud eu"
# },
# {
# "IeguldSumma": -86174886.3759622,
# "Kods": "Lorem sunt"
# }
# ],
# "Ieguldijumi1": [
# {
# "Kods": "adipisicing deserunt nisi",
# "IeguldNos": "sit nulla irure nisi",
# "IeguldSumma": 24879133.12293549
# },
# {
# "Kods": "tempor in voluptate",
# "IeguldNos": "in incididunt Excepteur",
# "IeguldSumma": -46005550.41745236
# }
# ],
# "Ieguldijumi2": [
# {
# "Kods": "cupidatat Lorem consectetur",
# "IeguldNos": "Duis",
# "AtlProcents": 80216092,
# "IeguldSumma": 74086661.08514467
# },
# {
# "Kods": "ipsum anim amet",
# "IeguldNos": "in fugiat voluptate et eu",
# "AtlProcents": 44814656,
# "IeguldSumma": -63030813.24776003
# }
# ],
# "Pielikumi": [
# {
# "Fails": {
# "value": "<Error: Too many levels of nesting to fake this schema>"
# },
# "Komentars": "reprehenderit culpa qui sed"
# },
# {
# "Fails": {
# "value": "<Error: Too many levels of nesting to fake this schema>"
# },
# "Komentars": "sunt proident"
# }
# ],
# "Id": -54089874,
# "UID": "aliquip culpa",
# "NmrKods": "nisi ",
# "Precizejums": true,
# "PrecizejamaisDokuments": -6713016,
# "PrecizejumaPamatojums": "anim ex"
# }
# Sample code for parsing the JSON response...
# Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
$TaksNo = $jResp.StringOf("TaksNo")
$TaksLidz = $jResp.StringOf("TaksLidz")
$Epasts = $jResp.StringOf("Epasts")
$Talrunis = $jResp.StringOf("Talrunis")
$Sagatavotajs = $jResp.StringOf("Sagatavotajs")
$R021 = $jResp.StringOf("R021")
$R022 = $jResp.StringOf("R022")
$R023 = $jResp.StringOf("R023")
$R027Proc = $jResp.StringOf("R027Proc")
$R027 = $jResp.StringOf("R027")
$R028 = $jResp.StringOf("R028")
$R029Proc = $jResp.StringOf("R029Proc")
$R029 = $jResp.StringOf("R029")
$R031 = $jResp.StringOf("R031")
$R032 = $jResp.StringOf("R032")
$R041 = $jResp.StringOf("R041")
$R042 = $jResp.StringOf("R042")
$R043 = $jResp.StringOf("R043")
$R044 = $jResp.StringOf("R044")
$R045 = $jResp.StringOf("R045")
$R046 = $jResp.StringOf("R046")
$R047 = $jResp.StringOf("R047")
$R048Text = $jResp.StringOf("R048Text")
$R048 = $jResp.StringOf("R048")
$R05 = $jResp.StringOf("R05")
$R06 = $jResp.StringOf("R06")
$R07 = $jResp.StringOf("R07")
$R081 = $jResp.StringOf("R081")
$R082 = $jResp.StringOf("R082")
$R083 = $jResp.StringOf("R083")
$Id = $jResp.IntOf("Id")
$UID = $jResp.StringOf("UID")
$NmrKods = $jResp.StringOf("NmrKods")
$Precizejums = $jResp.BoolOf("Precizejums")
$PrecizejamaisDokuments = $jResp.IntOf("PrecizejamaisDokuments")
$PrecizejumaPamatojums = $jResp.StringOf("PrecizejumaPamatojums")
$i = 0
$count_i = $jResp.SizeOfArray("R09_Tabula")
while ($i -lt $count_i) {
$jResp.I = $i
$IeguldSumma = $jResp.StringOf("R09_Tabula[i].IeguldSumma")
$Kods = $jResp.StringOf("R09_Tabula[i].Kods")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("R10_Tabula")
while ($i -lt $count_i) {
$jResp.I = $i
$IeguldSumma = $jResp.StringOf("R10_Tabula[i].IeguldSumma")
$Kods = $jResp.StringOf("R10_Tabula[i].Kods")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("R11_Tabula")
while ($i -lt $count_i) {
$jResp.I = $i
$IeguldSumma = $jResp.StringOf("R11_Tabula[i].IeguldSumma")
$Kods = $jResp.StringOf("R11_Tabula[i].Kods")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("R12_Tabula")
while ($i -lt $count_i) {
$jResp.I = $i
$NINA = $jResp.StringOf("R12_Tabula[i].NINA")
$UINA = $jResp.StringOf("R12_Tabula[i].UINA")
$Kods = $jResp.StringOf("R12_Tabula[i].Kods")
$IeguldSumma = $jResp.StringOf("R12_Tabula[i].IeguldSumma")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("R13_Tabula")
while ($i -lt $count_i) {
$jResp.I = $i
$IeguldSumma = $jResp.StringOf("R13_Tabula[i].IeguldSumma")
$Kods = $jResp.StringOf("R13_Tabula[i].Kods")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("Ieguldijumi1")
while ($i -lt $count_i) {
$jResp.I = $i
$Kods = $jResp.StringOf("Ieguldijumi1[i].Kods")
$IeguldNos = $jResp.StringOf("Ieguldijumi1[i].IeguldNos")
$IeguldSumma = $jResp.StringOf("Ieguldijumi1[i].IeguldSumma")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("Ieguldijumi2")
while ($i -lt $count_i) {
$jResp.I = $i
$Kods = $jResp.StringOf("Ieguldijumi2[i].Kods")
$IeguldNos = $jResp.StringOf("Ieguldijumi2[i].IeguldNos")
$AtlProcents = $jResp.IntOf("Ieguldijumi2[i].AtlProcents")
$IeguldSumma = $jResp.StringOf("Ieguldijumi2[i].IeguldSumma")
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("Pielikumi")
while ($i -lt $count_i) {
$jResp.I = $i
$Value = $jResp.StringOf("Pielikumi[i].Fails.value")
$Komentars = $jResp.StringOf("Pielikumi[i].Komentars")
$i = $i + 1
}
Curl Command
curl -X GET
-H "Accept: application/json"
https://eds.vid.gov.lv/api/doc/tnav2/:id
Postman Collection Item JSON
{
"name": "Dokuments \"Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai\".",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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 \"TaksNo\": \"2000-01-31T00:00:00\",\n \"TaksLidz\": \"2000-01-31T00:00:00\",\n \"Epasts\": \"sed\",\n \"Talrunis\": \"Duis u\",\n \"Sagatavotajs\": \"culpa\",\n \"R021\": 20315906.116601974,\n \"R022\": -61851466.616407834,\n \"R023\": -3784754.811457798,\n \"R027Proc\": -43191991.81540565,\n \"R027\": 81749181.92572099,\n \"R028\": 89221232.42839152,\n \"R029Proc\": 87194117.8460764,\n \"R029\": -2589640.38362439,\n \"R031\": 60624455.21640742,\n \"R032\": 63693008.897661984,\n \"R041\": 55072033.556542635,\n \"R042\": -74719243.59231457,\n \"R043\": -49153745.67511059,\n \"R044\": 77388360.48374161,\n \"R045\": 93163563.6837829,\n \"R046\": -11213941.923736036,\n \"R047\": 40192475.45927173,\n \"R048Text\": \"quis in\",\n \"R048\": -85044547.56044617,\n \"R05\": -20502042.2216855,\n \"R06\": 18732287.88817753,\n \"R07\": 44739889.77206805,\n \"R081\": 96001089.93872571,\n \"R082\": -76951175.44924127,\n \"R083\": 2955251.3419849128,\n \"R09_Tabula\": [\n {\n \"IeguldSumma\": 86276282.75377223,\n \"Kods\": \"officia nostrud cillum labore\"\n },\n {\n \"IeguldSumma\": 28942915.74151948,\n \"Kods\": \"aliqua\"\n }\n ],\n \"R10_Tabula\": [\n {\n \"IeguldSumma\": -31721504.967451915,\n \"Kods\": \"esse culpa \"\n },\n {\n \"IeguldSumma\": -58642566.252877384,\n \"Kods\": \"dolore aliqua quis\"\n }\n ],\n \"R11_Tabula\": [\n {\n \"IeguldSumma\": 81499190.51709351,\n \"Kods\": \"dolor aliquip occaecat do ea\"\n },\n {\n \"IeguldSumma\": 76755454.40086395,\n \"Kods\": \"nostrud\"\n }\n ],\n \"R12_Tabula\": [\n {\n \"NINA\": 79796877.36835039,\n \"UINA\": 30331571.006744444,\n \"Kods\": \"irure in et ex\",\n \"IeguldSumma\": 54630688.33858213\n },\n {\n \"NINA\": -6240697.226656616,\n \"UINA\": 23590322.479562834,\n \"Kods\": \"consequat do ut\",\n \"IeguldSumma\": 63786168.45582652\n }\n ],\n \"R13_Tabula\": [\n {\n \"IeguldSumma\": 30523200.60888873,\n \"Kods\": \"pariatur occaecat nostrud eu\"\n },\n {\n \"IeguldSumma\": -86174886.3759622,\n \"Kods\": \"Lorem sunt\"\n }\n ],\n \"Ieguldijumi1\": [\n {\n \"Kods\": \"adipisicing deserunt nisi\",\n \"IeguldNos\": \"sit nulla irure nisi\",\n \"IeguldSumma\": 24879133.12293549\n },\n {\n \"Kods\": \"tempor in voluptate\",\n \"IeguldNos\": \"in incididunt Excepteur\",\n \"IeguldSumma\": -46005550.41745236\n }\n ],\n \"Ieguldijumi2\": [\n {\n \"Kods\": \"cupidatat Lorem consectetur\",\n \"IeguldNos\": \"Duis\",\n \"AtlProcents\": 80216092,\n \"IeguldSumma\": 74086661.08514467\n },\n {\n \"Kods\": \"ipsum anim amet\",\n \"IeguldNos\": \"in fugiat voluptate et eu\",\n \"AtlProcents\": 44814656,\n \"IeguldSumma\": -63030813.24776003\n }\n ],\n \"Pielikumi\": [\n {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": \"reprehenderit culpa qui sed\"\n },\n {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": \"sunt proident\"\n }\n ],\n \"Id\": -54089874,\n \"UID\": \"aliquip culpa\",\n \"NmrKods\": \"nisi \",\n \"Precizejums\": true,\n \"PrecizejamaisDokuments\": -6713016,\n \"PrecizejumaPamatojums\": \"anim ex\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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": ""
}
]
}
