Chilkat Online Tools

VB6 / EDS API / Dokuments "Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai".

Back to Collection Items

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

http.SetRequestHeader "Accept","application/json"

Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://eds.vid.gov.lv/api/doc/tnav2/:id",sbResponseBody)
If (success = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    Debug.Print "Failed."
    Exit Sub
End If

' 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

Dim IeguldSumma As String
Dim Kods As String
Dim NINA As String
Dim UINA As String
Dim IeguldNos As String
Dim AtlProcents As Long
Dim Value As String
Dim Komentars As String

Dim TaksNo As String
TaksNo = jResp.StringOf("TaksNo")
Dim TaksLidz As String
TaksLidz = jResp.StringOf("TaksLidz")
Dim Epasts As String
Epasts = jResp.StringOf("Epasts")
Dim Talrunis As String
Talrunis = jResp.StringOf("Talrunis")
Dim Sagatavotajs As String
Sagatavotajs = jResp.StringOf("Sagatavotajs")
Dim R021 As String
R021 = jResp.StringOf("R021")
Dim R022 As String
R022 = jResp.StringOf("R022")
Dim R023 As String
R023 = jResp.StringOf("R023")
Dim R027Proc As String
R027Proc = jResp.StringOf("R027Proc")
Dim R027 As String
R027 = jResp.StringOf("R027")
Dim R028 As String
R028 = jResp.StringOf("R028")
Dim R029Proc As String
R029Proc = jResp.StringOf("R029Proc")
Dim R029 As String
R029 = jResp.StringOf("R029")
Dim R031 As String
R031 = jResp.StringOf("R031")
Dim R032 As String
R032 = jResp.StringOf("R032")
Dim R041 As String
R041 = jResp.StringOf("R041")
Dim R042 As String
R042 = jResp.StringOf("R042")
Dim R043 As String
R043 = jResp.StringOf("R043")
Dim R044 As String
R044 = jResp.StringOf("R044")
Dim R045 As String
R045 = jResp.StringOf("R045")
Dim R046 As String
R046 = jResp.StringOf("R046")
Dim R047 As String
R047 = jResp.StringOf("R047")
Dim R048Text As String
R048Text = jResp.StringOf("R048Text")
Dim R048 As String
R048 = jResp.StringOf("R048")
Dim R05 As String
R05 = jResp.StringOf("R05")
Dim R06 As String
R06 = jResp.StringOf("R06")
Dim R07 As String
R07 = jResp.StringOf("R07")
Dim R081 As String
R081 = jResp.StringOf("R081")
Dim R082 As String
R082 = jResp.StringOf("R082")
Dim R083 As String
R083 = jResp.StringOf("R083")
Dim Id As Long
Id = jResp.IntOf("Id")
Dim UID As String
UID = jResp.StringOf("UID")
Dim NmrKods As String
NmrKods = jResp.StringOf("NmrKods")
Dim Precizejums As Long
Precizejums = jResp.BoolOf("Precizejums")
Dim PrecizejamaisDokuments As Long
PrecizejamaisDokuments = jResp.IntOf("PrecizejamaisDokuments")
Dim PrecizejumaPamatojums As String
PrecizejumaPamatojums = jResp.StringOf("PrecizejumaPamatojums")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("R09_Tabula")
Do While i < count_i
    jResp.I = i
    IeguldSumma = jResp.StringOf("R09_Tabula[i].IeguldSumma")
    Kods = jResp.StringOf("R09_Tabula[i].Kods")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("R10_Tabula")
Do While i < count_i
    jResp.I = i
    IeguldSumma = jResp.StringOf("R10_Tabula[i].IeguldSumma")
    Kods = jResp.StringOf("R10_Tabula[i].Kods")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("R11_Tabula")
Do While i < count_i
    jResp.I = i
    IeguldSumma = jResp.StringOf("R11_Tabula[i].IeguldSumma")
    Kods = jResp.StringOf("R11_Tabula[i].Kods")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("R12_Tabula")
Do While i < 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
Loop
i = 0
count_i = jResp.SizeOfArray("R13_Tabula")
Do While i < count_i
    jResp.I = i
    IeguldSumma = jResp.StringOf("R13_Tabula[i].IeguldSumma")
    Kods = jResp.StringOf("R13_Tabula[i].Kods")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("Ieguldijumi1")
Do While i < 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
Loop
i = 0
count_i = jResp.SizeOfArray("Ieguldijumi2")
Do While i < 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
Loop
i = 0
count_i = jResp.SizeOfArray("Pielikumi")
Do While i < count_i
    jResp.I = i
    Value = jResp.StringOf("Pielikumi[i].Fails.value")
    Komentars = jResp.StringOf("Pielikumi[i].Komentars")
    i = i + 1
Loop

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": ""
    }
  ]
}