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
Comparison results between expected and actual data schema
Show child attributes
Show child attributes
ISOLATED validates each dataset independently. LINKING_COLUMNS validates data integrity across linked columns between datasets.
ISOLATED, LINKING_COLUMNS Show child attributes