Foxpro / EDS API / Dokuments "PVN 3: Labojumu pārskats par preču piegādēm un sniegtajiem pakalpojumiem Eiropas Savienības teritorijā".
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lnLabojumaVeids
LOCAL lcVecsTaksacijasPeriods
LOCAL lcVecsValsts
LOCAL lcVecsPVNRegistracijasNumurs
LOCAL lcVecsSumma
LOCAL lcVecsPazime
LOCAL lcVecsDarijumaPartneraPVNRegistracijasNumurs
LOCAL lcJaunsTaksacijasPeriods
LOCAL lcJaunsValsts
LOCAL lcJaunsPVNRegistracijasNumurs
LOCAL lcJaunsSumma
LOCAL lcJaunsPazime
LOCAL lcJaunsDarijumaPartneraPVNRegistracijasNumurs
LOCAL lcEpasts
LOCAL lcTalrunis
LOCAL lcSagatavotajs
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.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')
loHttp.SetRequestHeader("Accept","application/json")
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponseBody = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://eds.vid.gov.lv/api/doc/pvn3v2/:id",loSbResponseBody)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loSbResponseBody
CANCEL
ENDIF
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJResp = CreateObject('Chilkat.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": "dolore dolor ea",
* "Talrunis": "adipisic",
* "Sagatavotajs": "pariatur id",
* "Tabula": [
* {
* "LabojumaVeids": -40540857,
* "VecsTaksacijasPeriods": "sit",
* "VecsValsts": "anim enim",
* "VecsPVNRegistracijasNumurs": "amet ",
* "VecsSumma": 49099260.607072145,
* "VecsPazime": "",
* "VecsDarijumaPartneraPVNRegistracijasNumurs": "ad",
* "JaunsTaksacijasPeriods": "sunt commodo culpa quis",
* "JaunsValsts": "amet incididunt",
* "JaunsPVNRegistracijasNumurs": "eu incid",
* "JaunsSumma": 40043165.78646079,
* "JaunsPazime": "ea dolor",
* "JaunsDarijumaPartneraPVNRegistracijasNumurs": "ir"
* },
* {
* "LabojumaVeids": -58748037,
* "VecsTaksacijasPeriods": "esse nisi sed reprehenderit",
* "VecsValsts": "dolore culpa ut",
* "VecsPVNRegistracijasNumurs": "labo",
* "VecsSumma": -5870200.653635845,
* "VecsPazime": "enim Lorem cupidatat dolore reprehenderit",
* "VecsDarijumaPartneraPVNRegistracijasNumurs": "ma",
* "JaunsTaksacijasPeriods": "Ut tempor nulla non aute",
* "JaunsValsts": "non aliquip pariatur",
* "JaunsPVNRegistracijasNumurs": "comm",
* "JaunsSumma": -41619742.90246975,
* "JaunsPazime": "veniam nulla dolore",
* "JaunsDarijumaPartneraPVNRegistracijasNumurs": "si"
* }
* ],
* "Id": -91768496,
* "UID": "dolor in non elit dolor",
* "NmrKods": "vel",
* "Precizejums": false,
* "PrecizejamaisDokuments": -25891465,
* "PrecizejumaPamatojums": "ut adipisicing"
* }
* 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")
lcSagatavotajs = loJResp.StringOf("Sagatavotajs")
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("Tabula")
DO WHILE i < lnCount_i
loJResp.I = i
lnLabojumaVeids = loJResp.IntOf("Tabula[i].LabojumaVeids")
lcVecsTaksacijasPeriods = loJResp.StringOf("Tabula[i].VecsTaksacijasPeriods")
lcVecsValsts = loJResp.StringOf("Tabula[i].VecsValsts")
lcVecsPVNRegistracijasNumurs = loJResp.StringOf("Tabula[i].VecsPVNRegistracijasNumurs")
lcVecsSumma = loJResp.StringOf("Tabula[i].VecsSumma")
lcVecsPazime = loJResp.StringOf("Tabula[i].VecsPazime")
lcVecsDarijumaPartneraPVNRegistracijasNumurs = loJResp.StringOf("Tabula[i].VecsDarijumaPartneraPVNRegistracijasNumurs")
lcJaunsTaksacijasPeriods = loJResp.StringOf("Tabula[i].JaunsTaksacijasPeriods")
lcJaunsValsts = loJResp.StringOf("Tabula[i].JaunsValsts")
lcJaunsPVNRegistracijasNumurs = loJResp.StringOf("Tabula[i].JaunsPVNRegistracijasNumurs")
lcJaunsSumma = loJResp.StringOf("Tabula[i].JaunsSumma")
lcJaunsPazime = loJResp.StringOf("Tabula[i].JaunsPazime")
lcJaunsDarijumaPartneraPVNRegistracijasNumurs = loJResp.StringOf("Tabula[i].JaunsDarijumaPartneraPVNRegistracijasNumurs")
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/pvn3v2/:id
Postman Collection Item JSON
{
"name": "Dokuments \"PVN 3: Labojumu pārskats par preču piegādēm un sniegtajiem pakalpojumiem Eiropas Savienības teritorijā\".",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/doc/pvn3v2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"pvn3v2",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/pvn3v2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"pvn3v2",
":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\": \"dolore dolor ea\",\n \"Talrunis\": \"adipisic\",\n \"Sagatavotajs\": \"pariatur id\",\n \"Tabula\": [\n {\n \"LabojumaVeids\": -40540857,\n \"VecsTaksacijasPeriods\": \"sit\",\n \"VecsValsts\": \"anim enim\",\n \"VecsPVNRegistracijasNumurs\": \"amet \",\n \"VecsSumma\": 49099260.607072145,\n \"VecsPazime\": \"\",\n \"VecsDarijumaPartneraPVNRegistracijasNumurs\": \"ad\",\n \"JaunsTaksacijasPeriods\": \"sunt commodo culpa quis\",\n \"JaunsValsts\": \"amet incididunt\",\n \"JaunsPVNRegistracijasNumurs\": \"eu incid\",\n \"JaunsSumma\": 40043165.78646079,\n \"JaunsPazime\": \"ea dolor\",\n \"JaunsDarijumaPartneraPVNRegistracijasNumurs\": \"ir\"\n },\n {\n \"LabojumaVeids\": -58748037,\n \"VecsTaksacijasPeriods\": \"esse nisi sed reprehenderit\",\n \"VecsValsts\": \"dolore culpa ut\",\n \"VecsPVNRegistracijasNumurs\": \"labo\",\n \"VecsSumma\": -5870200.653635845,\n \"VecsPazime\": \"enim Lorem cupidatat dolore reprehenderit\",\n \"VecsDarijumaPartneraPVNRegistracijasNumurs\": \"ma\",\n \"JaunsTaksacijasPeriods\": \"Ut tempor nulla non aute\",\n \"JaunsValsts\": \"non aliquip pariatur\",\n \"JaunsPVNRegistracijasNumurs\": \"comm\",\n \"JaunsSumma\": -41619742.90246975,\n \"JaunsPazime\": \"veniam nulla dolore\",\n \"JaunsDarijumaPartneraPVNRegistracijasNumurs\": \"si\"\n }\n ],\n \"Id\": -91768496,\n \"UID\": \"dolor in non elit dolor\",\n \"NmrKods\": \"vel\",\n \"Precizejums\": false,\n \"PrecizejamaisDokuments\": -25891465,\n \"PrecizejumaPamatojums\": \"ut adipisicing\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/pvn3v2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"pvn3v2",
":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/pvn3v2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"pvn3v2",
":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/pvn3v2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"pvn3v2",
":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": ""
}
]
}
