Modifies the SQL script that is submitted by using a data change ticket.
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 | ModifyDataCorrectExecSQL |
The operation that you want to perform. Set the value to ModifyDataCorrectExecSQL. |
OrderId | Long | Yes | 4328**** |
The ID of the data change ticket. |
ExecSQL | String | Yes | update tb set id = 1 where id = 1; |
The new SQL script. |
Tid | Long | No | 4**** |
The ID of the tenant. You can call the GetUserActiveTenant operation to query the tenant ID. |
RegionId | String | No | cn-hangzhou |
The region in which DMS is activated. For more information, see RegionID parameter. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | 0C1CB646-1DE4-4AD0-B4A4-7D47DD52**** |
The ID of the request. |
Success | Boolean | true |
Indicates whether the request was successful. Valid values:
|
ErrorMessage | String | Specified parameter OrderId is not valid. |
The error message returned. |
ErrorCode | String | InvalidOrderId |
The error code returned. |
Examples
Sample requests
http(s)://dms-enterprise.aliyuncs.com/?Action=ModifyDataCorrectExecSQL
&OrderId=4328****
&ExecSQL=update tb set id = 1 where id = 1;
&Tid=4****
&Common request parameters
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<ModifyDataCorrectExecSQLResponse>
<RequestId>0C1CB646-1DE4-4AD0-B4A4-7D47DD52****</RequestId>
<Success>true</Success>
</ModifyDataCorrectExecSQLResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"RequestId" : "0C1CB646-1DE4-4AD0-B4A4-7D47DD52****",
"Success" : true
}
Error codes
For a list of error codes, visit the API Error Center.