Create a flashback task.

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 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:

  • 1: image restoration
  • 0: reverse restoration
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:

  • 0: term search
  • 1: fuzzy search

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.