VBScript / EDS API / Transakciju pārskats (no 01.01.2021).
Back to Collection Items
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
set http = CreateObject("Chilkat_9_5_0.Http")
set queryParams = CreateObject("Chilkat_9_5_0.JsonObject")
success = queryParams.UpdateString("periodsNo","nisi cillum sed")
success = queryParams.UpdateString("periodsLidz","nisi cillum sed")
success = queryParams.UpdateString("saistibasDokumentaNr","qui sed")
success = queryParams.UpdateString("maksajumaUzdevumaNr","qui sed")
success = queryParams.UpdateInt("izlaistIerakstus",25210683)
success = queryParams.UpdateInt("atgrieztIerakstus",25210683)
http.SetRequestHeader "Accept","application/json"
' resp is a Chilkat_9_5_0.HttpResponse
Set resp = http.QuickRequestParams("GET","https://eds.vid.gov.lv/api/reports/paymenttransactions",queryParams)
If (http.LastMethodSuccess = 0) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = resp.GetBodySb(sbResponseBody)
set jResp = CreateObject("Chilkat_9_5_0.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0
outFile.WriteLine("Response Body:")
outFile.WriteLine(jResp.Emit())
respStatusCode = resp.StatusCode
outFile.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
outFile.WriteLine("Response Header:")
outFile.WriteLine(resp.Header)
outFile.WriteLine("Failed.")
WScript.Quit
End If
' 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")
Do While i < 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
Loop
outFile.Close
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": ""
}
]
}
