Back to Collection Items
var
begin
CkHttp_putBasicAuth(http,True);CkHttp_putLogin(http,'{{secretId}}');CkHttp_putPassword(http,'{{secretPassword}}');success := CkHttp_QuickGetSb(http,'https://domain.com/api/statements/',sbResponseBody);CkJsonObject_LoadSb(jResp,sbResponseBody);CkJsonObject_putEmitCompact(jResp,False);CkJsonObject_putI(jResp,i);id := CkJsonObject__stringOf(jResp,'results[i].id');link := CkJsonObject__stringOf(jResp,'results[i].link');Id := CkJsonObject__stringOf(jResp,'results[i].account.id');Name := CkJsonObject__stringOf(jResp,'results[i].account.name');Category := CkJsonObject__stringOf(jResp,'results[i].account.category');v_Currency := CkJsonObject__stringOf(jResp,'results[i].account.currency');collected_at := CkJsonObject__stringOf(jResp,'results[i].collected_at');account_number := CkJsonObject__stringOf(jResp,'results[i].account_number');client_number := CkJsonObject__stringOf(jResp,'results[i].client_number');RFC := CkJsonObject__stringOf(jResp,'results[i].RFC');CLABE := CkJsonObject__stringOf(jResp,'results[i].CLABE');period_start_date := CkJsonObject__stringOf(jResp,'results[i].period_start_date');period_end_date := CkJsonObject__stringOf(jResp,'results[i].period_end_date');cut_date := CkJsonObject__stringOf(jResp,'results[i].cut_date');final_balance := CkJsonObject__stringOf(jResp,'results[i].final_balance');previous_balance := CkJsonObject__stringOf(jResp,'results[i].previous_balance');total_inflow_amount := CkJsonObject__stringOf(jResp,'results[i].total_inflow_amount');total_outflow_amount := CkJsonObject__stringOf(jResp,'results[i].total_outflow_amount');total_inflow_transactions := CkJsonObject__stringOf(jResp,'results[i].total_inflow_transactions');total_outflow_transactions := CkJsonObject__stringOf(jResp,'results[i].total_outflow_transactions');pdf := CkJsonObject__stringOf(jResp,'results[i].pdf');j := 0;count_j := CkJsonObject_SizeOfArray(jResp,'results[i].transactions');CkJsonObject_putJ(jResp,j);Value := CkJsonObject__stringOf(jResp,'results[i].transactions[j].collected_at.value');accounting_dateValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].accounting_date.value');value_dateValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].value_date.value');referenceValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].reference.value');observationsValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].observations.value');additional_dataValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].additional_data.value');balanceValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].balance.value');statusValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].status.value');typeValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].type.value');currencyValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].currency.value');descriptionValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].description.value');internal_identificationValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].internal_identification.value');accountValue := CkJsonObject__stringOf(jResp,'results[i].transactions[j].account.value');j := j + 1;i := i + 1;
Curl Command
curl -X GET
-u '{{secretId}}:{{secretPassword}}'
https://domain.com/api/statements/
Postman Collection Item JSON
{
"name": "List",
"request": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/statements/",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"statements",
""
]
},
"description": "Get a paginated list of all existing statements in your Belvo account. We return up to 100 results per page."
},
"response": [
{
"name": "Ok",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"url": {
"raw": "{{baseUrl}}/api/statements",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"statements"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n\t\"count\": \"<integer>\",\n\t\"next\": \"<string>\",\n\t\"previous\": \"<string>\",\n\t\"results\": [\n\t\t{\n\t\t\t\"id\": \"<uuid>\",\n\t\t\t\"link\": \"<string>\",\n\t\t\t\"account\": {\n\t\t\t\t\"id\": \"<uuid>\",\n\t\t\t\t\"name\": \"<string>\",\n\t\t\t\t\"category\": \"minim amet pariatur\",\n\t\t\t\t\"currency\": \"<string>\"\n\t\t\t},\n\t\t\t\"collected_at\": \"<dateTime>\",\n\t\t\t\"account_number\": \"<string>\",\n\t\t\t\"client_number\": \"<string>\",\n\t\t\t\"RFC\": \"<string>\",\n\t\t\t\"CLABE\": \"<string>\",\n\t\t\t\"period_start_date\": \"<date>\",\n\t\t\t\"period_end_date\": \"<date>\",\n\t\t\t\"cut_date\": \"<string>\",\n\t\t\t\"final_balance\": \"<number>\",\n\t\t\t\"previous_balance\": \"<number>\",\n\t\t\t\"total_inflow_amount\": \"<number>\",\n\t\t\t\"total_outflow_amount\": \"<number>\",\n\t\t\t\"total_inflow_transactions\": \"<number>\",\n\t\t\t\"total_outflow_transactions\": \"<number>\",\n\t\t\t\"transactions\": [\n\t\t\t\t{\n\t\t\t\t\t\"collected_at\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"accounting_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"value_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"reference\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"observations\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"additional_data\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"balance\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"status\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"type\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"currency\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"description\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"internal_identification\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"account\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t}\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"collected_at\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"accounting_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"value_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"reference\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"observations\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"additional_data\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"balance\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"status\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"type\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"currency\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"description\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"internal_identification\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"account\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"pdf\": \"<binary>\"\n\t\t},\n\t\t{\n\t\t\t\"id\": \"<uuid>\",\n\t\t\t\"link\": \"<string>\",\n\t\t\t\"account\": {\n\t\t\t\t\"id\": \"<uuid>\",\n\t\t\t\t\"name\": \"<string>\",\n\t\t\t\t\"category\": \"veniam occaecat\",\n\t\t\t\t\"currency\": \"<string>\"\n\t\t\t},\n\t\t\t\"collected_at\": \"<dateTime>\",\n\t\t\t\"account_number\": \"<string>\",\n\t\t\t\"client_number\": \"<string>\",\n\t\t\t\"RFC\": \"<string>\",\n\t\t\t\"CLABE\": \"<string>\",\n\t\t\t\"period_start_date\": \"<date>\",\n\t\t\t\"period_end_date\": \"<date>\",\n\t\t\t\"cut_date\": \"<string>\",\n\t\t\t\"final_balance\": \"<number>\",\n\t\t\t\"previous_balance\": \"<number>\",\n\t\t\t\"total_inflow_amount\": \"<number>\",\n\t\t\t\"total_outflow_amount\": \"<number>\",\n\t\t\t\"total_inflow_transactions\": \"<number>\",\n\t\t\t\"total_outflow_transactions\": \"<number>\",\n\t\t\t\"transactions\": [\n\t\t\t\t{\n\t\t\t\t\t\"collected_at\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"accounting_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"value_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"reference\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"observations\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"additional_data\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"balance\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"status\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"type\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"currency\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"description\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"internal_identification\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"account\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t}\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"collected_at\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"accounting_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"value_date\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"reference\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"observations\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"additional_data\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"balance\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"status\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"type\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"currency\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"description\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"internal_identification\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t},\n\t\t\t\t\t\"account\": {\n\t\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"pdf\": \"<binary>\"\n\t\t}\n\t]\n}"
},
{
"name": "Unauthorized",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"url": {
"raw": "{{baseUrl}}/api/statements",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"statements"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t},\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t}\n]"
}
]
}
