searchPivot

POST

/{modelName}/searchPivot

Get the pivot table data based on the specified fields, filters, orders, groupBy, splitBy.

Request

Path Params

Body Params application/json

Example

{
    "aggFunctions": [
        "SUM",
        "amount"
    ],
    "effectiveDate": "2019-08-24",
    "fields": [
        "id",
        "name"
    ],
    "filters": [
        "name",
        "=",
        "PM"
    ],
    "groupBy": [],
    "orders": [
        "name",
        "ASC"
    ],
    "pageNumber": 1,
    "pageSize": 50,
    "splitBy": [],
    "subQueries": {},
    "summary": true
}

Request samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '//searchPivot' \
--header 'Content-Type: application/json' \
--data-raw '{
    "aggFunctions": [
        "SUM",
        "amount"
    ],
    "effectiveDate": "2019-08-24",
    "fields": [
        "id",
        "name"
    ],
    "filters": [
        "name",
        "=",
        "PM"
    ],
    "groupBy": [],
    "orders": [
        "name",
        "ASC"
    ],
    "pageNumber": 1,
    "pageSize": 50,
    "splitBy": [],
    "subQueries": {},
    "summary": true
}'

Responses

🟢200OK

*/*

Body

Example

{
    "code": 0,
    "data": {
        "checksum": "string",
        "fileId": "string",
        "fileName": "string",
        "fileType": "JPG",
        "size": 0,
        "url": "string"
    },
    "message": "string"
}

Modified at 2025-04-04 11:36:48

searchPage

searchSimpleAgg