通过仪表图表id获取数据定义&数据

生产环境

https://app91651.eapps.dingtalkcloud.com/datart

POST

/api/v1/open/api/execute

scope: datart:view:execute

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Header 参数

Body 参数application/json

示例

{
    "corpId": "ding4c7c311a701851ac35c2f4657eb6378f",
    "dashboardId": "5064d6313fb84b61beb793bd08e6afc0",
    "widgetId": "8f966bdad40644909abaddb43b769f0c",
    "filterBodyList": [
        {
            "fieldId": "dwd_salary_attr___empid",
            "sqlOperator": "EQ",
            "values": [
                {
                    "valueType": "STRING",
                    "value": "emp_e7a47248576f44aeb10c4e242192f635"
                }
            ]
        }
    ]
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location 'https://app91651.eapps.dingtalkcloud.com/datart/api/v1/open/api/execute' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
    "corpId": "ding4c7c311a701851ac35c2f4657eb6378f",
    "dashboardId": "5064d6313fb84b61beb793bd08e6afc0",
    "widgetId": "8f966bdad40644909abaddb43b769f0c",
    "filterBodyList": [
        {
            "fieldId": "dwd_salary_attr___empid",
            "sqlOperator": "EQ",
            "values": [
                {
                    "valueType": "STRING",
                    "value": "emp_e7a47248576f44aeb10c4e242192f635"
                }
            ]
        }
    ]
}'

返回响应

🟢200通过视图id获取数据-Example

application/json

Bodyapplication/json

示例

{
    "data": {
        "columns": [
            {
                "name": [
                    ""
                ],
                /**
                 * STRING :STRING
                 * NUMERIC :NUMERIC
                 * DATE :DATE
                 * BOOLEAN :BOOLEAN
                 * IDENTIFIER :IDENTIFIER
                 * FRAGMENT :FRAGMENT
                 * SNIPPET :SNIPPET
                 * KEYWORD :KEYWORD
                 * JSON :JSON
                 */
                "type": "",
                "fmt": "",
                "alias": {
                    "name": ""
                },
                "foreignKeys": [
                    {
                        "database": "",
                        "table": "",
                        "column": ""
                    }
                ],
                "calc": {
                    "key": "",
                    "type": "",
                    "config": {}
                },
                "cryptFlag": false
            }
        ],
        "rows": [
            [
                {}
            ]
        ]
    },
    "success": false,
    "errorCode": "",
    "errorMsg": ""
}

修改于 2024-11-06 11:35:06

通过仪表盘获取视图id

查询人员子集字段信息