REST API Reference > Test case REST APIs > Viewing history of a test case run
  

Viewing history of a test case run

Use the following URI to view the history of a test case run:
GET /datavalidation-service/api/v1/testcase/history/{testCaseRunId}
Use the IDS-SESSION-ID header in the GET request.
GET request
Use the test case run ID to view the history of a test case run.
When you open the report of a test case, the numeric value that you see in the URI after the testCaseRunID parameter is the test case run ID. For example, in the following image, the test case run ID is 25961:
The image shows the test case run ID highlighted, which is 25961.
GET response
If the test case ID was found, the GET request returns a 200 Successful operation response and returns the following response fields:
Field
Type
Description
sequenceName
String
Instance name or name of the test case job. The sequence name uses the following format: <test_case_name>__<counter>. The counter is set to 001 when you run a test case for the first time. The counter is incremented by 1 for each test case run thereafter.
testCaseId
String
ID of the test case.
testCaseRunId
String
Run ID of the test case.
startDateTime
String
Date and time when the test case run started.
finishDateTime
String
Date and time when the test case run completed.
duration
String
Number of milliseconds for which the test case ran.
errorMessage
String
Detailed information about the error message.
samplingStrategy
String
Defines the sampling type and value used.
mappingStrategyType
String
Displays one of the following values based on the comparison method used:
  • - FULL. Uses the Value Test - Compare Entire Table method in which Data Validation compares the entire table based on the actual data values.
  • - AGGR_FUNC. Uses the Aggregation Functions Test method in which Data Validation uses aggregation functions to compare the table.
report
Array
Array that gives the following details:
  • - Name of the test case
  • - Total number of records processed
  • - Total number of records processed in the first table
  • - Total number of records processed in the second table
  • - Total number of missing records in the second table
  • - ID of the test case
  • - Total number of matched records
  • - Matching result
  • - Row count comparison result
  • - Total number of unmatched records
  • - Total number of additional records in the second table
  • - Matching status of columns
  • - Date when the test case was run
  • - Date when the report was generated
  • - Aggregation functions used for comparison
  • - Total number of comparisons made
  • - Total number of failed matches
If the test case run ID is incorrect, the GET request returns a 400 Bad request response. If the test case run ID was not found, the GET request returns a 404 Test Case Not Found response. If there was a server issue, the GET request returns a 500 Internal Server response.
The GET request also returns the following response fields:
Field
Type
Description
code
String
Code of the error message.
message
String
Error message.
debugMessage
String
Message that can be used for debugging the issue.
details
String
Detailed information about the error message.