Create a flashback task.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | SubmitSqlFlashbackTask |
The operation that you want to perform. Set the value to SubmitSqlFlashbackTask. |
RegionId | String | Yes | cn-hangzhou |
The ID of the region where the instance is deployed. |
DbName | String | Yes | test |
The name of the database. |
PolardbxInstanceId | String | Yes | pxc-********* |
The ID of the instance on which you want to perform flashback. |
StartTime | String | Yes | 2019-09-10 20:23:23 |
The beginning of the time range to search SQL queries whose results you want to flash back. |
EndTime | String | Yes | 2019-09-10 23:23:23 |
The end of the time range to search SQL queries whose results you want to flash back. |
RecallRestoreType | String | Yes | 0 |
The type of the flashback task. Valid values:
|
TraceId | String | No | ase***** |
The ID of the trace of the SQL query whose result you want to flash back. |
TableName | String | No | test |
The name of the table on which you want to perform the flashback task. |
SqlType | String | No | INSERT,UPDATE |
The types of SQL queries whose results you want to flash back. Valid values: INSERT, UPDATE, and DELETE. Separate multiple types with commas (,). |
SqlPk | String | No | 1111 |
The primary key that is specified in the SQL statements. |
RecallType | String | No | 0 |
The search method to query SQL queries. Valid values:
|
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
Message | String | OK |
The result of the request. |
RequestId | String | 1AD222E9-E606-4A42-BF6D-8A4442913CEF |
The ID of the request. |
Success | Boolean | true |
Indicates whether the operation is successful. |
Data | Object |
The data that is returned. |
|
TaskId | String | 1111 |
The ID of the flashback task. |
Examples
Sample requests
http(s)://[Endpoint]/?Action=SubmitSqlFlashbackTask
&RegionId=cn-hangzhou
&DbName=test
&PolardbxInstanceId=pxc-*********
&StartTime=2019-09-10 20:23:23
&EndTime=2019-09-10 23:23:23
&RecallRestoreType=0
&TraceId=ase*****
&TableName=test
&SqlType=INSERT,UPDATE
&SqlPk=1111
&RecallType=0
&<Common request parameters>
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<SubmitSqlFlashbackTaskResponse>
<Message>OK</Message>
<RequestId>1AD222E9-E606-4A42-BF6D-8A4442913CEF</RequestId>
<Success>true</Success>
<Data>
<TaskId>1111</TaskId>
</Data>
</SubmitSqlFlashbackTaskResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"Message" : "OK",
"RequestId" : "1AD222E9-E606-4A42-BF6D-8A4442913CEF",
"Success" : true,
"Data" : {
"TaskId" : "1111"
}
}
Error codes
For a list of error codes, visit the API Error Center.