Chilkat Online Tools

Foxpro / EDS API / Dokuments "IeIeN avansa maksājumu aprēķins no saimnieciskās darbības".

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcValue
LOCAL lcKomentars
LOCAL lnParskGads
LOCAL lcEpasts
LOCAL lcTalrunis
LOCAL lcSagatavotajs
LOCAL lnPrecizetsAvanss
LOCAL lnGramatina
LOCAL lcPirmstaksac
LOCAL lcPrognoze
LOCAL lcNeaplMin
LOCAL lcAtvieglojumi
LOCAL lcPapildu
LOCAL lcIenakums
LOCAL lcSumma1
LOCAL lcSumma2
LOCAL lcAvanss
LOCAL lcMaksat
LOCAL lcMaijam
LOCAL lcAugustam
LOCAL lcNovembrim
LOCAL lcNakGadam
LOCAL lnMaksajumuDatumuNobide
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/avav3/: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": -66015000,
*   "Epasts": "cillum quis",
*   "Talrunis": "aliqua Lor",
*   "Sagatavotajs": "dolor Excepteur",
*   "PrecizetsAvanss": false,
*   "Gramatina": false,
*   "Rindas": {
*     "Pirmstaksac": 43398898.52144426,
*     "Prognoze": 73325365.17797586,
*     "NeaplMin": -98820485.69261533,
*     "Atvieglojumi": 8804795.959262624,
*     "Papildu": 54172200.69096351,
*     "Ienakums": 88634527.68370709,
*     "Summa1": 54524270.02204311,
*     "Summa2": 10079919.941559985,
*     "Avanss": 7371456.325339004,
*     "Maksat": -40844647.95559053,
*     "Maijam": 89736960.51264724,
*     "Augustam": -41372176.56461831,
*     "Novembrim": -43093693.79643346,
*     "NakGadam": -13699644.074778885
*   },
*   "Pielikumi": [
*     {
*       "Fails": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       },
*       "Komentars": "elit"
*     },
*     {
*       "Fails": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       },
*       "Komentars": "officia"
*     }
*   ],
*   "MaksajumuDatumuNobide": true,
*   "Id": -95799823,
*   "UID": "quis",
*   "NmrKods": "sint occa",
*   "Precizejums": false,
*   "PrecizejamaisDokuments": -16722675,
*   "PrecizejumaPamatojums": "quis labore ipsum"
* }

* 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")
lcSagatavotajs = loJResp.StringOf("Sagatavotajs")
lnPrecizetsAvanss = loJResp.BoolOf("PrecizetsAvanss")
lnGramatina = loJResp.BoolOf("Gramatina")
lcPirmstaksac = loJResp.StringOf("Rindas.Pirmstaksac")
lcPrognoze = loJResp.StringOf("Rindas.Prognoze")
lcNeaplMin = loJResp.StringOf("Rindas.NeaplMin")
lcAtvieglojumi = loJResp.StringOf("Rindas.Atvieglojumi")
lcPapildu = loJResp.StringOf("Rindas.Papildu")
lcIenakums = loJResp.StringOf("Rindas.Ienakums")
lcSumma1 = loJResp.StringOf("Rindas.Summa1")
lcSumma2 = loJResp.StringOf("Rindas.Summa2")
lcAvanss = loJResp.StringOf("Rindas.Avanss")
lcMaksat = loJResp.StringOf("Rindas.Maksat")
lcMaijam = loJResp.StringOf("Rindas.Maijam")
lcAugustam = loJResp.StringOf("Rindas.Augustam")
lcNovembrim = loJResp.StringOf("Rindas.Novembrim")
lcNakGadam = loJResp.StringOf("Rindas.NakGadam")
lnMaksajumuDatumuNobide = loJResp.BoolOf("MaksajumuDatumuNobide")
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("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/avav3/:id

Postman Collection Item JSON

{
  "name": "Dokuments \"IeIeN avansa maksājumu aprēķins no saimnieciskās darbības\".",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/doc/avav3/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "doc",
        "avav3",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "25210683",
          "description": "(Required) Dokumenta id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/avav3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "avav3",
            ":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\": -66015000,\n  \"Epasts\": \"cillum quis\",\n  \"Talrunis\": \"aliqua Lor\",\n  \"Sagatavotajs\": \"dolor Excepteur\",\n  \"PrecizetsAvanss\": false,\n  \"Gramatina\": false,\n  \"Rindas\": {\n    \"Pirmstaksac\": 43398898.52144426,\n    \"Prognoze\": 73325365.17797586,\n    \"NeaplMin\": -98820485.69261533,\n    \"Atvieglojumi\": 8804795.959262624,\n    \"Papildu\": 54172200.69096351,\n    \"Ienakums\": 88634527.68370709,\n    \"Summa1\": 54524270.02204311,\n    \"Summa2\": 10079919.941559985,\n    \"Avanss\": 7371456.325339004,\n    \"Maksat\": -40844647.95559053,\n    \"Maijam\": 89736960.51264724,\n    \"Augustam\": -41372176.56461831,\n    \"Novembrim\": -43093693.79643346,\n    \"NakGadam\": -13699644.074778885\n  },\n  \"Pielikumi\": [\n    {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": \"elit\"\n    },\n    {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": \"officia\"\n    }\n  ],\n  \"MaksajumuDatumuNobide\": true,\n  \"Id\": -95799823,\n  \"UID\": \"quis\",\n  \"NmrKods\": \"sint occa\",\n  \"Precizejums\": false,\n  \"PrecizejamaisDokuments\": -16722675,\n  \"PrecizejumaPamatojums\": \"quis labore ipsum\"\n}"
    },
    {
      "name": "Lietotājs nav autentificēts.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/avav3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "avav3",
            ":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/avav3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "avav3",
            ":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/avav3/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "avav3",
            ":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": ""
    }
  ]
}