curl --request GET \
--url https://api.kadoa.com/v4/data-validation/workflows/{workflowId}/jobs/{jobId}/validations/latest \
--header 'x-api-key: <api-key>'{
"id": "abc123",
"workflowId": "<string>",
"jobId": "<string>",
"anomaliesCountTotal": 123,
"anomaliesCountByRule": {},
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"anomaliesByRule": [
{
"ruleName": "<string>",
"anomalies": [
{
"__rule__": "<string>",
"__id__": "<string>",
"__column__": "<string>",
"__type__": "<string>",
"__bad_value__": "<unknown>",
"__status__": "NEW"
}
],
"pagination": {
"page": 1,
"pageSize": 50,
"totalItems": 150,
"totalPages": 3
}
}
],
"schemaIssues": {
"missingColumns": [
"<string>"
],
"missingRequiredColumns": [
"<string>"
],
"extraColumns": [
"<string>"
]
},
"completedAt": "2023-11-07T05:31:56Z",
"metadata": {
"customRules": [
{
"name": "<string>",
"description": "<string>",
"ruleType": "custom_sql",
"parameters": {
"sql": "<string>"
},
"targetColumns": [
"<string>"
]
}
],
"libraryRules": [
{
"id": "<string>",
"name": "<string>",
"description": "<string>",
"parameters": {},
"targetColumns": [
"<string>"
]
}
],
"totalRulesExecuted": 123,
"recordsValidated": 123,
"usedPrompt": "<string>",
"invalidRules": [
{
"name": "<string>",
"error": "<string>"
}
]
},
"error": "<string>",
"isDryRun": true,
"isWorkflowTriggered": true,
"datasetUri": "<string>",
"anomaliesParquetPath": "<string>",
"strategy": "ISOLATED",
"cdc": {
"strategy": "ISOLATED",
"anomalyCountChanges": {
"previousJobId": "<string>",
"previousValidationId": "<string>",
"anomaliesCountTotal": {
"count": 123,
"change": 123
},
"anomaliesCountByRule": {}
},
"anomaliesStatusParquetPath": "<string>",
"statusCounts": {
"NEW": 123,
"ONGOING": 123,
"RESOLVED": 123,
"REOPENED": 123
}
}
}Retrieve the most recent validation results for a specific job within a workflow
curl --request GET \
--url https://api.kadoa.com/v4/data-validation/workflows/{workflowId}/jobs/{jobId}/validations/latest \
--header 'x-api-key: <api-key>'{
"id": "abc123",
"workflowId": "<string>",
"jobId": "<string>",
"anomaliesCountTotal": 123,
"anomaliesCountByRule": {},
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"anomaliesByRule": [
{
"ruleName": "<string>",
"anomalies": [
{
"__rule__": "<string>",
"__id__": "<string>",
"__column__": "<string>",
"__type__": "<string>",
"__bad_value__": "<unknown>",
"__status__": "NEW"
}
],
"pagination": {
"page": 1,
"pageSize": 50,
"totalItems": 150,
"totalPages": 3
}
}
],
"schemaIssues": {
"missingColumns": [
"<string>"
],
"missingRequiredColumns": [
"<string>"
],
"extraColumns": [
"<string>"
]
},
"completedAt": "2023-11-07T05:31:56Z",
"metadata": {
"customRules": [
{
"name": "<string>",
"description": "<string>",
"ruleType": "custom_sql",
"parameters": {
"sql": "<string>"
},
"targetColumns": [
"<string>"
]
}
],
"libraryRules": [
{
"id": "<string>",
"name": "<string>",
"description": "<string>",
"parameters": {},
"targetColumns": [
"<string>"
]
}
],
"totalRulesExecuted": 123,
"recordsValidated": 123,
"usedPrompt": "<string>",
"invalidRules": [
{
"name": "<string>",
"error": "<string>"
}
]
},
"error": "<string>",
"isDryRun": true,
"isWorkflowTriggered": true,
"datasetUri": "<string>",
"anomaliesParquetPath": "<string>",
"strategy": "ISOLATED",
"cdc": {
"strategy": "ISOLATED",
"anomalyCountChanges": {
"previousJobId": "<string>",
"previousValidationId": "<string>",
"anomaliesCountTotal": {
"count": 123,
"change": 123
},
"anomaliesCountByRule": {}
},
"anomaliesStatusParquetPath": "<string>",
"statusCounts": {
"NEW": 123,
"ONGOING": 123,
"RESOLVED": 123,
"REOPENED": 123
}
}
}API key for authentication
200
Complete validation report including summary fields, anomaly details by rule, dataset location details, CDC summary, and execution strategy
Unique identifier
"abc123"
Show child attributes
Show child attributes
NEW, ONGOING, RESOLVED, REOPENED Metadata for paginated responses including page info and totals
Show child attributes
Page number for pagination
x >= 11
Number of items per page
1 <= x <= 10050
Total number of items available
x >= 0150
Total number of pages
x >= 03
Show child attributes
Show child attributes
Rule name
What the rule checks for
Execution type for dynamic rules
custom_sql Columns to which the rule applies
Show child attributes
Rule identifier
Rule name
ISOLATED validates each dataset independently. LINKING_COLUMNS validates data integrity across linked columns between datasets.
ISOLATED, LINKING_COLUMNS Show child attributes
ISOLATED validates each dataset independently. LINKING_COLUMNS validates data integrity across linked columns between datasets.
ISOLATED, LINKING_COLUMNS Show child attributes