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__": null,
"__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__": null,
"__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
}
}
}Documentation Index
Fetch the complete documentation index at: https://docs.kadoa.com/llms.txt
Use this file to discover all available pages before exploring further.
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