有奖捉虫:办公协同&微信生态&物联网文档专题 HOT

1. 接口描述

接口请求域名: wedata.tencentcloudapi.com 。

查询质量规则列表

默认接口请求频率限制:20次/秒。

推荐使用 API Explorer
点击调试
API Explorer 提供了在线调用、签名验证、SDK 代码生成和快速检索接口等能力。您可查看每次调用的请求内容和返回结果以及自动生成 SDK 调用示例。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数,完整公共参数列表见 公共请求参数

参数名称 必选 类型 描述
Action String 公共参数,本接口取值:DescribeRules。
Version String 公共参数,本接口取值:2021-08-20。
Region String 公共参数,详见产品支持的 地域列表
ProjectId String 项目id
示例值:153161111111111111
RuleGroupId Integer 规则组id
示例值:12
EngineType String 该规则运行的执行引擎,不传时会请求该数据源下默认的执行引擎
示例值:HIVE

3. 输出参数

参数名称 类型 描述
Data Array of Rule 规则列表
注意:此字段可能返回 null,表示取不到有效值。
示例值:[ { "RuleId": 1, "RuleGroupId": 1, "TableId": "79tyugihbksda", "Name": "规则", "Type": 1, "RuleTemplateId": 1, "RuleTemplateContent": "准确性:表行数", "QualityDim": 1, "SourceObjectType": 1, "SourceObjectDataType": 1, "SourceObjectDataTypeName": "string", "SourceObjectValue": "1", "ConditionType": 1, "ConditionExpression": ">", "CustomSql": "abc", "CompareRule": { "Items": [ { "CompareType": 1, "Operator": ">", "ValueComputeType": 1, "ValueList": [ { "ValueType": 1, "Value": "1" } ] } ], "CycleStep": 1, "ComputeExpression": "0" }, "AlarmLevel": 1, "Description": "描述", "Operator": "zhangsan", "TargetDatabaseId": "easdsad-dasdas", "TargetDatabaseName": "db1", "TargetTableId": "dsadxc-dsada", "TargetTableName": "table1", "TargetConditionExpr": "0", "RelConditionExpr": "sourceTable.id = targetTable.id", "FieldConfig": { "WhereConfig": [ { "FieldKey": "name", "FieldValue": "zhangsan", "FieldDataType": "string" } ], "TableConfig": [ { "DatabaseId": "7p9gyuih78tgy", "DatabaseName": "dbTest", "TableId": "7t8ygihb670ygo", "TableName": "test", "TableKey": "asdfsdf", "FieldConfig": [ { "FieldKey": "id", "FieldValue": "12", "FieldDataType": "int" } ] } ] }, "MultiSourceFlag": true, "WhereFlag": true, "TemplateSql": "select count(*) from a", "SubQualityDim": 1, "TargetObjectType": 1, "TargetObjectDataType": 1, "TargetObjectDataTypeName": "int", "TargetObjectValue": "1", "SourceEngineTypes": [ 2 ], "TableName": "abc", "TableOwnerName": "abc", "ExecStrategy": { "RuleGroupId": 1, "MonitorType": 1, "ExecQueue": "default", "ExecutorGroupId": "2", "ExecutorGroupName": "资源组", "Tasks": [ { "WorkflowId": "32131232323", "TaskId": "321321321321", "TaskName": "shell1", "CycleType": 1 } ], "StartTime": "2023-10-01", "EndTime": "2023-10-01", "CycleType": "D", "DelayTime": 1, "CycleStep": 1, "TaskAction": "", "ExecEngineType": "HIVE", "ExecPlan": "2024-04-07 00:00:00 ~ 2099-12-31 23:59:59,每间隔10分钟执行一次", "RuleId": 1, "RuleName": "规则", "TriggerTypes": [ "2" ] }, "Subscription": { "RuleGroupId": 1, "Receivers": [ { "ReceiverOwnerUserId": 1, "ReceiverUserId": 1, "ReceiverName": "zhangsan" } ], "SubscribeType": [ 1 ], "WebHooks": [ { "HookType": "1", "HookAddress": "http://www.test.com" } ], "RuleId": 1, "RuleName": "规则1" }, "CreateTime": "2023-10-01", "DatasourceId": 1, "DatabaseId": "sddyhhjj-daskk", "MonitorStatus": 0, "TriggerCondition": "固定值 小于 2" } ]
RequestId String 唯一请求 ID,由服务端生成,每次请求都会返回(若请求因其他原因未能抵达服务端,则该次请求不会获得 RequestId)。定位问题时需要提供该次请求的 RequestId。

4. 示例

示例1 查询质量规则列表

{
"ProjectId": "abc",
"RuleGroupId": 1,
"EngineType":"HIVE"
}

输入示例

POST / HTTP/1.1
Host: wedata.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeRules
<公共请求参数>

{
    "ProjectId": "153161111111111111",
    "RuleGroupId": 1,
    "EngineType": "HIVE"
}

输出示例

{
    "Response": {
        "Data": [
            {
                "RuleId": 1,
                "RuleGroupId": 1,
                "TableId": "79tyugihbksda",
                "Name": "规则",
                "Type": 1,
                "RuleTemplateId": 1,
                "RuleTemplateContent": "准确性:表行数",
                "QualityDim": 1,
                "SourceObjectType": 1,
                "SourceObjectDataType": 1,
                "SourceObjectDataTypeName": "string",
                "SourceObjectValue": "1",
                "ConditionType": 1,
                "ConditionExpression": ">",
                "CustomSql": "abc",
                "CompareRule": {
                    "Items": [
                        {
                            "CompareType": 1,
                            "Operator": ">",
                            "ValueComputeType": 1,
                            "ValueList": [
                                {
                                    "ValueType": 1,
                                    "Value": "1"
                                }
                            ]
                        }
                    ],
                    "CycleStep": 1,
                    "ComputeExpression": "0"
                },
                "AlarmLevel": 1,
                "Description": "描述",
                "Operator": "zhangsan",
                "TargetDatabaseId": "easdsad-dasdas",
                "TargetDatabaseName": "db1",
                "TargetTableId": "dsadxc-dsada",
                "TargetTableName": "table1",
                "TargetConditionExpr": "0",
                "RelConditionExpr": "sourceTable.id = targetTable.id",
                "FieldConfig": {
                    "WhereConfig": [
                        {
                            "FieldKey": "name",
                            "FieldValue": "zhangsan",
                            "FieldDataType": "string"
                        }
                    ],
                    "TableConfig": [
                        {
                            "DatabaseId": "7p9gyuih78tgy",
                            "DatabaseName": "dbTest",
                            "TableId": "7t8ygihb670ygo",
                            "TableName": "test",
                            "TableKey": "asdfsdf",
                            "FieldConfig": [
                                {
                                    "FieldKey": "id",
                                    "FieldValue": "12",
                                    "FieldDataType": "int"
                                }
                            ]
                        }
                    ]
                },
                "MultiSourceFlag": true,
                "WhereFlag": true,
                "TemplateSql": "select count(*) from a",
                "SubQualityDim": 1,
                "TargetObjectType": 1,
                "TargetObjectDataType": 1,
                "TargetObjectDataTypeName": "int",
                "TargetObjectValue": "1",
                "SourceEngineTypes": [
                    2
                ],
                "TableName": "abc",
                "TableOwnerName": "abc",
                "ExecStrategy": {
                    "RuleGroupId": 1,
                    "MonitorType": 1,
                    "ExecQueue": "default",
                    "ExecutorGroupId": "2",
                    "ExecutorGroupName": "资源组",
                    "Tasks": [
                        {
                            "WorkflowId": "32131232323",
                            "TaskId": "321321321321",
                            "TaskName": "shell1",
                            "CycleType": 1
                        }
                    ],
                    "StartTime": "2023-10-01",
                    "EndTime": "2023-10-01",
                    "CycleType": "D",
                    "DelayTime": 1,
                    "CycleStep": 1,
                    "TaskAction": "",
                    "ExecEngineType": "HIVE",
                    "ExecPlan": "2024-04-07 00:00:00 ~ 2099-12-31 23:59:59,每间隔10分钟执行一次",
                    "RuleId": 1,
                    "RuleName": "规则",
                    "TriggerTypes": [
                        "2"
                    ]
                },
                "Subscription": {
                    "RuleGroupId": 1,
                    "Receivers": [
                        {
                            "ReceiverUserId": 1,
                            "ReceiverName": "zhangsan"
                        }
                    ],
                    "SubscribeType": [
                        1
                    ],
                    "WebHooks": [
                        {
                            "HookType": "1",
                            "HookAddress": "http://www.test.com"
                        }
                    ],
                    "RuleId": 1,
                    "RuleName": "规则1"
                },
                "CreateTime": "2023-10-01",
                "DatasourceId": 1,
                "DatabaseId": "sddyhhjj-daskk",
                "MonitorStatus": 0,
                "TriggerCondition": "固定值 小于 2"
            }
        ],
        "RequestId": "0ff4e8ab68e69"
    }
}

5. 开发者资源

腾讯云 API 平台

腾讯云 API 平台 是综合 API 文档、错误码、API Explorer 及 SDK 等资源的统一查询平台,方便您从同一入口查询及使用腾讯云提供的所有 API 服务。

API Inspector

用户可通过 API Inspector 查看控制台每一步操作关联的 API 调用情况,并自动生成各语言版本的 API 代码,也可前往 API Explorer 进行在线调试。

SDK

云 API 3.0 提供了配套的开发工具集(SDK),支持多种编程语言,能更方便的调用 API。

命令行工具

6. 错误码

以下仅列出了接口业务逻辑相关的错误码,其他错误码详见 公共错误码

错误码 描述
FailedOperation 操作失败。
UnauthorizedOperation.UserNotInProject 用户不是当前项目成员。