/jobs/{jobID}/validate
Validates an import job and returns a list of rows as well as rows that failed validation according to model settings.
If the importMethod is set to CleanAndReplace, the /validate endpoint also returns an additional cleanAndReplaceAffectedRows property. This property displays a list of dimension value combinations that represent all rows that will be either cleaned or deleted from the target model before proceeding with the import. As a result, any row in the target model that matches the dimension values in the cleanAndReplaceAffectedRows property will be deleted automatically.
API Request Details
|
URL |
{BaseURL}/jobs/{jobID}/validate |
|
Request Type |
POST |
|
Content Type |
application/json |
|
Required Header |
|
|
Name |
x-csrf-token |
|
Value |
<token> |
Sample Response
201: Created{
"jobStatus": "READY_FOR_WRITE",
"totalNumberRowsInJob": 1000,
"failedNumberRows": 0,
"invalidRowsURL": "{BaseUrl}/jobs/432661d8-8d62/invalidRows",
"jobStatusURL": "{BaseUrl}/jobs/432661d8-8d62/status"
}
The example below is a sample response using the CleanAndReplace import method.
{
"jobStatus": "READY_FOR_WRITE",
"totalNumberRowsInJob": 1000,
"failedNumberRows": 0,
"invalidRowsURL": "{BaseUrl}/jobs/432661d8-8d62/invalidRows",
"jobStatusURL": "{BaseUrl}/jobs/432661d8-8d62/status"
“additionalInformation”: {
“cleanAndReplaceAffectedRows”: [
{
“Version”: “public.Actual”,
“Bicycle”: “TX100”
}
]
}
}
Error Responses
|
HTTP Status Code |
Returns |
|---|---|
|
400 |
Bad Request |
|
403 |
Unauthorized |
|
404 |
Not Found |
|
500 |
Unexpected Error |