Repair Job
post
http://{host}:{port}/veridata/v1/services/repair/jobs/{runId}
Required Role: Administrator, SuperUser, CommandLineOperator, RepairOperator
Repair Veridata Job.
Request
Path Parameters
-
runId(required): string
The Comparison Job's Run ID. Example: runId=1024,0,0.This defines a unique id for a job run which can be obtained from monitoring API.
Supported Media Types
- application/json
Root Schema : schema
Type:
Show Source
object
-
cps: array
cps
List of compare pairs to be repaired.
-
operationType: string
Allowed Values:
[ "UPDATE", "DELETE", "INSERT" ]
Operation type filter. -
repairPassword: string
(password)
Repair user Password.
-
repairSQL: boolean
Default Value:
false
Parameter to decide if the repair SQL queries should be generated and returned instead of running repair SQL queries directly on the target database. Default value: false -
repairStatus: string
Allowed Values:
[ "OOS", "WARNING", "ERRORS", "CANCELLED" ]
Repair Status filter. Filters mapped differently from Repair Status. -
repairUser: string
User credentials to be used in target database to run repair SQL Queries
Nested Schema : RepairCP
Type:
Show Source
object
-
cpId: integer
Compare pair Id.
-
operationType: string
Allowed Values:
[ "UPDATE", "DELETE", "INSERT" ]
Operation type filter. -
repairStatus: string
Allowed Values:
[ "OOS", "WARNING", "ERRORS", "CANCELLED" ]
Repair Status filter. Filters mapped differently from Repair Status. -
rowIds: array
rowIds
List of each Out Of Sync row ids. GGROWHASH column value will be the id for the row. Send source side for INSERT, target side for DELETE and source side concatenation with target side for UPDATE.
Nested Schema : rowIds
Type:
array
List of each Out Of Sync row ids. GGROWHASH column value will be the id for the row. Send source side for INSERT, target side for DELETE and source side concatenation with target side for UPDATE.
Show Source
Response
Supported Media Types
- application/json
200 Response
Repair job was submitted successfully. Below response will be shown only when repairSQL is false. Otherwise, bytes would be returned in response.
400 Response
Bad Request.
Root Schema : Error
Type:
Show Source
object
-
errCode: string
Veridata Error Code.
-
errMsg: string
Veridata Error Message.
401 Response
Unauthorized.
Root Schema : Error
Type:
Show Source
object
-
errCode: string
Veridata Error Code.
-
errMsg: string
Veridata Error Message.
404 Response
Not Found.
Root Schema : Error
Type:
Show Source
object
-
errCode: string
Veridata Error Code.
-
errMsg: string
Veridata Error Message.
500 Response
Server Error.
Root Schema : Error
Type:
Show Source
object
-
errCode: string
Veridata Error Code.
-
errMsg: string
Veridata Error Message.