ListDataImportSQLPreCheckDetail - Data Management - Alibaba Cloud Documentation Center

Queries the precheck information of SQL statements used for data import in a ticket.

Operation description

You can call this operation only if the data is imported in security mode in your data import ticket.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example
OrderId	long	Yes	The ticket ID. You can call the ListOrders operation to query the ticket ID.	11****
SqlType	string	No	The type of the SQL statement. Valid values: SELECT INSERT DELETE CREATE_TABLE Note You can log on to the Data Management (DMS) console and choose Security and Specifications > Operation Audit in the top navigation bar to view more types of SQL statements.	INSERT
StatusCode	string	No	The state of the ticket. If you leave this parameter empty, all the states are queried by default. Valid values: INIT: The ticket is being initialized. RUNNING: The ticket is in progress. SUCCESS: The ticket is complete. TIMEOUT: The ticket is skipped due to timeout. FAIL: The ticket fails.	SUCCESS
PageNumer	long	No	The page number. Pages start from page 1.	1
PageSize	long	No	The number of entries per page.	20
Tid	long	No	The tenant ID. You can call the GetUserActiveTenant or ListUserTenants operation to query the tenant ID.	1

Response parameters

Parameter	Type	Description	Example
	object	The response parameters.
RequestId	string	The request ID. You can use the ID to locate logs and troubleshoot issues.	31853A2B-DC9D-5B39-8492-D2AC8BCF550E
Success	boolean	Indicates whether the request was successful. Valid values: true false	true
ErrorMessage	string	The error message returned if the request failed.	UnknownError
ErrorCode	string	The error code returned if the request failed.	UnknownError
PreCheckSQLDetailList	array<object>	The precheck information of SQL statements.
PreCheckSQLDetail	object	The precheck information of the SQL statement.
SqlId	long	The SQL ID, which indicates the sequence number of the SQL statement. The number starts with 1.	1
SqlType	string	The type of the SQL statement, such as DELETE, UPDATE, or ALTER_TABLE.	INSERT
StatusCode	string	The state of the ticket. Valid values: INIT: The ticket was being initialized. RUNNING: The ticket was in progress. SUCCESS: The ticket was complete. TIMEOUT: The ticket was skipped due to timeout. FAIL: The ticket failed.	SUCCESS
Skip	boolean	Indicates whether the precheck of the SQL statement was skipped. Valid values: true false	true
TotalCount	long	The number of SQL statements.	1

Examples

Sample success responses

JSONformat

{
  "RequestId": "31853A2B-DC9D-5B39-8492-D2AC8BCF550E",
  "Success": true,
  "ErrorMessage": "UnknownError",
  "ErrorCode": "UnknownError",
  "PreCheckSQLDetailList": [
    {
      "SqlId": 1,
      "SqlType": "INSERT",
      "StatusCode": "SUCCESS",
      "Skip": true
    }
  ],
  "TotalCount": 1
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation

No change history