This topic describes the ListFullVerifyCorrectionsResult operation provided by OceanBase Migration Service (OMS) Community Edition.
Description
This API operation is used to query the SQL statements used for revision based on the full verification results of 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=ListFullVerifyCorrectionsResult
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 SQL statements for revision. |
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":[
"sql"
]
}