查询DTS校验任务结果
更新时间 2026-06-16 17:03:59
最近更新时间: 2026-06-16 17:03:59
接口功能介绍
查询 DTS 校验任务结果。
接口约束
无
URI
POST /dts/v2/open-api/instance/describeDtsCheckResult
路径参数 无
Query参数 无
请求参数
请求头header参数
| 参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|---|
| regionId | 是 | String | 资源池id | 200000001790 |
请求体body参数
| 参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|---|
| pageSize | 否 | Integer | 条数 | 20 | |
| pageNumber | 否 | Integer | 当前页码 | 1 | |
| dtsJobId | 是 | Integer | 数据校验任务id | 123456789012 | |
| name | 否 | String | 表/库名称，支持模糊查询 | test_table | |
| status | 否 | String | 校验状态：INIT, RUNNING, FINISH, FAIL, IGNORE, SKIP | FINISH |
响应参数
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| httpStatusCode | Integer | 状态码 | ||
| errCode | String | 错误码 | ||
| errMessage | String | 提示信息 | ||
| success | Boolean | 请求是否成功 | ||
| requestId | String | 请求id | ||
| data | Array of Objects | 响应数据 | CheckJobResultVO | |
| pageNumber | Integer | 页码 | ||
| pageRecordCount | Integer | 当前页可展示的最大记录数 | ||
| totalRecordCount | Integer | 记录总数 |
表 CheckJobResultVO
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| id | Integer | 检查结果id | ||
| sourceObjectName | String | 源端对象名称 | ||
| destObjectName | String | 目标端对象名称 | ||
| sourceSchemaName | String | 源端对象所属schema | ||
| destSchemaName | String | 目标端对象所属schema | ||
| sourceRows | Integer | 源端行数 | ||
| destRows | Integer | 目标端行数 | ||
| diffRows | Array of Objects | 差异行数的具体内容 | DiffRow | |
| status | String | 检查结果状态：INIT, RUNNING, FINISH, FAIL, IGNORE, SKIP | FINISH | |
| checkStatus | String | 检查状态：CONSISTENT, INCONSISTENT | INCONSISTENT | |
| errorMsg | String | 错误信息 |
表 DiffRow
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| src | Map of String | 源端数据 | ||
| dest | Map of String | 目标端数据 |
枚举参数
无
请求示例
请求url
https://{host}/dts/v2/open-api/instance/describeDtsCheckResult
请求头header
无
请求体body
{
"dtsJobId": 387,
"pageNumber": 1,
"pageSize": 100
}
响应示例
{
"httpStatusCode": 200,
"success": true,
"requestId": "00-6a16e32e23db5ea72c76fbc1c0216243-6cbe5b175f0697f7-00",
"data": [
{
"id": 21318,
"sourceObjectName": "allcolumn",
"destObjectName": "allcolumn",
"sourceSchemaName": "sync_m2m",
"destSchemaName": "sync_m2m",
"sourceRows": 10,
"destRows": 10,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21319,
"sourceObjectName": "alldbtrans_mm3",
"destObjectName": "alldbtrans_mm3",
"sourceSchemaName": "sync_m2m",
"destSchemaName": "sync_m2m",
"sourceRows": 0,
"destRows": 0,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21322,
"sourceObjectName": "tb-test",
"destObjectName": "tb-test",
"sourceSchemaName": "sync_m2m",
"destSchemaName": "sync_m2m",
"sourceRows": 5,
"destRows": 5,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21325,
"sourceObjectName": "tb_test",
"destObjectName": "tb_test",
"sourceSchemaName": "sync_m2m",
"destSchemaName": "sync_m2m",
"sourceRows": 4,
"destRows": 4,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21323,
"sourceObjectName": "all_type_struct_tran",
"destObjectName": "all_type_struct_tran",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 5,
"destRows": 5,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21316,
"sourceObjectName": "all_type_struct_tran_recode",
"destObjectName": "all_type_struct_tran_recode",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 0,
"destRows": 0,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21324,
"sourceObjectName": "partition_by_hash",
"destObjectName": "partition_by_hash",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 14,
"destRows": 14,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21320,
"sourceObjectName": "partition_by_key",
"destObjectName": "partition_by_key",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 14,
"destRows": 14,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21315,
"sourceObjectName": "partition_by_list",
"destObjectName": "partition_by_list",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 11,
"destRows": 11,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21321,
"sourceObjectName": "partition_by_range",
"destObjectName": "partition_by_range",
"sourceSchemaName": "sync_m2m_1",
"destSchemaName": "sync_m2m_1",
"sourceRows": 11,
"destRows": 11,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
},
{
"id": 21317,
"sourceObjectName": "big_user_info",
"destObjectName": "big_user_info",
"sourceSchemaName": "sync_m2m_big",
"destSchemaName": "sync_m2m_big",
"sourceRows": 10000,
"destRows": 10000,
"diffRows": [],
"status": "FINISH",
"checkStatus": "CONSISTENT",
"errorMsg": "",
"diffRowsCount": 0
}
],
"pageNumber": 1,
"pageRecordCount": 11,
"totalRecordCount": 11
}
状态码
请参考 状态码
错误码
请参考 错误码
