You can call this operation to query detailed information of a specified data change ticket.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. You can use OpenAPI Explorer to search for API operations, call API operations, and dynamically generate SDK sample code.

Request parameters

Parameter Type Required Example Description
Action String Yes GetDataCorrectOrderDetail

The operation that you want to perform. Set the value to GetDataCorrectOrderDetail.

OrderId Long Yes 12345

The ID of the ticket.

Tid Long No -1

The ID of the tenant.

Note The tenant ID is taken from the avatar in the upper-right corner of the system. For more information, see Tenant ID and Tenant .

Response parameters

Parameter Type Example Description
DataCorrectOrderDetail Struct

The detailed information of the data change ticket.

DatabaseList Array of Database

Change database information

Database
DbId Integer 123456

The ID of the database.

DbType String mysql

The type of the logical database.

EnvType String product

The type of the environment to which the database instance belongs.

Logic Boolean false

Indicates whether the database was a logical database.

SearchName String xxx@xxx:3306

The query name of the database.

OrderDetail Struct

The detailed information of the ticket.

ActualAffectRows Long 100

The number of affected rows detected by system check.

AttachmentName String xxx

The attachment of the SQL statement that was run to change data.

Classify String test

The category of the reason for data change.

EstimateAffectRows Long 100

The estimated number of affected rows.

ExeSQL String update t1 set name = 'xxx' where id <= 100

The SQL statement that was run to change data.

IgnoreAffectRows Boolean false

Indicates whether the affected rows were ignored.

IgnoreAffectRowsReason String test

The reason that the affected rows were ignored.

RbAttachmentName String test

The attachment of the SQL statement that was run to roll back data.

RbSQL String empty

The rollback SQL statement that is filled in by the user.

RbSQLType String text

The rollback SQL type. Values and descriptions are as follows:

  • TEXT: TEXT
  • ATTACHMENT
SqlType String text

The SQL type. Values and descriptions are as follows:

  • TEXT: TEXT
  • ATTACHMENT
PreCheckDetail Array of TaskCheckDO

The details of the precheck task.

TaskCheckDO
CheckStatus String SUCCESS

The status of the precheck task. Valid values:

  • WAITING: WAITING for check
  • RUNNING: checking
  • SUCCESS: Pass
  • FAIL: FAIL
CheckStep String PERMISSION_CHECK

The check step. Valid values:

  • SQL_PARSE: parsing
  • SQL_TYPE_CHECK: type check
  • PERMISSION_CHECK: permission check
  • ROW_CHECK: row check
UserTip String tip messsage

The message that indicated a check step.

ErrorCode String UnknownError

Error codes

ErrorMessage String UnknownError

Error message

RequestId String 427688B8-ADFB-4C4E-9D45-EF5C1FD6E23D

The ID of the request.

Success Boolean true

Indicates whether the call was successful.

Examples

Sample requests


     http(s)://[Endpoint]/? Action=GetDataCorrectOrderDetail &OrderId=12345 &<common request parameters> 
   

Sample success responses

XML format


     <RequestId> ACE263E5-CF5F-44DD-A7B1-42C5E78E9650 </RequestId> <DataCorrectOrderDetail> <PreCheckDetail> <TaskCheckDO> <CheckStatus> SUCCESS </CheckStatus> <CheckStep> the SQL_PARSE </CheckStep> <TaskCheckDO> <CheckStatus> SUCCESS </CheckStatus> <CheckStep> </TaskCheckDO> </CheckStep> SQL_TYPE_CHECK </TaskCheckDO> <TaskCheckDO> <CheckStatus> SUCCESS </CheckStatus> <CheckStep> PERMISSION_CHECK </CheckStep> </TaskCheckDO> <TaskCheckDO> <CheckStatus> SUCCESS </CheckStatus> <UserTip> the system Statistics. The actual number of affected rows is still subject to SQL execution. </UserTip> <CheckStep>ROW_CHECK</CheckStep> </TaskCheckDO> </PreCheckDetail> <OrderDetail> <ActualAffectRows>0</ActualAffectRows> <RbSQLType>TEXT</RbSQLType> <ExeSQL>update base_user set id = 1 where id = 1;</ExeSQL> <EstimateAffectRows>1</EstimateAffectRows> <SqlType>TEXT</SqlType> <Classify>test</Classify> <IgnoreAffectRowsReason/> </OrderDetail> </DataCorrectOrderDetail> <Success>true</Success> 
   

JSON Format


     {"RequestId": "ACE263E5-CF5F-44DD-A7B1-42C5E78E9650", "DataCorrectOrderDetail": { "PreCheckDetail": { "TaskCheckDO": [ { "CheckStatus": "SUCCESS", "CheckStep": "SQL_PARSE" }, { "CheckStatus": "SUCCESS", "CheckStep": "SQL_TYPE_CHECK" }, { "CheckStatus": "SUCCESS", "CheckStep":" PERMISSION_CHECK "},{" CheckStatus ": " SUCCESS ", " UserTip ": " The system Statistics value. The actual number of affected rows is still subject to SQL execution. ", "CheckStep": "ROW_CHECK" } ] }, "OrderDetail": { "ActualAffectRows": 0, "RbSQLType": "TEXT", "ExeSQL": "update base_user set id = 1 where id = 1;", "EstimateAffectRows": 1, "SqlType": "TEXT", "Classify": "test", "IgnoreAffectRowsReason": "" } }, "Success": true} 
   

Error codes

Go to the Error Center For more information, see error codes.