All Products
Search
Document Center

Data Management:GetDataImportSQL

Last Updated:Oct 21, 2024

Queries the 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.

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
OrderIdlongYes

The ticket ID. You can call the ListOrders operation to query the ticket ID.

14****
SqlIdlongYes

The SQL ID. You can call the ListDataImportSQLPreCheckDetail operation to query the SQL ID.

15****
TidlongNo

The tenant ID. You can call the GetUserActiveTenant or ListUserTenants operation to query the tenant ID.

3***

Response parameters

ParameterTypeDescriptionExample
object

The response parameters.

RequestIdstring

The request ID. You can use the ID to locate logs and troubleshoot issues.

B43AD641-49C2-5299-9E06-1B37EC1B****
Successboolean

Indicates whether the request was successful. Valid values:

  • true
  • false
true
ErrorMessagestring

The error message returned if the request failed.

UnknownError
ErrorCodestring

The error code returned if the request failed.

UnknownError
SQLDetailobject

The details of SQL statements.

ExecSqlstring

The SQL script.

insert into t1 values (1);

Examples

Sample success responses

JSONformat

{
  "RequestId": "B43AD641-49C2-5299-9E06-1B37EC1B****",
  "Success": true,
  "ErrorMessage": "UnknownError",
  "ErrorCode": "UnknownError",
  "SQLDetail": {
    "ExecSql": "insert into t1 values (1);"
  }
}

Error codes

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

Change history

Change timeSummary of changesOperation
No change history