Obtain line record perspective data

Request

Path Params

Header Params

Body Params application/json

Example

{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "columns": [
        {
            "field": "1a2b3c4d",
            "displayName": "product category",
            "granularity": null
        },
        {
            "field": "2b3c4d5e",
            "displayName": "product name",
            "granularity": null
        },
        {
            "field": "3c4d5e6f",
            "displayName": "sales date",
            "granularity": 2
        }
    ],
    "rows": [
        {
            "field": "4d5e6f7a",
            "displayName": "countries",
            "granularity": null
        },
        {
            "field": "5e6f7a8b",
            "displayName": "areas",
            "granularity": null
        }
    ],
    "values": [
        {
            "field": "6f7a8b9c",
            "displayName": "Total Sales",
            "aggregation": "SUM"
        },
        {
            "field": "7a8b9cad",
            "displayName": "total sales amount",
            "aggregation": "SUM"
        }
    ],
    "filter": {},
    "sorts": [],
    "includeSummary": true
}

Request Code Samples

Shell

JavaScript

Java

Swift

Go

PHP

Python

HTTP

C

C#

Objective-C

Ruby

OCaml

Dart

R

curl --location --request POST 'https://api.mingdao.com/v3/app/worksheets//rows/pivot' \
--header 'HAP-Appkey: {{appkey}}' \
--header 'HAP-Sign: {{sign}}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "columns": [
        {
            "field": "1a2b3c4d",
            "displayName": "product category",
            "granularity": null
        },
        {
            "field": "2b3c4d5e",
            "displayName": "product name",
            "granularity": null
        },
        {
            "field": "3c4d5e6f",
            "displayName": "sales date",
            "granularity": 2
        }
    ],
    "rows": [
        {
            "field": "4d5e6f7a",
            "displayName": "countries",
            "granularity": null
        },
        {
            "field": "5e6f7a8b",
            "displayName": "areas",
            "granularity": null
        }
    ],
    "values": [
        {
            "field": "6f7a8b9c",
            "displayName": "Total Sales",
            "aggregation": "SUM"
        },
        {
            "field": "7a8b9cad",
            "displayName": "total sales amount",
            "aggregation": "SUM"
        }
    ],
    "filter": {},
    "sorts": [],
    "includeSummary": true
}'

Responses

🟢200OK

application/json

Body

Example

{
    "data": {
        "meta": {
            "columns": [
                {
                    "field": "1a2b3c4d",
                    "displayName": "product category",
                    "granularity": null
                },
                {
                    "field": "2b3c4d5e",
                    "displayName": "product name",
                    "granularity": null
                },
                {
                    "field": "3c4d5e6f",
                    "displayName": "sales date",
                    "granularity": 2
                }
            ],
            "rows": [
                {
                    "field": "4d5e6f7a",
                    "displayName": "countries",
                    "granularity": null
                },
                {
                    "field": "5e6f7a8b",
                    "displayName": "areas",
                    "granularity": null
                }
            ],
            "values": [
                {
                    "field": "6f7a8b9c",
                    "displayName": "Total Sales",
                    "aggregation": "SUM"
                },
                {
                    "field": "7a8b9cad",
                    "displayName": "total sales amount",
                    "aggregation": "SUM"
                }
            ]
        },
        "pivot": [
            {
                "columns": {
                    "1a2b3c4d": "electronic products",
                    "2b3c4d5e": "product A",
                    "3c4d5e6f": "2023-01"
                },
                "rows": {
                    "4d5e6f7a": "US",
                    "5e6f7a8b": "Washington"
                },
                "values": {
                    "6f7a8b9c": 5000,
                    "7a8b9cad": 500000
                }
            },
            {
                "columns": {
                    "1a2b3c4d": "electronic products",
                    "2b3c4d5e": "product B",
                    "3c4d5e6f": "2023-02"
                },
                "rows": {
                    "4d5e6f7a": "Germany",
                    "5e6f7a8b": "Munich"
                },
                "values": {
                    "6f7a8b9c": 3000,
                    "7a8b9cad": 300000
                }
            },
            {
                "columns": {
                    "1a2b3c4d": "furniture",
                    "2b3c4d5e": "product C",
                    "3c4d5e6f": "2023-03"
                },
                "rows": {
                    "4d5e6f7a": "China",
                    "5e6f7a8b": "Shenzhen"
                },
                "values": {
                    "6f7a8b9c": 2000,
                    "7a8b9cad": 100000
                }
            },
            {
                "columns": {
                    "1a2b3c4d": "furniture",
                    "2b3c4d5e": "product D",
                    "3c4d5e6f": "2023-04"
                },
                "rows": {
                    "4d5e6f7a": "Canada",
                    "5e6f7a8b": "Quebec"
                },
                "values": {
                    "6f7a8b9c": 1000,
                    "7a8b9cad": 50000
                }
            },
            {
                "columns": {
                    "1a2b3c4d": "clothing",
                    "2b3c4d5e": "product E",
                    "3c4d5e6f": "2023-05"
                },
                "rows": {
                    "4d5e6f7a": "France",
                    "5e6f7a8b": "Paris"
                },
                "values": {
                    "6f7a8b9c": 1000,
                    "7a8b9cad": 50000
                }
            }
        ],
        "summary": {
            "6f7a8b9c": 15000,
            "7a8b9cad": 1000000
        },
        "totalPages": 5,
        "currentPage": 1
    },
    "success": true
}