淘宝开放平台

登录
文档中心 > API类目 > 数据API

数据API

alibaba.dt.onecompare.indicatorjob.result (指标检测任务结果)

查看指标检测实例结果

公共参数

请求参数

名称 类型 是否必须 示例值 更多限制 描述
inst_id Number 必须 999 实例id
sso_ticket String 必须 0a44ee7b1c994bea953ce186cedbb006a3415700 从登录态创建的ssoTicket
app_code String 必须 1b7d1e7c9cd94274a04e833713a3b575 调用方的buc.app-code， 注意区分日常和线上环境

响应参数

名称 类型 示例值 描述
result HsfResponse result
  • data
  • IndicatorResultVO
  • data
  • command_v_o_s
  • CommandVOS []
  • commandVOS
  • └ gmt_modified
  • String
  • 2024-01-03 11:00:22
  • gmtModified
  • └ command_type
  • String
  • ODPS|recordNum
  • commandType
  • └ log_view_url
  • String
  • http://logview.alibaba-inc.com/logview/?h=http://service.odps.aliyun-inc.com/api&p=wl_rec_test_dev&i=20240103030006550ggf0zohvs7&token=NEtCYU5GR2hxeGVxOThhU1FGMGx0d2prbU9JPSxPRFBTX09CTzoxMTM5MDcwMjYwNTgzODA4LDE3MDQ4NTU2MDYseyJTdGF0ZW1lbnQiOlt7IkFjdGlvbiI6WyJvZHBzOlJlYWQiXSwiRWZmZWN0IjoiQWxsb3ciLCJSZXNvdXJjZSI6WyJhY3M6b2RwczoqOnByb2plY3RzL3dsX3JlY190ZXN0X2Rldi9pbnN0YW5jZXMvMjAyNDAxMDMwMzAwMDY1NTBnZ2Ywem9odnM3Il19XSwiVmVyc2lvbiI6IjEifQ==
  • logViewUrl
  • └ command_instance_id
  • String
  • 20240103030006550ggf0zohvs7
  • commandInstanceId
  • └ gmt_create
  • String
  • 2024-01-03 11:00:06
  • gmtCreate
  • └ command_id
  • Number
  • 19925113
  • commandId
  • └ content
  • String
  • select count(1) from wl_rec_test.dwd_dt_moe_one_log_url_access_di where 1=1 and (ds=20240102) ;
  • content
  • └ running_log
  • String
  • select count(1) from wl_rec_test.dwd_dt_moe_one_log_url_access_di where 1=1 and (ds=20240102) ; ID: 20240103030006550ggf0zohvs7 logView: http://logview.alibaba-inc.com/logview/?h=http://service.odps.aliyun-inc.com/api&p=wl_rec_test_dev&i=20240103030006550ggf0zohvs7&token=NEtCYU5GR2hxeGVxOThhU1FGMGx0d2prbU9JPSxPRFBTX09CTzoxMTM5MDcwMjYwNTgzODA4LDE3MDQ4NTU2MDYseyJTdGF0ZW1lbnQiOlt7IkFjdGlvbiI6WyJvZHBzOlJlYWQiXSwiRWZmZWN0IjoiQWxsb3ciLCJSZXNvdXJjZSI6WyJhY3M6b2RwczoqOnByb2plY3RzL3dsX3JlY190ZXN0X2Rldi9pbnN0YW5jZXMvMjAyNDAxMDMwMzAwMDY1NTBnZ2Ywem9odnM3Il19XSwiVmVyc2lvbiI6IjEifQ== onebeyondsuccess
  • runningLog
  • └ indicator_rule_id
  • Number
  • 1
  • indicatorRuleId
  • └ status
  • String
  • SUCCESS
  • status
  • └ indicator_job_id
  • Number
  • 1
  • indicatorJobId
  • indicator_inst_result_v_o
  • IndicatorInstResultVO
  • indicatorInstResultVO
  • results
  • Results []
  • results
  • └ compare_table_name
  • String
  • test
  • compareTableName
  • └ expect_value
  • String
  • 0
  • expectValue
  • └ record_num
  • String
  • 0
  • recordNum
  • └ table_name
  • String
  • wl_rec_test.dwd_dt_moe_one_log_url_access_di
  • tableName
  • └ keyfields
  • String
  • id
  • keyfields
  • └ partition
  • String
  • ds=20240102
  • partition
  • └ rule_type
  • Number
  • 1
  • ruleType
  • └ rule_name
  • String
  • 枚举值
  • ruleName
  • └ compare_keyfields
  • String
  • id
  • compareKeyfields
  • └ start_time
  • String
  • 2024-01-03 11:00:06
  • startTime
  • └ un_expect_num
  • String
  • 0
  • unExpectNum
  • └ rule_id
  • Number
  • 129
  • ruleId
  • └ compare_partition
  • String
  • ds=20240102
  • comparePartition
  • └ unexpect_detail
  • String []
  • unexpectDetail
  • └ indicator_rule_id
  • Number
  • 5269
  • indicatorRuleId
  • └ name
  • String
  • 枚举值_app_name_包含_datapro
  • name
  • └ unexpect_col_names
  • String []
  • unexpectColNames
  • └ real_value
  • String
  • 1
  • 实际值
  • └ end_time
  • String
  • 2024-01-03 11:00:49
  • endTime
  • └ fields
  • String
  • app_name
  • fields
  • └ project_id
  • Number
  • 2997
  • projectId
  • └ status
  • String
  • SUCCESS
  • status
  • rules
  • IndicatorRuleVO []
  • rules
  • └ result
  • String
  • [{"recordNum":"0","type":0,"unexpectColNames":[],"unexpectColValues":[],"unexpectNum":"0","unpassNum":0}]
  • result
  • └ rule_name
  • String
  • 129
  • ruleName
  • └ subjects
  • String
  • {"orginInfo":{"dataFileds":["app_name"],"dataSourceType":"ODPS","defaultResultCheckType":"UNEXPECT_LESS_THAN_AND_EQUAL","defaultResultCheckValue":"0","genType":1,"id":129,"isMultiChoose":false,"isResultPercent":0,"name":"枚举值_app_name_包含_datapro","resultShowType":1,"ruleName":"枚举值","ruleType":"IN","ruleValue":"'datapro'","showType":1,"supportRuleCheckType":"IN,NOT_IN","type":1},"partition":"ds=20240102","ruleName":"枚举值_app_name_包含_datapro","tableName":"wl_rec_test.dwd_dt_moe_one_log_url_access_di"}
  • subjects
  • └ expect
  • String
  • UNEXPECT_LESS_THAN_AND_EQUAL|0
  • expect
  • └ project_id
  • Number
  • 2997
  • projectId
  • └ status
  • String
  • SUCCESS
  • status
  • inst_v_o
  • IndicatorInstVO
  • instVO
  • └ run_partition
  • String
  • 20240102000000
  • runPartition
  • run_user_info
  • RunUserInfo []
  • runUserInfo
  • └ emp_id
  • String
  • 041619
  • empId
  • └ emp_name
  • String
  • 夏冰
  • empName
  • └ err_msg
  • String
  • error
  • errMsg
  • └ run_project
  • String
  • wl_rec_test_dev
  • runProject
  • └ table_name
  • String
  • wl_rec_test.dwd_dt_moe_one_log_url_access_di
  • tableName
  • └ where_filter
  • String
  • 1=1
  • whereFilter
  • └ partition
  • String
  • (ds=20240102)
  • partition
  • └ job_name
  • String
  • 新建任务测试--周期调度
  • jobName
  • └ instance_end_time
  • String
  • 2024-01-03 11:00:49
  • instanceEndTime
  • └ exec_host
  • String
  • 33.54.40.207
  • execHost
  • └ instance_start_time
  • String
  • 2024-01-03 11:00:04
  • instanceStartTime
  • └ instance_status
  • String
  • UNPASS
  • instanceStatus
  • └ job_version
  • Number
  • 86
  • jobVersion
  • └ inst_id
  • Number
  • 1652
  • instId
  • └ job_id
  • Number
  • 290
  • jobId
  • └ inst_name
  • String
  • 新建任务测试--周期调度-20240102000000
  • instName
  • └ project_name
  • String
  • 夏冰冒烟对比项目空间
  • projectName
  • └ project_id
  • Number
  • 2997
  • projectId
  • └ success2
  • Boolean
  • true
  • success
  • └ error_code2
  • String
  • 0
  • errorCode
  • └ cause2
  • String
  • null
  • cause
  • └ message2
  • String
  • null
  • message

请求示例

  • JAVA
  • .NET
  • PHP
  • CURL
  • Python
  • C/C++
  • NodeJS
TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
AlibabaDtOnecompareIndicatorjobResultRequest req = new AlibabaDtOnecompareIndicatorjobResultRequest();
req.setInstId(999L);
req.setSsoTicket("0a44ee7b1c994bea953ce186cedbb006a3415700");
req.setAppCode("1b7d1e7c9cd94274a04e833713a3b575");
AlibabaDtOnecompareIndicatorjobResultResponse rsp = client.execute(req);
System.out.println(rsp.getBody());

响应示例

  • XML示例
  • JSON示例
<alibaba_dt_onecompare_indicatorjob_result_response>
    <result>
        <data>
            <command_v_o_s>
                <command_v_o_s>
                    <gmt_modified>2024-01-03 11:00:22</gmt_modified>
                    <command_type>ODPS|recordNum</command_type>
                    <log_view_url>http://logview.alibaba-inc.com/logview/?h=http://service.odps.aliyun-inc.com/api&amp;p=wl_rec_test_dev&amp;i=20240103030006550ggf0zohvs7&amp;token=NEtCYU5GR2hxeGVxOThhU1FGMGx0d2prbU9JPSxPRFBTX09CTzoxMTM5MDcwMjYwNTgzODA4LDE3MDQ4NTU2MDYseyJTdGF0ZW1lbnQiOlt7IkFjdGlvbiI6WyJvZHBzOlJlYWQiXSwiRWZmZWN0IjoiQWxsb3ciLCJSZXNvdXJjZSI6WyJhY3M6b2RwczoqOnByb2plY3RzL3dsX3JlY190ZXN0X2Rldi9pbnN0YW5jZXMvMjAyNDAxMDMwMzAwMDY1NTBnZ2Ywem9odnM3Il19XSwiVmVyc2lvbiI6IjEifQ==</log_view_url>
                    <command_instance_id>20240103030006550ggf0zohvs7</command_instance_id>
                    <gmt_create>2024-01-03 11:00:06</gmt_create>
                    <command_id>19925113</command_id>
                    <content>select count(1) from wl_rec_test.dwd_dt_moe_one_log_url_access_di where 1=1 and (ds=20240102) ;</content>
                    <running_log>select count(1) from wl_rec_test.dwd_dt_moe_one_log_url_access_di where 1=1 and (ds=20240102) ;
ID: 20240103030006550ggf0zohvs7

logView:
http://logview.alibaba-inc.com/logview/?h=http://service.odps.aliyun-inc.com/api&amp;p=wl_rec_test_dev&amp;i=20240103030006550ggf0zohvs7&amp;token=NEtCYU5GR2hxeGVxOThhU1FGMGx0d2prbU9JPSxPRFBTX09CTzoxMTM5MDcwMjYwNTgzODA4LDE3MDQ4NTU2MDYseyJTdGF0ZW1lbnQiOlt7IkFjdGlvbiI6WyJvZHBzOlJlYWQiXSwiRWZmZWN0IjoiQWxsb3ciLCJSZXNvdXJjZSI6WyJhY3M6b2RwczoqOnByb2plY3RzL3dsX3JlY190ZXN0X2Rldi9pbnN0YW5jZXMvMjAyNDAxMDMwMzAwMDY1NTBnZ2Ywem9odnM3Il19XSwiVmVyc2lvbiI6IjEifQ==

onebeyondsuccess</running_log>
                    <indicator_rule_id>1</indicator_rule_id>
                    <status>SUCCESS</status>
                    <indicator_job_id>1</indicator_job_id>
                </command_v_o_s>
            </command_v_o_s>
            <indicator_inst_result_v_o>
                <results>
                    <results>
                        <compare_table_name>test</compare_table_name>
                        <expect_value>0</expect_value>
                        <record_num>0</record_num>
                        <table_name>wl_rec_test.dwd_dt_moe_one_log_url_access_di</table_name>
                        <keyfields>id</keyfields>
                        <partition>ds=20240102</partition>
                        <rule_type>1</rule_type>
                        <rule_name>枚举值</rule_name>
                        <compare_keyfields>id</compare_keyfields>
                        <start_time>2024-01-03 11:00:06</start_time>
                        <un_expect_num>0</un_expect_num>
                        <rule_id>129</rule_id>
                        <compare_partition>ds=20240102</compare_partition>
                        <indicator_rule_id>5269</indicator_rule_id>
                        <name>枚举值_app_name_包含_datapro</name>
                        <real_value>1</real_value>
                        <end_time>2024-01-03 11:00:49</end_time>
                        <fields>app_name</fields>
                        <project_id>2997</project_id>
                        <status>SUCCESS</status>
                    </results>
                </results>
            </indicator_inst_result_v_o>
            <rules>
                <indicator_rule_v_o>
                    <result>[{&quot;recordNum&quot;:&quot;0&quot;,&quot;type&quot;:0,&quot;unexpectColNames&quot;:[],&quot;unexpectColValues&quot;:[],&quot;unexpectNum&quot;:&quot;0&quot;,&quot;unpassNum&quot;:0}]</result>
                    <rule_name>129</rule_name>
                    <subjects>{&quot;orginInfo&quot;:{&quot;dataFileds&quot;:[&quot;app_name&quot;],&quot;dataSourceType&quot;:&quot;ODPS&quot;,&quot;defaultResultCheckType&quot;:&quot;UNEXPECT_LESS_THAN_AND_EQUAL&quot;,&quot;defaultResultCheckValue&quot;:&quot;0&quot;,&quot;genType&quot;:1,&quot;id&quot;:129,&quot;isMultiChoose&quot;:false,&quot;isResultPercent&quot;:0,&quot;name&quot;:&quot;枚举值_app_name_包含_datapro&quot;,&quot;resultShowType&quot;:1,&quot;ruleName&quot;:&quot;枚举值&quot;,&quot;ruleType&quot;:&quot;IN&quot;,&quot;ruleValue&quot;:&quot;&apos;datapro&apos;&quot;,&quot;showType&quot;:1,&quot;supportRuleCheckType&quot;:&quot;IN,NOT_IN&quot;,&quot;type&quot;:1},&quot;partition&quot;:&quot;ds=20240102&quot;,&quot;ruleName&quot;:&quot;枚举值_app_name_包含_datapro&quot;,&quot;tableName&quot;:&quot;wl_rec_test.dwd_dt_moe_one_log_url_access_di&quot;}</subjects>
                    <expect>UNEXPECT_LESS_THAN_AND_EQUAL|0</expect>
                    <project_id>2997</project_id>
                    <status>SUCCESS</status>
                </indicator_rule_v_o>
            </rules>
            <inst_v_o>
                <run_partition>20240102000000</run_partition>
                <run_user_info>
                    <run_user_info>
                        <emp_id>041619</emp_id>
                        <emp_name>夏冰</emp_name>
                    </run_user_info>
                </run_user_info>
                <err_msg>error</err_msg>
                <run_project>wl_rec_test_dev</run_project>
                <table_name>wl_rec_test.dwd_dt_moe_one_log_url_access_di</table_name>
                <where_filter>1=1</where_filter>
                <partition>(ds=20240102)</partition>
                <job_name>新建任务测试--周期调度</job_name>
                <instance_end_time>2024-01-03 11:00:49</instance_end_time>
                <exec_host>33.54.40.207</exec_host>
                <instance_start_time>2024-01-03 11:00:04</instance_start_time>
                <instance_status>UNPASS</instance_status>
                <job_version>86</job_version>
                <inst_id>1652</inst_id>
                <job_id>290</job_id>
                <inst_name>新建任务测试--周期调度-20240102000000</inst_name>
                <project_name>夏冰冒烟对比项目空间</project_name>
                <project_id>2997</project_id>
            </inst_v_o>
        </data>
        <success2>true</success2>
        <error_code2>0</error_code2>
        <cause2>null</cause2>
        <message2>null</message2>
    </result>
</alibaba_dt_onecompare_indicatorjob_result_response>

异常示例

  • 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>

错误码解释

错误码 错误描述 解决方案

API工具

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

如何获得此API

FAQ

我要提问
返回
顶部