right logo image
right logo image
Log on
⯆

API Explorer

Log off

v5.1.0 (592 APIs)

API Host: https://obp-apisandbox.joinfincubator.com
Bank
Accounts
Views
Counterparties
Transactions

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:

Typical Successful Response: 

								
									
{
  "jsonString":"{}"
}
Required Roles:
  • CanSearchWarehouse - Please login to request this Role
Validations:
  • Required JSON Validation: No
  • Allowed Authentication Types: Not set
Possible Errors:
  • OBP-20001: User not logged in. Authentication is required!
  • OBP-20006: User is missing one or more roles:
  • OBP-50000: Unknown Error.
Connector Methods:
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:

Typical Successful Response: 

								
									
{
  "jsonString":"{}"
}
Required Roles:
  • CanSearchWarehouseStatistics - Please login to request this Role
Validations:
  • Required JSON Validation: No
  • Allowed Authentication Types: Not set
Possible Errors:
  • OBP-20001: User not logged in. Authentication is required!
  • OBP-20006: User is missing one or more roles:
  • OBP-50000: Unknown Error.
Connector Methods:
Version: OBPv3.0.0, function_name: by dataWarehouseStatistics, operation_id: OBPv3.0.0-dataWarehouseStatistics Tags: Data-Warehouse,