淘宝开放平台 - 文档中心

请求地址：

环境	HTTP请求地址	HTTPS请求地址
正式环境	http://gw.api.taobao.com/router/rest	https://eco.taobao.com/router/rest

公共请求参数：

名称	类型	是否必须	描述
method	String	是	API接口名称。
app_key	String	是	TOP分配给应用的AppKey。
target_app_key	String	否	被调用的目标AppKey，仅当被调用的API为第三方ISV提供时有效。
sign_method	String	是	签名的摘要算法，可选值为：hmac，md5。
sign	String	是	API输入参数签名结果，签名算法介绍请点击这里。
session	String	否	用户登录授权成功后，TOP颁发给应用的授权信息，详细介绍请点击这里。当此API的标签上注明：“需要授权”，则此参数必传；“不需要授权”，则此参数不需要传；“可选授权”，则此参数为可选。
timestamp	String	是	时间戳，格式为yyyy-MM-dd HH:mm:ss，时区为GMT+8，例如：2015-01-01 12:00:00。淘宝API服务端允许客户端请求最大时间误差为10分钟。
format	String	否	响应格式。默认为xml格式，可选值：xml，json。
v	String	是	API协议版本，可选值：2.0。
partner_id	String	否	合作伙伴身份标识。
simplify	Boolean	否	是否采用精简JSON返回格式，仅当format=json时有效，默认值为：false。

名称	类型	是否必须	示例值	描述
inst_id	Number	必须	123	探查任务实例接口
sso_ticket	String	必须	0a44ee7b1c994bea953ce186cedbb006a3415700	从登录态创建的ssoTicket
app_code	String	必须	1b7d1e7c9cd94274a04e833713a3b575	调用方的buc.app-code，注意区分日常和线上环境

名称	类型	示例值	描述
data	ExplorateResultVO		返回数据
rules ExplorationRuleVO [] 规则信息 └ subjects String "" 对象信息 └ result String "" 结果 └ rule_id Number 1 规则id └ project_id Number 4603 项目id └ inst_id Number 1 实例id └ start_time String "" 开始时间 └ end_time String "" 结束时间 └ rule_name String "" 规则名称 └ status String "" 状态 └ flags String "" 标记 └ gmt_create String "" 创建时间 └ gmt_modified String "" 修改时间 inst_vo ExplorateInstVO 实例信息 └ sql_constent String "" sql模式下的sql内容 └ table_name String "" 表名 └ partition String "" 分区partition └ data_read_mode String "" 读取模式 └ where_filter String "" 过滤条件 └ inst_id Number 1 运行实例ID └ inst_name String "" 运行实例名 └ job_id Number 1 任务ID └ job_name String "" 任务名 └ project_id Number 1 项目id └ project_name String "" 项目名 └ instance_status String "" 实例状态 └ instance_start_time String "" 实例开始时间 └ instance_end_time String "" 实例结束时间 └ run_partition String "" 运行分区 └ exec_host String "" 执行机器 └ err_msg String "" 执行错误信息 └ gmt_create String "" gmtCreate └ gmt_modified String "" gmtModified └ run_project String "" 执行的odps project └ sampling_rate Number 1 抽样率 run_user_info SimpleUser [] 执行人信息 └ emp_id String "" 工号 └ emp_name String "" 花名 command_vo_s CommandVO [] CommandVO └ command_id Number 1 执行命令的唯一标识 └ content String "" 命令的具体内容或参数 └ status String "" 命令或任务的执行状态（如成功、失败、运行中） └ job_id Number 1 任务id └ inst_id Number 1 实例id └ rule_id Number 1 规则id └ command_type String "" 命令的分类（如探查、校验、修复等） └ command_instance_id String "" 命令执行的具体实例标识 └ log_view_url String "" 用于跳转查看运行日志的 URL └ running_log String "" 命令执行过程中产生的日志内容 └ gmt_create String "" 创建时间 └ gmt_modified String "" 修改时间 └ exploration_rule String "" 具体的数据探查规则配置 └ origin String "" 请求或命令的发起来源（如页面、API、调度） └ explorate_job_id Number 1 关联的探查任务 ID（注：代码拼写为 explorate，意为 explore） └ explorate_inst_id Number 1 关联的探查运行实例 ID └ explorate_rule_id Number 1 关联的探查规则 ID └ realtime_job_id Number 1 关联的实时计算任务 ID └ realtime_inst_id Number 1 关联的实时运行实例 ID └ realtime_rule_id Number 1 关联的实时治理规则 ID └ indicator_job_id Number 1 关联的指标计算任务 ID └ indicator_inst_id Number 1 关联的指标运行实例 ID └ indicator_rule_id Number 1 关联的指标治理规则 ID
success2	Boolean	true	是否成功
error_code2	Number	0	错误码
cause	String	null	出错原因
message2	String	null	出错信息

JAVA
.NET
PHP
CURL
Python
C/C++
NodeJS

TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
AlibabaDtOnecompareExplorateResultRequest req = new AlibabaDtOnecompareExplorateResultRequest();
req.setInstId(123L);
req.setSsoTicket("0a44ee7b1c994bea953ce186cedbb006a3415700");
req.setAppCode("1b7d1e7c9cd94274a04e833713a3b575");
AlibabaDtOnecompareExplorateResultResponse rsp = client.execute(req);
System.out.println(rsp.getBody());

ITopClient client = new DefaultTopClient(url, appkey, secret);
AlibabaDtOnecompareExplorateResultRequest req = new AlibabaDtOnecompareExplorateResultRequest();
req.InstId = 123L;
req.SsoTicket = "0a44ee7b1c994bea953ce186cedbb006a3415700";
req.AppCode = "1b7d1e7c9cd94274a04e833713a3b575";
AlibabaDtOnecompareExplorateResultResponse rsp = client.Execute(req);
Console.WriteLine(rsp.Body);

$c = new TopClient;
$c->appkey = $appkey;
$c->secretKey = $secret;
$req = new AlibabaDtOnecompareExplorateResultRequest;
$req->setInstId("123");
$req->setSsoTicket("0a44ee7b1c994bea953ce186cedbb006a3415700");
$req->setAppCode("1b7d1e7c9cd94274a04e833713a3b575");
$resp = $c->execute($req);

curl -X POST 'http://gw.api.taobao.com/router/rest' \
-H 'Content-Type:application/x-www-form-urlencoded;charset=utf-8' \
-d 'app_key=12129701' \
-d 'format=json' \
-d 'method=alibaba.dt.onecompare.explorate.result' \
-d 'partner_id=apidoc' \
-d 'sign=FA19A3A8408D0C7DCAB441AEB2260D6F' \
-d 'sign_method=hmac' \
-d 'timestamp=2026-04-02+14%3A56%3A27' \
-d 'v=2.0' \
-d 'app_code=1b7d1e7c9cd94274a04e833713a3b575' \
-d 'inst_id=123' \
-d 'sso_ticket=0a44ee7b1c994bea953ce186cedbb006a3415700'

# -*- coding: utf-8 -*-
import top.api

req=top.api.AlibabaDtOnecompareExplorateResultRequest(url,port)
req.set_app_info(top.appinfo(appkey,secret))

req.inst_id=123
req.sso_ticket="0a44ee7b1c994bea953ce186cedbb006a3415700"
req.app_code="1b7d1e7c9cd94274a04e833713a3b575"
try:
	resp= req.getResponse()
	print(resp)
except Exception,e:
	print(e)

pTopRequest pRequest = alloc_top_request();
pTopResponse pResponse = NULL;
pTaobaoClient pClient = alloc_taobao_client(url, appkey, appsecret);
set_api_name(pRequest,"alibaba.dt.onecompare.explorate.result");
add_param(pRequest,"inst_id","123");
add_param(pRequest,"sso_ticket","0a44ee7b1c994bea953ce186cedbb006a3415700");
add_param(pRequest,"app_code","1b7d1e7c9cd94274a04e833713a3b575");
pResponse = top_execute(pClient,pRequest,NULL);
printf("ret code:%d\n",pResponse->code);
if(pResponse->code == 0){
	pTopResponseIterator ite = init_response_iterator(pResponse);
	pResultItem pResultItem = alloc_result_item();
	while(parseNext(ite, pResultItem) == 0){
		printf("%s:%s\n",pResultItem->key,pResultItem->value);
	}
	destroy_response_iterator(ite);
	destroy_result_item(pResultItem);
}
destroy_top_request(pRequest);
destroy_top_response(pResponse);
destroy_taobao_client(pClient);

TopClient = require('./topClient').TopClient;
var client = new TopClient({
	'appkey': 'appkey',
	'appsecret': 'secret',
	'url': 'http://gw.api.taobao.com/router/rest'
});

client.execute('alibaba.dt.onecompare.explorate.result', {
	'inst_id':'123',
	'sso_ticket':'0a44ee7b1c994bea953ce186cedbb006a3415700',
	'app_code':'1b7d1e7c9cd94274a04e833713a3b575'
}, function(error, response) {
	if (!error) console.log(response);
	else console.log(error);
})

XML示例
JSON示例

<alibaba_dt_onecompare_explorate_result_response>
    <data>
        <rules>
            <exploration_rule_v_o>
                <subjects>&quot;&quot;</subjects>
                <result>&quot;&quot;</result>
                <rule_id>1</rule_id>
                <project_id>4603</project_id>
                <inst_id>1</inst_id>
                <start_time>&quot;&quot;</start_time>
                <end_time>&quot;&quot;</end_time>
                <rule_name>&quot;&quot;</rule_name>
                <status>&quot;&quot;</status>
                <flags>&quot;&quot;</flags>
                <gmt_create>&quot;&quot;</gmt_create>
                <gmt_modified>&quot;&quot;</gmt_modified>
            </exploration_rule_v_o>
        </rules>
        <inst_vo>
            <sql_constent>&quot;&quot;</sql_constent>
            <table_name>&quot;&quot;</table_name>
            <partition>&quot;&quot;</partition>
            <data_read_mode>&quot;&quot;</data_read_mode>
            <where_filter>&quot;&quot;</where_filter>
            <inst_id>1</inst_id>
            <inst_name>&quot;&quot;</inst_name>
            <job_id>1</job_id>
            <job_name>&quot;&quot;</job_name>
            <project_id>1</project_id>
            <project_name>&quot;&quot;</project_name>
            <instance_status>&quot;&quot;</instance_status>
            <instance_start_time>&quot;&quot;</instance_start_time>
            <instance_end_time>&quot;&quot;</instance_end_time>
            <run_partition>&quot;&quot;</run_partition>
            <exec_host>&quot;&quot;</exec_host>
            <err_msg>&quot;&quot;</err_msg>
            <gmt_create>&quot;&quot;</gmt_create>
            <gmt_modified>&quot;&quot;</gmt_modified>
            <run_project>&quot;&quot;</run_project>
            <sampling_rate>1</sampling_rate>
            <run_user_info>
                <simple_user>
                    <emp_id>&quot;&quot;</emp_id>
                    <emp_name>&quot;&quot;</emp_name>
                </simple_user>
            </run_user_info>
        </inst_vo>
        <command_vo_s>
            <command_v_o>
                <command_id>1</command_id>
                <content>&quot;&quot;</content>
                <status>&quot;&quot;</status>
                <job_id>1</job_id>
                <inst_id>1</inst_id>
                <rule_id>1</rule_id>
                <command_type>&quot;&quot;</command_type>
                <command_instance_id>&quot;&quot;</command_instance_id>
                <log_view_url>&quot;&quot;</log_view_url>
                <running_log>&quot;&quot;</running_log>
                <gmt_create>&quot;&quot;</gmt_create>
                <gmt_modified>&quot;&quot;</gmt_modified>
                <exploration_rule>&quot;&quot;</exploration_rule>
                <origin>&quot;&quot;</origin>
                <explorate_job_id>1</explorate_job_id>
                <explorate_inst_id>1</explorate_inst_id>
                <explorate_rule_id>1</explorate_rule_id>
                <realtime_job_id>1</realtime_job_id>
                <realtime_inst_id>1</realtime_inst_id>
                <realtime_rule_id>1</realtime_rule_id>
                <indicator_job_id>1</indicator_job_id>
                <indicator_inst_id>1</indicator_inst_id>
                <indicator_rule_id>1</indicator_rule_id>
            </command_v_o>
        </command_vo_s>
    </data>
    <success2>true</success2>
    <error_code2>0</error_code2>
    <cause>null</cause>
    <message2>null</message2>
</alibaba_dt_onecompare_explorate_result_response>

{
    "alibaba_dt_onecompare_explorate_result_response":{
        "data":{
            "rules":{
                "exploration_rule_v_o":[
                    {
                        "subjects":"\"\"",
                        "result":"\"\"",
                        "rule_id":1,
                        "project_id":4603,
                        "inst_id":1,
                        "start_time":"\"\"",
                        "end_time":"\"\"",
                        "rule_name":"\"\"",
                        "status":"\"\"",
                        "flags":"\"\"",
                        "gmt_create":"\"\"",
                        "gmt_modified":"\"\""
                    }
                ]
            },
            "inst_vo":{
                "sql_constent":"\"\"",
                "table_name":"\"\"",
                "partition":"\"\"",
                "data_read_mode":"\"\"",
                "where_filter":"\"\"",
                "inst_id":1,
                "inst_name":"\"\"",
                "job_id":1,
                "job_name":"\"\"",
                "project_id":1,
                "project_name":"\"\"",
                "instance_status":"\"\"",
                "instance_start_time":"\"\"",
                "instance_end_time":"\"\"",
                "run_partition":"\"\"",
                "exec_host":"\"\"",
                "err_msg":"\"\"",
                "gmt_create":"\"\"",
                "gmt_modified":"\"\"",
                "run_project":"\"\"",
                "sampling_rate":1,
                "run_user_info":{
                    "simple_user":[
                        {
                            "emp_id":"\"\"",
                            "emp_name":"\"\""
                        }
                    ]
                }
            },
            "command_vo_s":{
                "command_v_o":[
                    {
                        "command_id":1,
                        "content":"\"\"",
                        "status":"\"\"",
                        "job_id":1,
                        "inst_id":1,
                        "rule_id":1,
                        "command_type":"\"\"",
                        "command_instance_id":"\"\"",
                        "log_view_url":"\"\"",
                        "running_log":"\"\"",
                        "gmt_create":"\"\"",
                        "gmt_modified":"\"\"",
                        "exploration_rule":"\"\"",
                        "origin":"\"\"",
                        "explorate_job_id":1,
                        "explorate_inst_id":1,
                        "explorate_rule_id":1,
                        "realtime_job_id":1,
                        "realtime_inst_id":1,
                        "realtime_rule_id":1,
                        "indicator_job_id":1,
                        "indicator_inst_id":1,
                        "indicator_rule_id":1
                    }
                ]
            }
        },
        "success2":true,
        "error_code2":0,
        "cause":"null",
        "message2":"null"
    }
}

XML示例
JSON示例

<error_response>
    <code>50</code>
    <msg>Remote service error</msg>
    <sub_code>isv.invalid-parameter</sub_code>
    <sub_msg>非法参数</sub_msg>
</error_response>

{
	"error_response":{
		"msg":"Remote service error",
		"code":50,
		"sub_msg":"非法参数",
		"sub_code":"isv.invalid-parameter"
	}
}

错误码	错误描述	解决方案

API测试工具错误码查询工具 SDK下载

开放平台

数据API

alibaba.dt.onecompare.explorate.result (数据探查查询结果接口)

公共参数

请求参数

响应参数

请求示例

响应示例

异常示例

错误码解释

API工具

如何获得此API

FAQ