API Explorer

v5.1.0 (606 APIs)

Banco
Cuentas
Vistas
Contrapartes
Transacciones

Data Warehouse Search

Search the data warehouse and get row level results.

Authentication is Mandatory

CanSearchWarehouse entitlement is required. You can request the Role below.

Elastic (search) is used in the background. See links below for syntax.

Examples of usage:

POST /search/warehouse/THE_INDEX_YOU_WANT_TO_USE

POST /search/warehouse/INDEX1,INDEX2

POST /search/warehouse/ALL

{ Any valid elasticsearch query DSL in the body }

Elasticsearch query DSL

Elastic simple query

Elastic aggregations

URL Parameters:

INDEX:

JSON request body fields:

match_all:

query:

none:

JSON response body fields:

Respuesta Exitosa Típica:

								
									
{ "jsonString":"{}" }
Roles Requeridos:
  • CanSearchWarehouse - Please login to request this Role
Validaciones:
  • Required JSON Validation: No
  • Allowed Authentication Types: Not set
Posibles Errores:
  • OBP-20001: User not logged in. Authentication is required!
  • OBP-20006: User is missing one or more roles:
  • OBP-50000: Unknown Error.
Métodos de conector::
Version: OBPv3.0.0, function_name: by dataWarehouseSearch, operation_id: OBPv3.0.0-dataWarehouseSearch Tags: Data-Warehouse,

Data Warehouse Statistics

Search the data warehouse and get statistical aggregations over a warehouse field

Does a stats aggregation over some numeric field:

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-stats-aggregation.html

Authentication is Mandatory

CanSearchWarehouseStats Role is required. You can request this below.

Elastic (search) is used in the background. See links below for syntax.

Examples of usage:

POST /search/warehouse/statistics/INDEX/FIELD

POST /search/warehouse/statistics/ALL/FIELD

{ Any valid elasticsearch query DSL in the body }

Elasticsearch query DSL

Elastic simple query

Elastic aggregations

URL Parameters:

FIELD:

INDEX:

JSON request body fields:

match_all:

query:

none:

JSON response body fields:

Respuesta Exitosa Típica:

								
									
{ "jsonString":"{}" }
Roles Requeridos:
  • CanSearchWarehouseStatistics - Please login to request this Role
Validaciones:
  • Required JSON Validation: No
  • Allowed Authentication Types: Not set
Posibles Errores:
  • OBP-20001: User not logged in. Authentication is required!
  • OBP-20006: User is missing one or more roles:
  • OBP-50000: Unknown Error.
Métodos de conector::
Version: OBPv3.0.0, function_name: by dataWarehouseStatistics, operation_id: OBPv3.0.0-dataWarehouseStatistics Tags: Data-Warehouse,