VB6 / 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
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
Dim success As Long
http.SetRequestHeader "Accept","application/json"
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://eds.vid.gov.lv/api/doc/pvn3v2/:id",sbResponseBody)
If (success = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0
Debug.Print "Response Body:"
Debug.Print jResp.Emit()
Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print http.LastHeader
Debug.Print "Failed."
Exit Sub
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
Dim LabojumaVeids As Long
Dim VecsTaksacijasPeriods As String
Dim VecsValsts As String
Dim VecsPVNRegistracijasNumurs As String
Dim VecsSumma As String
Dim VecsPazime As String
Dim VecsDarijumaPartneraPVNRegistracijasNumurs As String
Dim JaunsTaksacijasPeriods As String
Dim JaunsValsts As String
Dim JaunsPVNRegistracijasNumurs As String
Dim JaunsSumma As String
Dim JaunsPazime As String
Dim JaunsDarijumaPartneraPVNRegistracijasNumurs As String
Dim Epasts As String
Epasts = jResp.StringOf("Epasts")
Dim Talrunis As String
Talrunis = jResp.StringOf("Talrunis")
Dim Sagatavotajs As String
Sagatavotajs = jResp.StringOf("Sagatavotajs")
Dim Id As Long
Id = jResp.IntOf("Id")
Dim UID As String
UID = jResp.StringOf("UID")
Dim NmrKods As String
NmrKods = jResp.StringOf("NmrKods")
Dim Precizejums As Long
Precizejums = jResp.BoolOf("Precizejums")
Dim PrecizejamaisDokuments As Long
PrecizejamaisDokuments = jResp.IntOf("PrecizejamaisDokuments")
Dim PrecizejumaPamatojums As String
PrecizejumaPamatojums = jResp.StringOf("PrecizejumaPamatojums")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("Tabula")
Do While i < count_i
jResp.I = i
LabojumaVeids = jResp.IntOf("Tabula[i].LabojumaVeids")
VecsTaksacijasPeriods = jResp.StringOf("Tabula[i].VecsTaksacijasPeriods")
VecsValsts = jResp.StringOf("Tabula[i].VecsValsts")
VecsPVNRegistracijasNumurs = jResp.StringOf("Tabula[i].VecsPVNRegistracijasNumurs")
VecsSumma = jResp.StringOf("Tabula[i].VecsSumma")
VecsPazime = jResp.StringOf("Tabula[i].VecsPazime")
VecsDarijumaPartneraPVNRegistracijasNumurs = jResp.StringOf("Tabula[i].VecsDarijumaPartneraPVNRegistracijasNumurs")
JaunsTaksacijasPeriods = jResp.StringOf("Tabula[i].JaunsTaksacijasPeriods")
JaunsValsts = jResp.StringOf("Tabula[i].JaunsValsts")
JaunsPVNRegistracijasNumurs = jResp.StringOf("Tabula[i].JaunsPVNRegistracijasNumurs")
JaunsSumma = jResp.StringOf("Tabula[i].JaunsSumma")
JaunsPazime = jResp.StringOf("Tabula[i].JaunsPazime")
JaunsDarijumaPartneraPVNRegistracijasNumurs = jResp.StringOf("Tabula[i].JaunsDarijumaPartneraPVNRegistracijasNumurs")
i = i + 1
Loop
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": ""
}
]
}
