- V3-beta（AI 友好）
- V2
- 数据模型
- Schemas
- options
- relation
- obj_base_response
- obj_field
- obj_filter
- obj_record_row
- obj_record_log
- obj_record_discussion
- obj_pivot_meta
- obj_pivot_dimensions
- obj_pivot_data
- obj_process
- obj_process_detail
- obj_input
- obj_output
- obj_role
- obj_role_permission
- obj_user
- obj_user_desensitized
- obj_department
- obj_custom_page
- obj_optionset
- obj_filter_children
- obj_app
- 鉴权信息
- 人员对象
- 自定义页面
- 应用角色
- 人员信息
- 统计图数值字段参数
- FilterField
- FilterTarget
- 基础返回对象
- ApiError
- DimensionField
- BatchCreateViewsRequest
- memberInfo
- DataScope
- ValueField
- ViewItem
- department_with_path
- Aggregation
- SortField
- BatchCreateViewsResponse
- departmentInfo
- TimeRange
- TimePointDynamic
- regionInfo
- ChartType
- process
- DynamicRangePoint
- process_detail
- CustomDynamicRange
- input
- CustomRange
- CreateChartResponseData
- output
- DimensionItem
- role
- MetricItem
- role_permission
- SortItem
- ButtonItem
- custom_page
- CreateChartRequest
- optionset
- CreateChartData
- ComponentConfig
- field
- CreateChartResponse
- PageComponent
- worksheet
- Position
- filter
- InlineChartConfig
- SaveCustomPageResponseData
- filter_children
- ViewConfig
- record_row
- TextConfig
- ErrorResponse
- discussion
- HtmlConfig
- CarouselConfig
- ButtonActionItem
- ButtonConfig
- TabItem
- TabConfig
- ContainerConfig
- ChartComponent
- SectionComponent
- TextComponent
- HtmlComponent
- ViewComponent
- CarouselComponent
- ButtonComponent
- TabComponent
- ContainerComponent
- SaveCustomPageComponent
- SaveCustomPageRequest
- SaveCustomPageData
- SaveCustomPageResponse
- Schemas
获取行记录透视数据
正式环境
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": "string",
"columns": [
{}
],
"rows": [
{
"field": "string",
"displayName": "string",
"granularity": 0,
"includeEmpty": false
}
],
"values": [
{
"field": "string",
"displayName": "string",
"aggregation": "COUNT",
"includeEmpty": false
}
],
"filter": {
"type": "group",
"logic": "AND",
"field": "string",
"operator": "string",
"value": null,
"children": [
{
"type": "group",
"logic": "AND",
"field": "string",
"operator": "string",
"value": null,
"children": {}
}
]
},
"sorts": [
{
"field": "string",
"isAsc": true
}
],
"includeSummary": false
}请求示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location 'https://api.mingdao.com/v3/app/worksheets//rows/pivot' \
--header 'HAP-Appkey;' \
--header 'HAP-Sign;' \
--header 'Content-Type: application/json' \
--data '{
"pageSize": 100,
"pageIndex": 1,
"viewId": "string",
"columns": [
{}
],
"rows": [
{
"field": "string",
"displayName": "string",
"granularity": 0,
"includeEmpty": false
}
],
"values": [
{
"field": "string",
"displayName": "string",
"aggregation": "COUNT",
"includeEmpty": false
}
],
"filter": {
"type": "group",
"logic": "AND",
"field": "string",
"operator": "string",
"value": null,
"children": [
{
"type": "group",
"logic": "AND",
"field": "string",
"operator": "string",
"value": null,
"children": {}
}
]
},
"sorts": [
{
"field": "string",
"isAsc": true
}
],
"includeSummary": false
}'返回响应
🟢200成功
application/json
Bodyapplication/json
示例
{
"success": true,
"error_code": 0,
"error_msg": "string",
"data": {
"meta": {
"columns": [
{}
],
"rows": [
{}
],
"values": [
{}
]
},
"pivot": [
{
"columns": {
"property1": "string",
"property2": "string"
},
"rows": {
"property1": "string",
"property2": "string"
},
"values": {
"property1": 0,
"property2": 0
}
}
],
"summary": {
"property1": 0,
"property2": 0
},
"totalPages": 0,
"currentPage": 0
}
}修改于 2026-05-18 06:18:44