This topic describes the ListFullVerifyInconsistenciesResult operation provided by OceanBase Migration Service (OMS) Community Edition.
Description
This API operation is used to query the inconsistency information about the specified object.
Usage notes
Limitations
This operation is applicable to OMS Community Edition V4.1.1 and later versions.
Request path
POST /api/v2?Action=ListFullVerifyInconsistenciesResult
Request parameters
| Parameter | Type | Description |
|---|---|---|
| pageNumber | integer | The page number, which takes effect in a pagination query. |
| pageSize | integer | The page size, which takes effect in a pagination query. |
| projectId | string | The task ID. |
| schema | string | The name of the database that you want to query. |
| table | string | The name of the table that you want to query. |
Response parameters
| Parameter | Type | Description |
|---|---|---|
| success | boolean | Indicates whether the call is successful. |
| errorDetail | object | The error details. |
| code | string | The error code. |
| message | string | The description. |
| advice | string | The suggestions. |
| requestId | string | The request ID. |
| pageNumber | integer | The page number, which takes effect in a pagination query. |
| pageSize | integer | The page size, which takes effect in a pagination query. |
| totalCount | integer | The total number of pages, which takes effect in a pagination query. |
| cost | string | The amount of time spent in processing the request, in seconds. |
| data | string | The detailed inconsistency information about the specified object. For more information, see Parameters in data. |
Parameters in data
Parameter Type Description failedRecordDetails array The inconsistent columns and values of the verified object. ├─ columnName string The name of the inconsistent column. ├─ sourceValue string The column value at the source side. ├─ destValue string The column value at the destination side. failedRecordUniqueKeys array The unique keys of the verified object. ├─ columnName integer The name of the unique key column of the verified object. ├─ columnValue integer The value of the unique key column of the verified object. type string The inconsistency type of the verified object. Valid values: MASTER_ONLY,IMAGE_ONLY, andMISMATCHED.
Examples
Sample request
{
"pageNumber":1,
"pageSize":10,
"projectId":"np_4w5abs****",
"schema":"db_name",
"table":"table_name"
}
Sample response
{
"success":true,
"errorDetail":null,
"code":null,
"message":null,
"advice":null,
"requestId":"95b4e**a-4e***",
"pageNumber":1,
"pageSize":10,
"totalCount":415,
"cost":"36 ms",
"data":[
{
"failedRecordDetails":[
{
"columnName":"col_name",
"sourceValue":"source_value",
"destValue":"dest_value"
}
],
"failedRecordUniqueKeys":[
{
"columnName":"col_name",
"columnValue":"col_value"
}
],
"type":"MASTER_ONLY"
}
]
}