Powershell / EDS API / Transakciju pārskats (no 01.01.2021).
Back to Collection Items
Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"
# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
$http = New-Object Chilkat.Http
$queryParams = New-Object Chilkat.JsonObject
$queryParams.UpdateString("periodsNo","nisi cillum sed")
$queryParams.UpdateString("periodsLidz","nisi cillum sed")
$queryParams.UpdateString("saistibasDokumentaNr","qui sed")
$queryParams.UpdateString("maksajumaUzdevumaNr","qui sed")
$queryParams.UpdateInt("izlaistIerakstus",25210683)
$queryParams.UpdateInt("atgrieztIerakstus",25210683)
$http.SetRequestHeader("Accept","application/json")
$resp = $http.QuickRequestParams("GET","https://eds.vid.gov.lv/api/reports/paymenttransactions",$queryParams)
if ($http.LastMethodSuccess -eq $false) {
$($http.LastErrorText)
exit
}
$sbResponseBody = New-Object Chilkat.StringBuilder
$resp.GetBodySb($sbResponseBody)
$jResp = New-Object Chilkat.JsonObject
$jResp.LoadSb($sbResponseBody)
$jResp.EmitCompact = $false
$("Response Body:")
$($jResp.Emit())
$respStatusCode = $resp.StatusCode
$("Response Status Code = " + $respStatusCode)
if ($respStatusCode -ge 400) {
$("Response Header:")
$($resp.Header)
$("Failed.")
exit
}
# Sample JSON response:
# (Sample code for parsing the JSON response is shown below)
# {
# "Transakcijas": [
# {
# "Datums": "2000-01-31T00:00:00",
# "SaistibasDokumentaNr": "occaec",
# "Aprekins": "deserunt consequat laborum officia",
# "AprekinaPamatojums": "ut et exercitation",
# "SaistibasVeids": "ea enim aliquip do ullamco",
# "IenemumuVeids": "ut eu exercitation",
# "BudzetaKlasifikacijasKods": "exercitation anim",
# "SummasVeids": "sit ullamco irure",
# "Summa": 24341259.51378028,
# "MaksajumaUzdevumaNr": "veniam quis incididun",
# "SaistitaDokumentaNr": "sit cupidatat dolor fugiat",
# "Info": "ea quis",
# "PeriodsNo": "2000-01-31T00:00:00",
# "PeriodsLidz": "2000-01-31T00:00:00"
# },
# {
# "Datums": "2000-01-31T00:00:00",
# "SaistibasDokumentaNr": "dolore proident sed",
# "Aprekins": "minim sint non",
# "AprekinaPamatojums": "Lorem minim id",
# "SaistibasVeids": "commodo velit et",
# "IenemumuVeids": "est sint",
# "BudzetaKlasifikacijasKods": "elit minim proident",
# "SummasVeids": "in qui",
# "Summa": -45694443.17825795,
# "MaksajumaUzdevumaNr": "tempor officia",
# "SaistitaDokumentaNr": "ipsum",
# "Info": "nulla ad",
# "PeriodsNo": "2000-01-31T00:00:00",
# "PeriodsLidz": "2000-01-31T00:00:00"
# }
# ]
# }
# Sample code for parsing the JSON response...
# Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
$i = 0
$count_i = $jResp.SizeOfArray("Transakcijas")
while ($i -lt $count_i) {
$jResp.I = $i
$Datums = $jResp.StringOf("Transakcijas[i].Datums")
$SaistibasDokumentaNr = $jResp.StringOf("Transakcijas[i].SaistibasDokumentaNr")
$Aprekins = $jResp.StringOf("Transakcijas[i].Aprekins")
$AprekinaPamatojums = $jResp.StringOf("Transakcijas[i].AprekinaPamatojums")
$SaistibasVeids = $jResp.StringOf("Transakcijas[i].SaistibasVeids")
$IenemumuVeids = $jResp.StringOf("Transakcijas[i].IenemumuVeids")
$BudzetaKlasifikacijasKods = $jResp.StringOf("Transakcijas[i].BudzetaKlasifikacijasKods")
$SummasVeids = $jResp.StringOf("Transakcijas[i].SummasVeids")
$Summa = $jResp.StringOf("Transakcijas[i].Summa")
$MaksajumaUzdevumaNr = $jResp.StringOf("Transakcijas[i].MaksajumaUzdevumaNr")
$SaistitaDokumentaNr = $jResp.StringOf("Transakcijas[i].SaistitaDokumentaNr")
$Info = $jResp.StringOf("Transakcijas[i].Info")
$PeriodsNo = $jResp.StringOf("Transakcijas[i].PeriodsNo")
$PeriodsLidz = $jResp.StringOf("Transakcijas[i].PeriodsLidz")
$i = $i + 1
}
Curl Command
curl -G -d "periodsNo=nisi%20cillum%20sed"
-d "periodsLidz=nisi%20cillum%20sed"
-d "saistibasDokumentaNr=qui%20sed"
-d "maksajumaUzdevumaNr=qui%20sed"
-d "izlaistIerakstus=25210683"
-d "atgrieztIerakstus=25210683"
-H "Accept: application/json"
https://eds.vid.gov.lv/api/reports/paymenttransactions
Postman Collection Item JSON
{
"name": "Transakciju pārskats (no 01.01.2021).",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/reports/paymenttransactions?periodsNo=nisi cillum sed&periodsLidz=nisi cillum sed&saistibasDokumentaNr=qui sed&maksajumaUzdevumaNr=qui sed&izlaistIerakstus=25210683&atgrieztIerakstus=25210683",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"reports",
"paymenttransactions"
],
"query": [
{
"key": "periodsNo",
"value": "nisi cillum sed",
"description": "(Required) Periods no."
},
{
"key": "periodsLidz",
"value": "nisi cillum sed",
"description": "(Required) Periods līdz."
},
{
"key": "saistibasDokumentaNr",
"value": "qui sed",
"description": "Saistības dokumenta Nr."
},
{
"key": "maksajumaUzdevumaNr",
"value": "qui sed",
"description": "Maksājuma uzdevuma Nr."
},
{
"key": "izlaistIerakstus",
"value": "25210683",
"description": "(Required) No rezultāta izlaižamo ierakstu skaits."
},
{
"key": "atgrieztIerakstus",
"value": "25210683",
"description": "(Required) Atgriežamo ierakstu skaits."
}
]
}
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/reports/paymenttransactions?periodsNo=nisi cillum sed&periodsLidz=nisi cillum sed&saistibasDokumentaNr=qui sed&maksajumaUzdevumaNr=qui sed&izlaistIerakstus=25210683&atgrieztIerakstus=25210683",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"reports",
"paymenttransactions"
],
"query": [
{
"key": "periodsNo",
"value": "nisi cillum sed"
},
{
"key": "periodsLidz",
"value": "nisi cillum sed"
},
{
"key": "saistibasDokumentaNr",
"value": "qui sed"
},
{
"key": "maksajumaUzdevumaNr",
"value": "qui sed"
},
{
"key": "izlaistIerakstus",
"value": "25210683"
},
{
"key": "atgrieztIerakstus",
"value": "25210683"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"Transakcijas\": [\n {\n \"Datums\": \"2000-01-31T00:00:00\",\n \"SaistibasDokumentaNr\": \"occaec\",\n \"Aprekins\": \"deserunt consequat laborum officia\",\n \"AprekinaPamatojums\": \"ut et exercitation\",\n \"SaistibasVeids\": \"ea enim aliquip do ullamco\",\n \"IenemumuVeids\": \"ut eu exercitation\",\n \"BudzetaKlasifikacijasKods\": \"exercitation anim\",\n \"SummasVeids\": \"sit ullamco irure\",\n \"Summa\": 24341259.51378028,\n \"MaksajumaUzdevumaNr\": \"veniam quis incididun\",\n \"SaistitaDokumentaNr\": \"sit cupidatat dolor fugiat\",\n \"Info\": \"ea quis\",\n \"PeriodsNo\": \"2000-01-31T00:00:00\",\n \"PeriodsLidz\": \"2000-01-31T00:00:00\"\n },\n {\n \"Datums\": \"2000-01-31T00:00:00\",\n \"SaistibasDokumentaNr\": \"dolore proident sed\",\n \"Aprekins\": \"minim sint non\",\n \"AprekinaPamatojums\": \"Lorem minim id\",\n \"SaistibasVeids\": \"commodo velit et\",\n \"IenemumuVeids\": \"est sint\",\n \"BudzetaKlasifikacijasKods\": \"elit minim proident\",\n \"SummasVeids\": \"in qui\",\n \"Summa\": -45694443.17825795,\n \"MaksajumaUzdevumaNr\": \"tempor officia\",\n \"SaistitaDokumentaNr\": \"ipsum\",\n \"Info\": \"nulla ad\",\n \"PeriodsNo\": \"2000-01-31T00:00:00\",\n \"PeriodsLidz\": \"2000-01-31T00:00:00\"\n }\n ]\n}"
},
{
"name": "Lietotājs nav autentificēts.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/reports/paymenttransactions?periodsNo=nisi cillum sed&periodsLidz=nisi cillum sed&saistibasDokumentaNr=qui sed&maksajumaUzdevumaNr=qui sed&izlaistIerakstus=25210683&atgrieztIerakstus=25210683",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"reports",
"paymenttransactions"
],
"query": [
{
"key": "periodsNo",
"value": "nisi cillum sed"
},
{
"key": "periodsLidz",
"value": "nisi cillum sed"
},
{
"key": "saistibasDokumentaNr",
"value": "qui sed"
},
{
"key": "maksajumaUzdevumaNr",
"value": "qui sed"
},
{
"key": "izlaistIerakstus",
"value": "25210683"
},
{
"key": "atgrieztIerakstus",
"value": "25210683"
}
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Lietotājam nav tiesību veikt šo darbību.",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/reports/paymenttransactions?periodsNo=nisi cillum sed&periodsLidz=nisi cillum sed&saistibasDokumentaNr=qui sed&maksajumaUzdevumaNr=qui sed&izlaistIerakstus=25210683&atgrieztIerakstus=25210683",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"reports",
"paymenttransactions"
],
"query": [
{
"key": "periodsNo",
"value": "nisi cillum sed"
},
{
"key": "periodsLidz",
"value": "nisi cillum sed"
},
{
"key": "saistibasDokumentaNr",
"value": "qui sed"
},
{
"key": "maksajumaUzdevumaNr",
"value": "qui sed"
},
{
"key": "izlaistIerakstus",
"value": "25210683"
},
{
"key": "atgrieztIerakstus",
"value": "25210683"
}
]
}
},
"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/reports/paymenttransactions?periodsNo=nisi cillum sed&periodsLidz=nisi cillum sed&saistibasDokumentaNr=qui sed&maksajumaUzdevumaNr=qui sed&izlaistIerakstus=25210683&atgrieztIerakstus=25210683",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"reports",
"paymenttransactions"
],
"query": [
{
"key": "periodsNo",
"value": "nisi cillum sed"
},
{
"key": "periodsLidz",
"value": "nisi cillum sed"
},
{
"key": "saistibasDokumentaNr",
"value": "qui sed"
},
{
"key": "maksajumaUzdevumaNr",
"value": "qui sed"
},
{
"key": "izlaistIerakstus",
"value": "25210683"
},
{
"key": "atgrieztIerakstus",
"value": "25210683"
}
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
}
]
}
