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

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

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.