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
Example:
{ "repairUser":"Ram,", "repairPassword":"Veridata@123", "repairSQL":"false,", "repairStatus":"OOS,", "operationType":"UPDATE,", "cps":[ { "cpId":"1023,", "repairStatus":"OOS,", "operationType":"UPDATE,", "rowIds":[ "10, 20, 30" ] } ] }
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.
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }
401 Response
Unauthorized.
Root Schema : Error
Type:
Show Source object
- errCode: string Veridata Error Code.
- errMsg: string Veridata Error Message.
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }
404 Response
Not Found.
Root Schema : Error
Type:
Show Source object
- errCode: string Veridata Error Code.
- errMsg: string Veridata Error Message.
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }
500 Response
Server Error.
Root Schema : Error
Type:
Show Source object
- errCode: string Veridata Error Code.
- errMsg: string Veridata Error Message.
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }