DataFlex / EDS API / Dokuments "Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai".
Back to Collection Items
Use ChilkatAx-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vSbResponseBody
Handle hoSbResponseBody
Handle hoJResp
Integer iRespStatusCode
String sIeguldSumma
String sKods
String sNINA
String sUINA
String sIeguldNos
Integer iAtlProcents
String sValue
String sKomentars
String sTaksNo
String sTaksLidz
String sEpasts
String sTalrunis
String sSagatavotajs
String sR021
String sR022
String sR023
String sR027Proc
String sR027
String sR028
String sR029Proc
String sR029
String sR031
String sR032
String sR041
String sR042
String sR043
String sR044
String sR045
String sR046
String sR047
String sR048Text
String sR048
String sR05
String sR06
String sR07
String sR081
String sR082
String sR083
Integer iId
String sUID
String sNmrKods
Boolean iPrecizejums
Integer iPrecizejamaisDokuments
String sPrecizejumaPamatojums
Integer i
Integer iCount_i
String sTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
Send ComSetRequestHeader To hoHttp "Accept" "application/json"
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComQuickGetSb Of hoHttp "https://eds.vid.gov.lv/api/doc/tnav2/:id" vSbResponseBody To iSuccess
If (iSuccess = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
If (Not(IsComObjectCreated(hoJResp))) Begin
Send CreateComObject of hoJResp
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
Set ComEmitCompact Of hoJResp To False
Showln "Response Body:"
Get ComEmit Of hoJResp To sTemp1
Showln sTemp1
Get ComLastStatus Of hoHttp To iRespStatusCode
Showln "Response Status Code = " iRespStatusCode
If (iRespStatusCode >= 400) Begin
Showln "Response Header:"
Get ComLastHeader Of hoHttp To sTemp1
Showln sTemp1
Showln "Failed."
Procedure_Return
End
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "TaksNo": "2000-01-31T00:00:00",
// "TaksLidz": "2000-01-31T00:00:00",
// "Epasts": "sed",
// "Talrunis": "Duis u",
// "Sagatavotajs": "culpa",
// "R021": 20315906.116601974,
// "R022": -61851466.616407834,
// "R023": -3784754.811457798,
// "R027Proc": -43191991.81540565,
// "R027": 81749181.92572099,
// "R028": 89221232.42839152,
// "R029Proc": 87194117.8460764,
// "R029": -2589640.38362439,
// "R031": 60624455.21640742,
// "R032": 63693008.897661984,
// "R041": 55072033.556542635,
// "R042": -74719243.59231457,
// "R043": -49153745.67511059,
// "R044": 77388360.48374161,
// "R045": 93163563.6837829,
// "R046": -11213941.923736036,
// "R047": 40192475.45927173,
// "R048Text": "quis in",
// "R048": -85044547.56044617,
// "R05": -20502042.2216855,
// "R06": 18732287.88817753,
// "R07": 44739889.77206805,
// "R081": 96001089.93872571,
// "R082": -76951175.44924127,
// "R083": 2955251.3419849128,
// "R09_Tabula": [
// {
// "IeguldSumma": 86276282.75377223,
// "Kods": "officia nostrud cillum labore"
// },
// {
// "IeguldSumma": 28942915.74151948,
// "Kods": "aliqua"
// }
// ],
// "R10_Tabula": [
// {
// "IeguldSumma": -31721504.967451915,
// "Kods": "esse culpa "
// },
// {
// "IeguldSumma": -58642566.252877384,
// "Kods": "dolore aliqua quis"
// }
// ],
// "R11_Tabula": [
// {
// "IeguldSumma": 81499190.51709351,
// "Kods": "dolor aliquip occaecat do ea"
// },
// {
// "IeguldSumma": 76755454.40086395,
// "Kods": "nostrud"
// }
// ],
// "R12_Tabula": [
// {
// "NINA": 79796877.36835039,
// "UINA": 30331571.006744444,
// "Kods": "irure in et ex",
// "IeguldSumma": 54630688.33858213
// },
// {
// "NINA": -6240697.226656616,
// "UINA": 23590322.479562834,
// "Kods": "consequat do ut",
// "IeguldSumma": 63786168.45582652
// }
// ],
// "R13_Tabula": [
// {
// "IeguldSumma": 30523200.60888873,
// "Kods": "pariatur occaecat nostrud eu"
// },
// {
// "IeguldSumma": -86174886.3759622,
// "Kods": "Lorem sunt"
// }
// ],
// "Ieguldijumi1": [
// {
// "Kods": "adipisicing deserunt nisi",
// "IeguldNos": "sit nulla irure nisi",
// "IeguldSumma": 24879133.12293549
// },
// {
// "Kods": "tempor in voluptate",
// "IeguldNos": "in incididunt Excepteur",
// "IeguldSumma": -46005550.41745236
// }
// ],
// "Ieguldijumi2": [
// {
// "Kods": "cupidatat Lorem consectetur",
// "IeguldNos": "Duis",
// "AtlProcents": 80216092,
// "IeguldSumma": 74086661.08514467
// },
// {
// "Kods": "ipsum anim amet",
// "IeguldNos": "in fugiat voluptate et eu",
// "AtlProcents": 44814656,
// "IeguldSumma": -63030813.24776003
// }
// ],
// "Pielikumi": [
// {
// "Fails": {
// "value": "<Error: Too many levels of nesting to fake this schema>"
// },
// "Komentars": "reprehenderit culpa qui sed"
// },
// {
// "Fails": {
// "value": "<Error: Too many levels of nesting to fake this schema>"
// },
// "Komentars": "sunt proident"
// }
// ],
// "Id": -54089874,
// "UID": "aliquip culpa",
// "NmrKods": "nisi ",
// "Precizejums": true,
// "PrecizejamaisDokuments": -6713016,
// "PrecizejumaPamatojums": "anim ex"
// }
// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Get ComStringOf Of hoJResp "TaksNo" To sTaksNo
Get ComStringOf Of hoJResp "TaksLidz" To sTaksLidz
Get ComStringOf Of hoJResp "Epasts" To sEpasts
Get ComStringOf Of hoJResp "Talrunis" To sTalrunis
Get ComStringOf Of hoJResp "Sagatavotajs" To sSagatavotajs
Get ComStringOf Of hoJResp "R021" To sR021
Get ComStringOf Of hoJResp "R022" To sR022
Get ComStringOf Of hoJResp "R023" To sR023
Get ComStringOf Of hoJResp "R027Proc" To sR027Proc
Get ComStringOf Of hoJResp "R027" To sR027
Get ComStringOf Of hoJResp "R028" To sR028
Get ComStringOf Of hoJResp "R029Proc" To sR029Proc
Get ComStringOf Of hoJResp "R029" To sR029
Get ComStringOf Of hoJResp "R031" To sR031
Get ComStringOf Of hoJResp "R032" To sR032
Get ComStringOf Of hoJResp "R041" To sR041
Get ComStringOf Of hoJResp "R042" To sR042
Get ComStringOf Of hoJResp "R043" To sR043
Get ComStringOf Of hoJResp "R044" To sR044
Get ComStringOf Of hoJResp "R045" To sR045
Get ComStringOf Of hoJResp "R046" To sR046
Get ComStringOf Of hoJResp "R047" To sR047
Get ComStringOf Of hoJResp "R048Text" To sR048Text
Get ComStringOf Of hoJResp "R048" To sR048
Get ComStringOf Of hoJResp "R05" To sR05
Get ComStringOf Of hoJResp "R06" To sR06
Get ComStringOf Of hoJResp "R07" To sR07
Get ComStringOf Of hoJResp "R081" To sR081
Get ComStringOf Of hoJResp "R082" To sR082
Get ComStringOf Of hoJResp "R083" To sR083
Get ComIntOf Of hoJResp "Id" To iId
Get ComStringOf Of hoJResp "UID" To sUID
Get ComStringOf Of hoJResp "NmrKods" To sNmrKods
Get ComBoolOf Of hoJResp "Precizejums" To iPrecizejums
Get ComIntOf Of hoJResp "PrecizejamaisDokuments" To iPrecizejamaisDokuments
Get ComStringOf Of hoJResp "PrecizejumaPamatojums" To sPrecizejumaPamatojums
Move 0 To i
Get ComSizeOfArray Of hoJResp "R09_Tabula" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "R09_Tabula[i].IeguldSumma" To sIeguldSumma
Get ComStringOf Of hoJResp "R09_Tabula[i].Kods" To sKods
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "R10_Tabula" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "R10_Tabula[i].IeguldSumma" To sIeguldSumma
Get ComStringOf Of hoJResp "R10_Tabula[i].Kods" To sKods
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "R11_Tabula" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "R11_Tabula[i].IeguldSumma" To sIeguldSumma
Get ComStringOf Of hoJResp "R11_Tabula[i].Kods" To sKods
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "R12_Tabula" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "R12_Tabula[i].NINA" To sNINA
Get ComStringOf Of hoJResp "R12_Tabula[i].UINA" To sUINA
Get ComStringOf Of hoJResp "R12_Tabula[i].Kods" To sKods
Get ComStringOf Of hoJResp "R12_Tabula[i].IeguldSumma" To sIeguldSumma
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "R13_Tabula" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "R13_Tabula[i].IeguldSumma" To sIeguldSumma
Get ComStringOf Of hoJResp "R13_Tabula[i].Kods" To sKods
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "Ieguldijumi1" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "Ieguldijumi1[i].Kods" To sKods
Get ComStringOf Of hoJResp "Ieguldijumi1[i].IeguldNos" To sIeguldNos
Get ComStringOf Of hoJResp "Ieguldijumi1[i].IeguldSumma" To sIeguldSumma
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "Ieguldijumi2" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "Ieguldijumi2[i].Kods" To sKods
Get ComStringOf Of hoJResp "Ieguldijumi2[i].IeguldNos" To sIeguldNos
Get ComIntOf Of hoJResp "Ieguldijumi2[i].AtlProcents" To iAtlProcents
Get ComStringOf Of hoJResp "Ieguldijumi2[i].IeguldSumma" To sIeguldSumma
Move (i + 1) To i
Loop
Move 0 To i
Get ComSizeOfArray Of hoJResp "Pielikumi" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "Pielikumi[i].Fails.value" To sValue
Get ComStringOf Of hoJResp "Pielikumi[i].Komentars" To sKomentars
Move (i + 1) To i
Loop
End_Procedure
Curl Command
curl -X GET
-H "Accept: application/json"
https://eds.vid.gov.lv/api/doc/tnav2/:id
Postman Collection Item JSON
{
"name": "Dokuments \"Pārskats par tiešo nodokļu atlaidēm un atbalstu ieguldījumu veikšanai\".",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":id"
],
"variable": [
{
"key": "id",
"value": "25210683",
"description": "(Required) Dokumenta id."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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 \"TaksNo\": \"2000-01-31T00:00:00\",\n \"TaksLidz\": \"2000-01-31T00:00:00\",\n \"Epasts\": \"sed\",\n \"Talrunis\": \"Duis u\",\n \"Sagatavotajs\": \"culpa\",\n \"R021\": 20315906.116601974,\n \"R022\": -61851466.616407834,\n \"R023\": -3784754.811457798,\n \"R027Proc\": -43191991.81540565,\n \"R027\": 81749181.92572099,\n \"R028\": 89221232.42839152,\n \"R029Proc\": 87194117.8460764,\n \"R029\": -2589640.38362439,\n \"R031\": 60624455.21640742,\n \"R032\": 63693008.897661984,\n \"R041\": 55072033.556542635,\n \"R042\": -74719243.59231457,\n \"R043\": -49153745.67511059,\n \"R044\": 77388360.48374161,\n \"R045\": 93163563.6837829,\n \"R046\": -11213941.923736036,\n \"R047\": 40192475.45927173,\n \"R048Text\": \"quis in\",\n \"R048\": -85044547.56044617,\n \"R05\": -20502042.2216855,\n \"R06\": 18732287.88817753,\n \"R07\": 44739889.77206805,\n \"R081\": 96001089.93872571,\n \"R082\": -76951175.44924127,\n \"R083\": 2955251.3419849128,\n \"R09_Tabula\": [\n {\n \"IeguldSumma\": 86276282.75377223,\n \"Kods\": \"officia nostrud cillum labore\"\n },\n {\n \"IeguldSumma\": 28942915.74151948,\n \"Kods\": \"aliqua\"\n }\n ],\n \"R10_Tabula\": [\n {\n \"IeguldSumma\": -31721504.967451915,\n \"Kods\": \"esse culpa \"\n },\n {\n \"IeguldSumma\": -58642566.252877384,\n \"Kods\": \"dolore aliqua quis\"\n }\n ],\n \"R11_Tabula\": [\n {\n \"IeguldSumma\": 81499190.51709351,\n \"Kods\": \"dolor aliquip occaecat do ea\"\n },\n {\n \"IeguldSumma\": 76755454.40086395,\n \"Kods\": \"nostrud\"\n }\n ],\n \"R12_Tabula\": [\n {\n \"NINA\": 79796877.36835039,\n \"UINA\": 30331571.006744444,\n \"Kods\": \"irure in et ex\",\n \"IeguldSumma\": 54630688.33858213\n },\n {\n \"NINA\": -6240697.226656616,\n \"UINA\": 23590322.479562834,\n \"Kods\": \"consequat do ut\",\n \"IeguldSumma\": 63786168.45582652\n }\n ],\n \"R13_Tabula\": [\n {\n \"IeguldSumma\": 30523200.60888873,\n \"Kods\": \"pariatur occaecat nostrud eu\"\n },\n {\n \"IeguldSumma\": -86174886.3759622,\n \"Kods\": \"Lorem sunt\"\n }\n ],\n \"Ieguldijumi1\": [\n {\n \"Kods\": \"adipisicing deserunt nisi\",\n \"IeguldNos\": \"sit nulla irure nisi\",\n \"IeguldSumma\": 24879133.12293549\n },\n {\n \"Kods\": \"tempor in voluptate\",\n \"IeguldNos\": \"in incididunt Excepteur\",\n \"IeguldSumma\": -46005550.41745236\n }\n ],\n \"Ieguldijumi2\": [\n {\n \"Kods\": \"cupidatat Lorem consectetur\",\n \"IeguldNos\": \"Duis\",\n \"AtlProcents\": 80216092,\n \"IeguldSumma\": 74086661.08514467\n },\n {\n \"Kods\": \"ipsum anim amet\",\n \"IeguldNos\": \"in fugiat voluptate et eu\",\n \"AtlProcents\": 44814656,\n \"IeguldSumma\": -63030813.24776003\n }\n ],\n \"Pielikumi\": [\n {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": \"reprehenderit culpa qui sed\"\n },\n {\n \"Fails\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Komentars\": \"sunt proident\"\n }\n ],\n \"Id\": -54089874,\n \"UID\": \"aliquip culpa\",\n \"NmrKods\": \"nisi \",\n \"Precizejums\": true,\n \"PrecizejamaisDokuments\": -6713016,\n \"PrecizejumaPamatojums\": \"anim ex\"\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/doc/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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/tnav2/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"doc",
"tnav2",
":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": ""
}
]
}