Chilkat Online Tools

Foxpro / EDS API / Dokuments "Kafijas un bezalkoholisko dzērienu akcīzes nodokļa deklarācija".

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcValue
LOCAL lcEpasts
LOCAL lcTalrunis
LOCAL lnGads
LOCAL lnMenesis
LOCAL lcDatums
LOCAL lcSamTermins
LOCAL lcStatuss
LOCAL lcR08
LOCAL lcR09
LOCAL lcSagatavotajs
LOCAL lcK1
LOCAL lcK2
LOCAL lcK3
LOCAL lcR11K1
LOCAL lcR11K2
LOCAL lcR11K3
LOCAL lcR12K1
LOCAL lcR12K2
LOCAL lcR12K3
LOCAL lcR13K1
LOCAL lcR13K2
LOCAL lcR13K3
LOCAL lcR14K1
LOCAL lcR14K2
LOCAL lcR14K3
LOCAL lcR15K1
LOCAL lcR15K2
LOCAL lcR15K3
LOCAL lcR16K1
LOCAL lcR16K2
LOCAL lcR16K3
LOCAL lcR17K1
LOCAL lcR17K2
LOCAL lcR17K3
LOCAL lcR18K1
LOCAL lcR18K2
LOCAL lcR18K3
LOCAL lcR19K1
LOCAL lcR19K2
LOCAL lcR19K3
LOCAL lcR20K1
LOCAL lcR20K2
LOCAL lcR20K3
LOCAL lcR21K1
LOCAL lcR21K2
LOCAL lcR21K3
LOCAL lcR22K1
LOCAL lcR22K2
LOCAL lcR22K3
LOCAL lcR23K1
LOCAL lcR23K2
LOCAL lcR23K3
LOCAL lcR24K1
LOCAL lcR24K2
LOCAL lcR24K3
LOCAL lcR25K1
LOCAL lcR25K2
LOCAL lcR25K3
LOCAL lcR26K1
LOCAL lcR26K2
LOCAL lcR26K3
LOCAL lcR27K1
LOCAL lcR27K2
LOCAL lcR27K3
LOCAL lcValue
LOCAL lcKomentarsValue
LOCAL lcFailsValue
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/ankbv2/: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)

* {
*   "Epasts": "consectetur aliqui",
*   "Talrunis": "Lorem est ",
*   "Gads": 55791739,
*   "Menesis": 3,
*   "Datums": "2000-01-31T00:00:00",
*   "SamTermins": "2000-01-31T00:00:00",
*   "Statuss": "non nostrud ut aute",
*   "R08": "elit aliquip esse culpa ad",
*   "R09": "incididunt cillum ex",
*   "Sagatavotajs": "dolore magna",
*   "R10": {
*     "K1": 56269837.42085248,
*     "K2": -97298581.74073067,
*     "K3": 12294961.351833716
*   },
*   "R11": {
*     "K1": 41022931.67948061,
*     "K2": -68712318.08074483,
*     "K3": 90842091.99793217
*   },
*   "R12": {
*     "K1": 84287865.76155868,
*     "K2": -75203210.86545718,
*     "K3": 96069798.82083505
*   },
*   "R13": {
*     "K1": 19153612.749102816,
*     "K2": 69191084.53138548,
*     "K3": -41146809.24410861
*   },
*   "R14": {
*     "K1": -25589893.00259231,
*     "K2": -40394478.88604588,
*     "K3": -67509512.05558807
*   },
*   "R15": {
*     "K1": -13389900.565754324,
*     "K2": -67256828.72786547,
*     "K3": 9963358.057663158
*   },
*   "R16": {
*     "K1": 40630728.91606638,
*     "K2": 36694283.38713309,
*     "K3": -94233825.83611923
*   },
*   "R17": {
*     "K1": 9514933.913133025,
*     "K2": -96214731.34989595,
*     "K3": -40894391.21104315
*   },
*   "R18": {
*     "K1": -26335901.074957892,
*     "K2": 89969023.26793891,
*     "K3": -32821793.514351994
*   },
*   "R19": {
*     "K1": -66751306.14344158,
*     "K2": -81422919.1551168,
*     "K3": 83748164.62387183
*   },
*   "R20": {
*     "K1": -92844504.24250332,
*     "K2": 9964276.005876243,
*     "K3": 55762994.440933555
*   },
*   "R21": {
*     "K1": 68143846.12130961,
*     "K2": -70891897.90269752,
*     "K3": -323941.36614084244
*   },
*   "R22": {
*     "K1": -59236603.09707017,
*     "K2": -77585980.67387563,
*     "K3": 81620375.05168778
*   },
*   "R23": {
*     "K1": 84614414.77212152,
*     "K2": -13312758.937248185,
*     "K3": -19915436.80421537
*   },
*   "R24": {
*     "K1": 5935688.459061697,
*     "K2": -69949002.14066488,
*     "K3": -44295563.71114125
*   },
*   "R25": {
*     "K1": 35596437.75422415,
*     "K2": -59318538.3605745,
*     "K3": 76529327.62100697
*   },
*   "R26": {
*     "K1": 43057819.54356083,
*     "K2": 29875064.405484915,
*     "K3": 64398434.4663541
*   },
*   "R27": {
*     "K1": 13984380.364867061,
*     "K2": -32033218.33421868,
*     "K3": -42390871.13414248
*   },
*   "R29": {
*     "PielikumsRindai11": {
*       "Fails": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       },
*       "Komentars": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       }
*     },
*     "PielikumsRindai25": {
*       "Fails": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       },
*       "Komentars": {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       }
*     },
*     "CitiDokumenti": [
*       {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       },
*       {
*         "value": "<Error: Too many levels of nesting to fake this schema>"
*       }
*     ]
*   },
*   "Id": -79018099,
*   "UID": "eu consequat do",
*   "NmrKods": "est temp",
*   "Precizejums": true,
*   "PrecizejamaisDokuments": -14482926,
*   "PrecizejumaPamatojums": "ullamco commodo"
* }

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

lcEpasts = loJResp.StringOf("Epasts")
lcTalrunis = loJResp.StringOf("Talrunis")
lnGads = loJResp.IntOf("Gads")
lnMenesis = loJResp.IntOf("Menesis")
lcDatums = loJResp.StringOf("Datums")
lcSamTermins = loJResp.StringOf("SamTermins")
lcStatuss = loJResp.StringOf("Statuss")
lcR08 = loJResp.StringOf("R08")
lcR09 = loJResp.StringOf("R09")
lcSagatavotajs = loJResp.StringOf("Sagatavotajs")
lcK1 = loJResp.StringOf("R10.K1")
lcK2 = loJResp.StringOf("R10.K2")
lcK3 = loJResp.StringOf("R10.K3")
lcR11K1 = loJResp.StringOf("R11.K1")
lcR11K2 = loJResp.StringOf("R11.K2")
lcR11K3 = loJResp.StringOf("R11.K3")
lcR12K1 = loJResp.StringOf("R12.K1")
lcR12K2 = loJResp.StringOf("R12.K2")
lcR12K3 = loJResp.StringOf("R12.K3")
lcR13K1 = loJResp.StringOf("R13.K1")
lcR13K2 = loJResp.StringOf("R13.K2")
lcR13K3 = loJResp.StringOf("R13.K3")
lcR14K1 = loJResp.StringOf("R14.K1")
lcR14K2 = loJResp.StringOf("R14.K2")
lcR14K3 = loJResp.StringOf("R14.K3")
lcR15K1 = loJResp.StringOf("R15.K1")
lcR15K2 = loJResp.StringOf("R15.K2")
lcR15K3 = loJResp.StringOf("R15.K3")
lcR16K1 = loJResp.StringOf("R16.K1")
lcR16K2 = loJResp.StringOf("R16.K2")
lcR16K3 = loJResp.StringOf("R16.K3")
lcR17K1 = loJResp.StringOf("R17.K1")
lcR17K2 = loJResp.StringOf("R17.K2")
lcR17K3 = loJResp.StringOf("R17.K3")
lcR18K1 = loJResp.StringOf("R18.K1")
lcR18K2 = loJResp.StringOf("R18.K2")
lcR18K3 = loJResp.StringOf("R18.K3")
lcR19K1 = loJResp.StringOf("R19.K1")
lcR19K2 = loJResp.StringOf("R19.K2")
lcR19K3 = loJResp.StringOf("R19.K3")
lcR20K1 = loJResp.StringOf("R20.K1")
lcR20K2 = loJResp.StringOf("R20.K2")
lcR20K3 = loJResp.StringOf("R20.K3")
lcR21K1 = loJResp.StringOf("R21.K1")
lcR21K2 = loJResp.StringOf("R21.K2")
lcR21K3 = loJResp.StringOf("R21.K3")
lcR22K1 = loJResp.StringOf("R22.K1")
lcR22K2 = loJResp.StringOf("R22.K2")
lcR22K3 = loJResp.StringOf("R22.K3")
lcR23K1 = loJResp.StringOf("R23.K1")
lcR23K2 = loJResp.StringOf("R23.K2")
lcR23K3 = loJResp.StringOf("R23.K3")
lcR24K1 = loJResp.StringOf("R24.K1")
lcR24K2 = loJResp.StringOf("R24.K2")
lcR24K3 = loJResp.StringOf("R24.K3")
lcR25K1 = loJResp.StringOf("R25.K1")
lcR25K2 = loJResp.StringOf("R25.K2")
lcR25K3 = loJResp.StringOf("R25.K3")
lcR26K1 = loJResp.StringOf("R26.K1")
lcR26K2 = loJResp.StringOf("R26.K2")
lcR26K3 = loJResp.StringOf("R26.K3")
lcR27K1 = loJResp.StringOf("R27.K1")
lcR27K2 = loJResp.StringOf("R27.K2")
lcR27K3 = loJResp.StringOf("R27.K3")
lcValue = loJResp.StringOf("R29.PielikumsRindai11.Fails.value")
lcKomentarsValue = loJResp.StringOf("R29.PielikumsRindai11.Komentars.value")
lcFailsValue = loJResp.StringOf("R29.PielikumsRindai25.Fails.value")
lcKomentarsValue = loJResp.StringOf("R29.PielikumsRindai25.Komentars.value")
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("R29.CitiDokumenti")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcValue = loJResp.StringOf("R29.CitiDokumenti[i].value")
    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/ankbv2/:id

Postman Collection Item JSON

{
  "name": "Dokuments \"Kafijas un bezalkoholisko dzērienu akcīzes nodokļa deklarācija\".",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/doc/ankbv2/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "doc",
        "ankbv2",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "25210683",
          "description": "(Required) Dokumenta id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/ankbv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "ankbv2",
            ":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  \"Epasts\": \"consectetur aliqui\",\n  \"Talrunis\": \"Lorem est \",\n  \"Gads\": 55791739,\n  \"Menesis\": 3,\n  \"Datums\": \"2000-01-31T00:00:00\",\n  \"SamTermins\": \"2000-01-31T00:00:00\",\n  \"Statuss\": \"non nostrud ut aute\",\n  \"R08\": \"elit aliquip esse culpa ad\",\n  \"R09\": \"incididunt cillum ex\",\n  \"Sagatavotajs\": \"dolore magna\",\n  \"R10\": {\n    \"K1\": 56269837.42085248,\n    \"K2\": -97298581.74073067,\n    \"K3\": 12294961.351833716\n  },\n  \"R11\": {\n    \"K1\": 41022931.67948061,\n    \"K2\": -68712318.08074483,\n    \"K3\": 90842091.99793217\n  },\n  \"R12\": {\n    \"K1\": 84287865.76155868,\n    \"K2\": -75203210.86545718,\n    \"K3\": 96069798.82083505\n  },\n  \"R13\": {\n    \"K1\": 19153612.749102816,\n    \"K2\": 69191084.53138548,\n    \"K3\": -41146809.24410861\n  },\n  \"R14\": {\n    \"K1\": -25589893.00259231,\n    \"K2\": -40394478.88604588,\n    \"K3\": -67509512.05558807\n  },\n  \"R15\": {\n    \"K1\": -13389900.565754324,\n    \"K2\": -67256828.72786547,\n    \"K3\": 9963358.057663158\n  },\n  \"R16\": {\n    \"K1\": 40630728.91606638,\n    \"K2\": 36694283.38713309,\n    \"K3\": -94233825.83611923\n  },\n  \"R17\": {\n    \"K1\": 9514933.913133025,\n    \"K2\": -96214731.34989595,\n    \"K3\": -40894391.21104315\n  },\n  \"R18\": {\n    \"K1\": -26335901.074957892,\n    \"K2\": 89969023.26793891,\n    \"K3\": -32821793.514351994\n  },\n  \"R19\": {\n    \"K1\": -66751306.14344158,\n    \"K2\": -81422919.1551168,\n    \"K3\": 83748164.62387183\n  },\n  \"R20\": {\n    \"K1\": -92844504.24250332,\n    \"K2\": 9964276.005876243,\n    \"K3\": 55762994.440933555\n  },\n  \"R21\": {\n    \"K1\": 68143846.12130961,\n    \"K2\": -70891897.90269752,\n    \"K3\": -323941.36614084244\n  },\n  \"R22\": {\n    \"K1\": -59236603.09707017,\n    \"K2\": -77585980.67387563,\n    \"K3\": 81620375.05168778\n  },\n  \"R23\": {\n    \"K1\": 84614414.77212152,\n    \"K2\": -13312758.937248185,\n    \"K3\": -19915436.80421537\n  },\n  \"R24\": {\n    \"K1\": 5935688.459061697,\n    \"K2\": -69949002.14066488,\n    \"K3\": -44295563.71114125\n  },\n  \"R25\": {\n    \"K1\": 35596437.75422415,\n    \"K2\": -59318538.3605745,\n    \"K3\": 76529327.62100697\n  },\n  \"R26\": {\n    \"K1\": 43057819.54356083,\n    \"K2\": 29875064.405484915,\n    \"K3\": 64398434.4663541\n  },\n  \"R27\": {\n    \"K1\": 13984380.364867061,\n    \"K2\": -32033218.33421868,\n    \"K3\": -42390871.13414248\n  },\n  \"R29\": {\n    \"PielikumsRindai11\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"PielikumsRindai25\": {\n      \"Fails\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"Komentars\": {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    },\n    \"CitiDokumenti\": [\n      {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n        \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n    ]\n  },\n  \"Id\": -79018099,\n  \"UID\": \"eu consequat do\",\n  \"NmrKods\": \"est temp\",\n  \"Precizejums\": true,\n  \"PrecizejamaisDokuments\": -14482926,\n  \"PrecizejumaPamatojums\": \"ullamco commodo\"\n}"
    },
    {
      "name": "Lietotājs nav autentificēts.",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/api/doc/ankbv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "ankbv2",
            ":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/ankbv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "ankbv2",
            ":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/ankbv2/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "doc",
            "ankbv2",
            ":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": ""
    }
  ]
}