Foxpro / EDS API / Dokuments "Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai".
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcIeguldSumma
LOCAL lcKods
LOCAL lcNINA
LOCAL lcUINA
LOCAL lcIeguldNos
LOCAL lnAtlProcents
LOCAL lcValue
LOCAL lcKomentars
LOCAL lcTaksNo
LOCAL lcTaksLidz
LOCAL lcEpasts
LOCAL lcTalrunis
LOCAL lcSagatavotajs
LOCAL lcR021
LOCAL lcR022
LOCAL lcR023
LOCAL lcR027Proc
LOCAL lcR027
LOCAL lcR028
LOCAL lcR029Proc
LOCAL lcR029
LOCAL lcR031
LOCAL lcR032
LOCAL lcR041
LOCAL lcR042
LOCAL lcR043
LOCAL lcR044
LOCAL lcR045
LOCAL lcR046
LOCAL lcR047
LOCAL lcR048Text
LOCAL lcR048
LOCAL lcR05
LOCAL lcR06
LOCAL lcR07
LOCAL lcR081
LOCAL lcR082
LOCAL lcR083
LOCAL lnId
LOCAL lcUID
LOCAL lcNmrKods
LOCAL lnPrecizejums
LOCAL lnPrecizejamaisDokuments
LOCAL lcPrecizejumaPamatojums
LOCAL i
LOCAL lnCount_i
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat_9_5_0.Http')
loHttp.SetRequestHeader("Accept","application/json")
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://eds.vid.gov.lv/api/doc/tnav2/:id",loSbResponseBody)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loSbResponseBody
CANCEL
ENDIF
loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0
? "Response Body:"
? loJResp.Emit()
lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
? "Response Header:"
? loHttp.LastHeader
? "Failed."
RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp
CANCEL
ENDIF
* 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
lcTaksNo = loJResp.StringOf("TaksNo")
lcTaksLidz = loJResp.StringOf("TaksLidz")
lcEpasts = loJResp.StringOf("Epasts")
lcTalrunis = loJResp.StringOf("Talrunis")
lcSagatavotajs = loJResp.StringOf("Sagatavotajs")
lcR021 = loJResp.StringOf("R021")
lcR022 = loJResp.StringOf("R022")
lcR023 = loJResp.StringOf("R023")
lcR027Proc = loJResp.StringOf("R027Proc")
lcR027 = loJResp.StringOf("R027")
lcR028 = loJResp.StringOf("R028")
lcR029Proc = loJResp.StringOf("R029Proc")
lcR029 = loJResp.StringOf("R029")
lcR031 = loJResp.StringOf("R031")
lcR032 = loJResp.StringOf("R032")
lcR041 = loJResp.StringOf("R041")
lcR042 = loJResp.StringOf("R042")
lcR043 = loJResp.StringOf("R043")
lcR044 = loJResp.StringOf("R044")
lcR045 = loJResp.StringOf("R045")
lcR046 = loJResp.StringOf("R046")
lcR047 = loJResp.StringOf("R047")
lcR048Text = loJResp.StringOf("R048Text")
lcR048 = loJResp.StringOf("R048")
lcR05 = loJResp.StringOf("R05")
lcR06 = loJResp.StringOf("R06")
lcR07 = loJResp.StringOf("R07")
lcR081 = loJResp.StringOf("R081")
lcR082 = loJResp.StringOf("R082")
lcR083 = loJResp.StringOf("R083")
lnId = loJResp.IntOf("Id")
lcUID = loJResp.StringOf("UID")
lcNmrKods = loJResp.StringOf("NmrKods")
lnPrecizejums = loJResp.BoolOf("Precizejums")
lnPrecizejamaisDokuments = loJResp.IntOf("PrecizejamaisDokuments")
lcPrecizejumaPamatojums = loJResp.StringOf("PrecizejumaPamatojums")
i = 0
lnCount_i = loJResp.SizeOfArray("R09_Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lcIeguldSumma = loJResp.StringOf("R09_Tabula[i].IeguldSumma")
lcKods = loJResp.StringOf("R09_Tabula[i].Kods")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("R10_Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lcIeguldSumma = loJResp.StringOf("R10_Tabula[i].IeguldSumma")
lcKods = loJResp.StringOf("R10_Tabula[i].Kods")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("R11_Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lcIeguldSumma = loJResp.StringOf("R11_Tabula[i].IeguldSumma")
lcKods = loJResp.StringOf("R11_Tabula[i].Kods")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("R12_Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lcNINA = loJResp.StringOf("R12_Tabula[i].NINA")
lcUINA = loJResp.StringOf("R12_Tabula[i].UINA")
lcKods = loJResp.StringOf("R12_Tabula[i].Kods")
lcIeguldSumma = loJResp.StringOf("R12_Tabula[i].IeguldSumma")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("R13_Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lcIeguldSumma = loJResp.StringOf("R13_Tabula[i].IeguldSumma")
lcKods = loJResp.StringOf("R13_Tabula[i].Kods")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("Ieguldijumi1")
DO WHILE i < lnCount_i
loJResp.I = i
lcKods = loJResp.StringOf("Ieguldijumi1[i].Kods")
lcIeguldNos = loJResp.StringOf("Ieguldijumi1[i].IeguldNos")
lcIeguldSumma = loJResp.StringOf("Ieguldijumi1[i].IeguldSumma")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("Ieguldijumi2")
DO WHILE i < lnCount_i
loJResp.I = i
lcKods = loJResp.StringOf("Ieguldijumi2[i].Kods")
lcIeguldNos = loJResp.StringOf("Ieguldijumi2[i].IeguldNos")
lnAtlProcents = loJResp.IntOf("Ieguldijumi2[i].AtlProcents")
lcIeguldSumma = loJResp.StringOf("Ieguldijumi2[i].IeguldSumma")
i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("Pielikumi")
DO WHILE i < lnCount_i
loJResp.I = i
lcValue = loJResp.StringOf("Pielikumi[i].Fails.value")
lcKomentars = loJResp.StringOf("Pielikumi[i].Komentars")
i = i + 1
ENDDO
RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp
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": ""
}
]
}
