Queries the databases that are involved in the precheck of a data change ticket.
For more information about the Normal Data Modify feature, see Change regular data.
Debugging
Request parameters
| Parameter | Type | Required | Example | Description |
|---|---|---|---|---|
| Action | String | Yes | ListDataCorrectPreCheckDB |
The operation that you want to perform. Set the value to ListDataCorrectPreCheckDB. |
| OrderId | Long | Yes | 432**** |
The ID of the ticket for the data change. |
| PageNumber | Long | No | 1 |
The number of the page to return. Valid values: an integer that is greater than 0. Default value: 1. |
| PageSize | Long | No | 20 |
The number of entries to return on each page. |
| Tid | Long | No | 4321**** |
The ID of the tenant. You can call the GetUserActiveTenant or ListUserTenants operation to query the ID of the tenant. |
| RegionId | String | No | cn-hangzhou |
The ID of the region where DMS is activated. For more information about the valid values of the parameter, see RegionID parameter. Note Set this parameter to the ID of the region that is close to your service.
|
Response parameters
| Parameter | Type | Example | Description |
|---|---|---|---|
| RequestId | String | 95A972AF-FAED-4768-9360-7C0DF5D594D0 |
The ID of the request. |
| Success | Boolean | true |
Indicates whether the request is successful. |
| ErrorMessage | String | UnknownError |
The error message returned. |
| ErrorCode | String | UnknownError |
The error code returned. |
| PreCheckDBList | Array of PreCheckDB |
The information about the databases that are involved in the precheck. |
|
| DbId | Long | 43*** |
The ID of the database. |
| SearchName | String | test@localhost:3306 |
The name of the database. |
| SqlNum | Long | 1 |
The number of SQL statements. |
Examples
Sample requests
http(s)://dms-enterprise.aliyuncs.com/?Action=ListDataCorrectPreCheckDB
&OrderId=4325325
&PageNumber=1
&PageSize=20
&Tid=43214324
&<Common request parameters>Sample success responses
XML format
HTTP/1.1 200 OK
Content-Type:application/xml
<ListDataCorrectPreCheckDBResponse>
<RequestId>A793B353-2D13-47A3-AF45-53798FBD864F</RequestId>
<PreCheckDBList>
<SqlNum>1</SqlNum>
<SearchName>poc_dev@rm-uf61****1w0926d66.mysql.rds.aliyuncs.com:3306[poc_dev]</SearchName>
<DbId>8050000</DbId>
</PreCheckDBList>
<Success>true</Success>
</ListDataCorrectPreCheckDBResponse>JSON format
HTTP/1.1 200 OK
Content-Type:application/json
{
"RequestId" : "A793B353-2D13-47A3-AF45-53798FBD864F",
"PreCheckDBList" : [ {
"SqlNum" : 1,
"SearchName" : "poc_dev@rm-uf61****1w0926d66.mysql.rds.aliyuncs.com:3306[poc_dev]",
"DbId" : 8050000
} ],
"Success" : true
}Error codes
For a list of error codes, visit the API Error Center.