获取行记录透视数据
正式环境
https://api.mingdao.com
正式环境
https://api.mingdao.com
POST
/v3/app/worksheets/{worksheet_id}/rows/pivot
请求参数
Path 参数
Header 参数
Body 参数application/json
示例
{
"pageSize": 100,
"pageIndex": 1,
"viewId": "",
"columns": [
{
"field": "1a2b3c4d",
"displayName": "产品类别",
"granularity": null
},
{
"field": "2b3c4d5e",
"displayName": "产品名称",
"granularity": null
},
{
"field": "3c4d5e6f",
"displayName": "销售日期",
"granularity": 2
}
],
"rows": [
{
"field": "4d5e6f7a",
"displayName": "国家",
"granularity": null
},
{
"field": "5e6f7a8b",
"displayName": "地区",
"granularity": null
}
],
"values": [
{
"field": "6f7a8b9c",
"displayName": "总销售数量",
"aggregation": "SUM"
},
{
"field": "7a8b9cad",
"displayName": "总销售金额",
"aggregation": "SUM"
}
],
"filter": {},
"sorts": [],
"includeSummary": true
}请求示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
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": "产品类别",
"granularity": null
},
{
"field": "2b3c4d5e",
"displayName": "产品名称",
"granularity": null
},
{
"field": "3c4d5e6f",
"displayName": "销售日期",
"granularity": 2
}
],
"rows": [
{
"field": "4d5e6f7a",
"displayName": "国家",
"granularity": null
},
{
"field": "5e6f7a8b",
"displayName": "地区",
"granularity": null
}
],
"values": [
{
"field": "6f7a8b9c",
"displayName": "总销售数量",
"aggregation": "SUM"
},
{
"field": "7a8b9cad",
"displayName": "总销售金额",
"aggregation": "SUM"
}
],
"filter": {},
"sorts": [],
"includeSummary": true
}'返回响应
🟢200成功
application/json
Body
示例
{
"data": {
"meta": {
"columns": [
{
"field": "1a2b3c4d",
"displayName": "产品类别",
"granularity": null
},
{
"field": "2b3c4d5e",
"displayName": "产品名称",
"granularity": null
},
{
"field": "3c4d5e6f",
"displayName": "销售日期",
"granularity": 2
}
],
"rows": [
{
"field": "4d5e6f7a",
"displayName": "国家",
"granularity": null
},
{
"field": "5e6f7a8b",
"displayName": "地区",
"granularity": null
}
],
"values": [
{
"field": "6f7a8b9c",
"displayName": "总销售数量",
"aggregation": "SUM"
},
{
"field": "7a8b9cad",
"displayName": "总销售金额",
"aggregation": "SUM"
}
]
},
"pivot": [
{
"columns": {
"1a2b3c4d": "电子产品",
"2b3c4d5e": "产品A",
"3c4d5e6f": "2023-01"
},
"rows": {
"4d5e6f7a": "美国",
"5e6f7a8b": "华盛顿"
},
"values": {
"6f7a8b9c": 5000,
"7a8b9cad": 500000
}
},
{
"columns": {
"1a2b3c4d": "电子产品",
"2b3c4d5e": "产品B",
"3c4d5e6f": "2023-02"
},
"rows": {
"4d5e6f7a": "德国",
"5e6f7a8b": "慕尼黑"
},
"values": {
"6f7a8b9c": 3000,
"7a8b9cad": 300000
}
},
{
"columns": {
"1a2b3c4d": "家具",
"2b3c4d5e": "产品C",
"3c4d5e6f": "2023-03"
},
"rows": {
"4d5e6f7a": "中国",
"5e6f7a8b": "深圳"
},
"values": {
"6f7a8b9c": 2000,
"7a8b9cad": 100000
}
},
{
"columns": {
"1a2b3c4d": "家具",
"2b3c4d5e": "产品D",
"3c4d5e6f": "2023-04"
},
"rows": {
"4d5e6f7a": "加拿大",
"5e6f7a8b": "魁北克"
},
"values": {
"6f7a8b9c": 1000,
"7a8b9cad": 50000
}
},
{
"columns": {
"1a2b3c4d": "服装",
"2b3c4d5e": "产品E",
"3c4d5e6f": "2023-05"
},
"rows": {
"4d5e6f7a": "法国",
"5e6f7a8b": "巴黎"
},
"values": {
"6f7a8b9c": 1000,
"7a8b9cad": 50000
}
}
],
"summary": {
"6f7a8b9c": 15000,
"7a8b9cad": 1000000
},
"totalPages": 5,
"currentPage": 1
},
"success": true
}修改于 2025-09-05 08:23:42