PowerBuilder / 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
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
integer li_LabojumaVeids
string ls_VecsTaksacijasPeriods
string ls_VecsValsts
string ls_VecsPVNRegistracijasNumurs
string ls_VecsSumma
string ls_VecsPazime
string ls_VecsDarijumaPartneraPVNRegistracijasNumurs
string ls_JaunsTaksacijasPeriods
string ls_JaunsValsts
string ls_JaunsPVNRegistracijasNumurs
string ls_JaunsSumma
string ls_JaunsPazime
string ls_JaunsDarijumaPartneraPVNRegistracijasNumurs
string ls_Epasts
string ls_Talrunis
string ls_Sagatavotajs
integer li_Id
string ls_UID
string ls_NmrKods
integer li_Precizejums
integer li_PrecizejamaisDokuments
string ls_PrecizejumaPamatojums
integer i
integer li_Count_i
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
loo_Http.SetRequestHeader("Accept","application/json")
loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")
li_Success = loo_Http.QuickGetSb("https://eds.vid.gov.lv/api/doc/pvn3v2/:id",loo_SbResponseBody)
if li_Success = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_SbResponseBody
return
end if
loo_JResp = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")
loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0
Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()
li_RespStatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
Write-Debug "Response Header:"
Write-Debug loo_Http.LastHeader
Write-Debug "Failed."
destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp
return
end if
// 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
ls_Epasts = loo_JResp.StringOf("Epasts")
ls_Talrunis = loo_JResp.StringOf("Talrunis")
ls_Sagatavotajs = loo_JResp.StringOf("Sagatavotajs")
li_Id = loo_JResp.IntOf("Id")
ls_UID = loo_JResp.StringOf("UID")
ls_NmrKods = loo_JResp.StringOf("NmrKods")
li_Precizejums = loo_JResp.BoolOf("Precizejums")
li_PrecizejamaisDokuments = loo_JResp.IntOf("PrecizejamaisDokuments")
ls_PrecizejumaPamatojums = loo_JResp.StringOf("PrecizejumaPamatojums")
i = 0
li_Count_i = loo_JResp.SizeOfArray("Tabula")
do while i < li_Count_i
loo_JResp.I = i
li_LabojumaVeids = loo_JResp.IntOf("Tabula[i].LabojumaVeids")
ls_VecsTaksacijasPeriods = loo_JResp.StringOf("Tabula[i].VecsTaksacijasPeriods")
ls_VecsValsts = loo_JResp.StringOf("Tabula[i].VecsValsts")
ls_VecsPVNRegistracijasNumurs = loo_JResp.StringOf("Tabula[i].VecsPVNRegistracijasNumurs")
ls_VecsSumma = loo_JResp.StringOf("Tabula[i].VecsSumma")
ls_VecsPazime = loo_JResp.StringOf("Tabula[i].VecsPazime")
ls_VecsDarijumaPartneraPVNRegistracijasNumurs = loo_JResp.StringOf("Tabula[i].VecsDarijumaPartneraPVNRegistracijasNumurs")
ls_JaunsTaksacijasPeriods = loo_JResp.StringOf("Tabula[i].JaunsTaksacijasPeriods")
ls_JaunsValsts = loo_JResp.StringOf("Tabula[i].JaunsValsts")
ls_JaunsPVNRegistracijasNumurs = loo_JResp.StringOf("Tabula[i].JaunsPVNRegistracijasNumurs")
ls_JaunsSumma = loo_JResp.StringOf("Tabula[i].JaunsSumma")
ls_JaunsPazime = loo_JResp.StringOf("Tabula[i].JaunsPazime")
ls_JaunsDarijumaPartneraPVNRegistracijasNumurs = loo_JResp.StringOf("Tabula[i].JaunsDarijumaPartneraPVNRegistracijasNumurs")
i = i + 1
loop
destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp
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": ""
}
]
}
