Retrieve Out-of-Sync data.
get
http://{host}:{port}/veridata/v1/services/oos/{runId}
Required Role: Administrator, SuperUser, CommandLineOperator, DetailMonitoringOperator
Get out-of-sync data for a Compare Pair.
Request
Path Parameters
- runId(required): integer(int64) Comparison Compare Pair run ID.
Query Parameters
- operationType: Filter rows based on operation type. Comma seperated operation type. Default is UPDATE,INSERT,DELETE.
- repairStatus: Filter rows based on repair status. Comma seperated repair status. Default value is Out of Sync rows.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
- */*
200 Response
Successfully retrieved Out-Of-Sync data.
Root Schema : schema
Type:
Show Source arrayExample:
[ { "repairStatus":"SUCCESSFUL", "rowsData":[ { "rowData":[ { "columnName":"BRANCH", "columnType":"VARCHAR2", "keyCol":false, "srcColumnData":[ { "name":"BRANCH", "hex":false, "binary":false, "diff":false, "value":"IT", "isnull":false } ], "tgtColumnData":[ { "name":"BRANCH", "hex":false, "binary":false, "diff":false, "isnull":false } ] } ], "operation":"INSERT", "repairStatus":"SUCCESSFUL", "skippedRow":false, "duplicateRow":false, "rowId":"1B7CE18868966C8B_0", "errorMessage":"" } ] } ]Nested Schema : OutOfSyncDetails
Type:
Show Source object- repairStatus: string Allowed Values:
[ "PENDING", "RUNNING", "ERRORS", "WARNINGS", "SUCCESSFUL", "CANCELLED", "OOS" ]Repair Status. - rowsData: array rowsData
Nested Schema : OutOfSyncRow
Type:
Show Source object- duplicateRow: boolean Default Value:
false - errorMessage: string
- operation: string Allowed Values:
[ "INSERT", "UPDATE", "DELETE", "MATCH" ]Operation type. - repairStatus: string Allowed Values:
[ "PENDING", "RUNNING", "ERRORS", "WARNINGS", "SUCCESSFUL", "CANCELLED", "OOS" ]Repair Status. - rowData: array rowData
- rowId: string Unique Id for an Out Of Sync row. It is a combination of GGROWHASH_rownum.
- skippedRow: boolean Default Value:
false
Nested Schema : OutOfSyncRowDataColumnData
Type:
Show Source object- binary: boolean
- diff: boolean
- hex: boolean
- isnull: boolean Default Value:
false - name: string
- value: string
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" }