Chilkat Online Tools

Foxpro / EDS API / Dokuments "IeIeN pārskats par izmaksām nerezidentiem".

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcVards
LOCAL lcUzvards
LOCAL lcValsts
LOCAL lcAdrIela
LOCAL lcAdrPilseta
LOCAL lcAdrPasts
LOCAL lcIenVeids
LOCAL lnIzmDatums
LOCAL lcIenSumma
LOCAL lcNodLikme
LOCAL lcNodSumma
LOCAL lcCitsPersKods
LOCAL lcLrNmrKods
LOCAL lcDzimDatums
LOCAL lcATVK
LOCAL lcJpKods
LOCAL lcJpNosaukums
LOCAL lcPiezimes
LOCAL lnParskGads
LOCAL lcEpasts
LOCAL lcTalrunis
LOCAL lcParskMen
LOCAL lcSagatavotajs
LOCAL lcNmrKods
LOCAL lnId
LOCAL lcUID
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/inrv2/: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)

* {
*   "ParskGads": 54743069,
*   "Epasts": "magna ad nostrud occaecat",
*   "Talrunis": "laboris mollit",
*   "ParskMen": "commodo deserunt",
*   "Sagatavotajs": "dolore nulla",
*   "NmrKods": "nostrud su",
*   "TabulaFP": [
*     {
*       "Vards": "in",
*       "Uzvards": "sunt in",
*       "Valsts": "in laborum in ullamco",
*       "AdrIela": "officia",
*       "AdrPilseta": "officia aute ad magna do",
*       "AdrPasts": "elit dolor",
*       "IenVeids": "velit adipisicing in Excepteur",
*       "IzmDatums": 17,
*       "IenSumma": -5811443.522479072,
*       "NodLikme": 23853015.107451633,
*       "NodSumma": -35352699.91027565,
*       "CitsPersKods": "Excepteur fugiat",
*       "LrNmrKods": "e",
*       "DzimDatums": "2000-01-31T00:00:00",
*       "ATVK": "enim non ipsum"
*     },
*     {
*       "Vards": "voluptate cillum laborum",
*       "Uzvards": "ut velit aliquip occaecat nulla",
*       "Valsts": "officia reprehenderit sint",
*       "AdrIela": "dese",
*       "AdrPilseta": "eu sunt",
*       "AdrPasts": "et",
*       "IenVeids": "fugiat eu",
*       "IzmDatums": 16,
*       "IenSumma": -3921734.7059562653,
*       "NodLikme": 23938705.79623814,
*       "NodSumma": -17258687.90274711,
*       "CitsPersKods": "sunt minim",
*       "LrNmrKods": "eu",
*       "DzimDatums": "2000-01-31T00:00:00",
*       "ATVK": "ea nisi irure"
*     }
*   ],
*   "TabulaJP": [
*     {
*       "Valsts": "ipsum eu id ea",
*       "AdrIela": "nisi mollit irure Excepteur",
*       "AdrPilseta": "cillum laborum",
*       "AdrPasts": "dolor cupidata",
*       "IenVeids": "fugiat ex consequat",
*       "IzmDatums": 29,
*       "IenSumma": 35501102.52214521,
*       "NodLikme": -40720481.84149244,
*       "NodSumma": 73375233.76676768,
*       "JpKods": "mollit est Lorem aute",
*       "JpNosaukums": "fugiat consequa",
*       "Piezimes": "veniam in",
*       "ATVK": "veniam reprehenderit esse adipisicing"
*     },
*     {
*       "Valsts": "Excepteur deserunt",
*       "AdrIela": "adipisicing labore commodo cillum in",
*       "AdrPilseta": "labore non nostrud magna",
*       "AdrPasts": "ut fugiat occaecat ",
*       "IenVeids": "nisi ex commodo",
*       "IzmDatums": 24,
*       "IenSumma": -49006663.90657453,
*       "NodLikme": 32085369.934580848,
*       "NodSumma": -55044059.760223664,
*       "JpKods": "culpa voluptate dolor Duis sed",
*       "JpNosaukums": "fugiat quis occaecat qui",
*       "Piezimes": "culpa velit elit",
*       "ATVK": "Lorem voluptate aliqua ut"
*     }
*   ],
*   "Id": 9851816,
*   "UID": "officia incididunt quis",
*   "Precizejums": false,
*   "PrecizejamaisDokuments": -23042510,
*   "PrecizejumaPamatojums": "nostrud dolor"
* }

* Sample code for parsing the JSON response...
* Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

lnParskGads = loJResp.IntOf("ParskGads")
lcEpasts = loJResp.StringOf("Epasts")
lcTalrunis = loJResp.StringOf("Talrunis")
lcParskMen = loJResp.StringOf("ParskMen")
lcSagatavotajs = loJResp.StringOf("Sagatavotajs")
lcNmrKods = loJResp.StringOf("NmrKods")
lnId = loJResp.IntOf("Id")
lcUID = loJResp.StringOf("UID")
lnPrecizejums = loJResp.BoolOf("Precizejums")
lnPrecizejamaisDokuments = loJResp.IntOf("PrecizejamaisDokuments")
lcPrecizejumaPamatojums = loJResp.StringOf("PrecizejumaPamatojums")
i = 0
lnCount_i = loJResp.SizeOfArray("TabulaFP")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcVards = loJResp.StringOf("TabulaFP[i].Vards")
    lcUzvards = loJResp.StringOf("TabulaFP[i].Uzvards")
    lcValsts = loJResp.StringOf("TabulaFP[i].Valsts")
    lcAdrIela = loJResp.StringOf("TabulaFP[i].AdrIela")
    lcAdrPilseta = loJResp.StringOf("TabulaFP[i].AdrPilseta")
    lcAdrPasts = loJResp.StringOf("TabulaFP[i].AdrPasts")
    lcIenVeids = loJResp.StringOf("TabulaFP[i].IenVeids")
    lnIzmDatums = loJResp.IntOf("TabulaFP[i].IzmDatums")
    lcIenSumma = loJResp.StringOf("TabulaFP[i].IenSumma")
    lcNodLikme = loJResp.StringOf("TabulaFP[i].NodLikme")
    lcNodSumma = loJResp.StringOf("TabulaFP[i].NodSumma")
    lcCitsPersKods = loJResp.StringOf("TabulaFP[i].CitsPersKods")
    lcLrNmrKods = loJResp.StringOf("TabulaFP[i].LrNmrKods")
    lcDzimDatums = loJResp.StringOf("TabulaFP[i].DzimDatums")
    lcATVK = loJResp.StringOf("TabulaFP[i].ATVK")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("TabulaJP")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcValsts = loJResp.StringOf("TabulaJP[i].Valsts")
    lcAdrIela = loJResp.StringOf("TabulaJP[i].AdrIela")
    lcAdrPilseta = loJResp.StringOf("TabulaJP[i].AdrPilseta")
    lcAdrPasts = loJResp.StringOf("TabulaJP[i].AdrPasts")
    lcIenVeids = loJResp.StringOf("TabulaJP[i].IenVeids")
    lnIzmDatums = loJResp.IntOf("TabulaJP[i].IzmDatums")
    lcIenSumma = loJResp.StringOf("TabulaJP[i].IenSumma")
    lcNodLikme = loJResp.StringOf("TabulaJP[i].NodLikme")
    lcNodSumma = loJResp.StringOf("TabulaJP[i].NodSumma")
    lcJpKods = loJResp.StringOf("TabulaJP[i].JpKods")
    lcJpNosaukums = loJResp.StringOf("TabulaJP[i].JpNosaukums")
    lcPiezimes = loJResp.StringOf("TabulaJP[i].Piezimes")
    lcATVK = loJResp.StringOf("TabulaJP[i].ATVK")
    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/inrv2/:id

Postman Collection Item JSON

{
  "name": "Dokuments \"IeIeN pārskats par izmaksām nerezidentiem\".",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/doc/inrv2/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "doc",
        "inrv2",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "25210683",
          "description": "(Required) Dokumenta id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/inrv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "inrv2",
            ":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  \"ParskGads\": 54743069,\n  \"Epasts\": \"magna ad nostrud occaecat\",\n  \"Talrunis\": \"laboris mollit\",\n  \"ParskMen\": \"commodo deserunt\",\n  \"Sagatavotajs\": \"dolore nulla\",\n  \"NmrKods\": \"nostrud su\",\n  \"TabulaFP\": [\n    {\n      \"Vards\": \"in\",\n      \"Uzvards\": \"sunt in\",\n      \"Valsts\": \"in laborum in ullamco\",\n      \"AdrIela\": \"officia\",\n      \"AdrPilseta\": \"officia aute ad magna do\",\n      \"AdrPasts\": \"elit dolor\",\n      \"IenVeids\": \"velit adipisicing in Excepteur\",\n      \"IzmDatums\": 17,\n      \"IenSumma\": -5811443.522479072,\n      \"NodLikme\": 23853015.107451633,\n      \"NodSumma\": -35352699.91027565,\n      \"CitsPersKods\": \"Excepteur fugiat\",\n      \"LrNmrKods\": \"e\",\n      \"DzimDatums\": \"2000-01-31T00:00:00\",\n      \"ATVK\": \"enim non ipsum\"\n    },\n    {\n      \"Vards\": \"voluptate cillum laborum\",\n      \"Uzvards\": \"ut velit aliquip occaecat nulla\",\n      \"Valsts\": \"officia reprehenderit sint\",\n      \"AdrIela\": \"dese\",\n      \"AdrPilseta\": \"eu sunt\",\n      \"AdrPasts\": \"et\",\n      \"IenVeids\": \"fugiat eu\",\n      \"IzmDatums\": 16,\n      \"IenSumma\": -3921734.7059562653,\n      \"NodLikme\": 23938705.79623814,\n      \"NodSumma\": -17258687.90274711,\n      \"CitsPersKods\": \"sunt minim\",\n      \"LrNmrKods\": \"eu\",\n      \"DzimDatums\": \"2000-01-31T00:00:00\",\n      \"ATVK\": \"ea nisi irure\"\n    }\n  ],\n  \"TabulaJP\": [\n    {\n      \"Valsts\": \"ipsum eu id ea\",\n      \"AdrIela\": \"nisi mollit irure Excepteur\",\n      \"AdrPilseta\": \"cillum laborum\",\n      \"AdrPasts\": \"dolor cupidata\",\n      \"IenVeids\": \"fugiat ex consequat\",\n      \"IzmDatums\": 29,\n      \"IenSumma\": 35501102.52214521,\n      \"NodLikme\": -40720481.84149244,\n      \"NodSumma\": 73375233.76676768,\n      \"JpKods\": \"mollit est Lorem aute\",\n      \"JpNosaukums\": \"fugiat consequa\",\n      \"Piezimes\": \"veniam in\",\n      \"ATVK\": \"veniam reprehenderit esse adipisicing\"\n    },\n    {\n      \"Valsts\": \"Excepteur deserunt\",\n      \"AdrIela\": \"adipisicing labore commodo cillum in\",\n      \"AdrPilseta\": \"labore non nostrud magna\",\n      \"AdrPasts\": \"ut fugiat occaecat \",\n      \"IenVeids\": \"nisi ex commodo\",\n      \"IzmDatums\": 24,\n      \"IenSumma\": -49006663.90657453,\n      \"NodLikme\": 32085369.934580848,\n      \"NodSumma\": -55044059.760223664,\n      \"JpKods\": \"culpa voluptate dolor Duis sed\",\n      \"JpNosaukums\": \"fugiat quis occaecat qui\",\n      \"Piezimes\": \"culpa velit elit\",\n      \"ATVK\": \"Lorem voluptate aliqua ut\"\n    }\n  ],\n  \"Id\": 9851816,\n  \"UID\": \"officia incididunt quis\",\n  \"Precizejums\": false,\n  \"PrecizejamaisDokuments\": -23042510,\n  \"PrecizejumaPamatojums\": \"nostrud dolor\"\n}"
    },
    {
      "name": "Lietotājs nav autentificēts.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/inrv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "inrv2",
            ":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/inrv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "inrv2",
            ":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/inrv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "inrv2",
            ":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": ""
    }
  ]
}