PEPPERI NOTIFICATION SERVICE
Actions Queue
CPI Node

Get totals

  • Support dot annotation only!

Supported aggregation:

  • Sum

  • Avg

  • Min

  • Max

  • Count

Aggregation format - as sql: sum(apiName1), avg(apiName2) ...

get
Get Totals

https://papi.pepperi.com/v1.0/elasticsearch/totals/{type}?select={aggregationsAndApiNames}&where={WhereClause}&group_by={groupBy}
This endpoint allows to get data on ElasticSearch.
Request
Response
Request
Headers
Authentication
required
string
Bearer authentication token
Query Parameters
type
required
string
all_activities/transaction_lines
Response
200: OK
example of response for: select=min(ItemPrice),max(ItemPrice), group_by=ItemMainCategory
[
{
"min_ItemPrice": 15.00,
"max_ItemPrice": 4099.99,
"ItemMainCategory": "Apple"
},
{
"min_ItemPrice": 109.99,
"max_ItemPrice": 1600.00,
"ItemMainCategory": "LG"
},
{
"min_ItemPrice": 290.00,
"max_ItemPrice": 2299.99,
"ItemMainCategory": "Samsung"
},
.
.
.
]
400: Bad Request
{
"erroeMessage": "..."
}

‚Äč