GET /v1/dataQuality/testCases/testCaseResults/{fqn}

# Get test results
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}"

# Get results with time range
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between?startTs=1769900000000&endTs=1769990000000" \
  -H "Authorization: Bearer {access_token}"

# Add a test result
curl -X POST "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "timestamp": 1769982800000,
    "testCaseStatus": "Success",
    "result": "Max value 42 is between 1 and 100",
    "testResultValue": [
      {"name": "maxValue", "value": "42"}
    ]
  }'

{
  "data": [
    {
      "timestamp": 1769982800000,
      "testCaseStatus": "Success",
      "result": "Max value 42 is between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "42"
        }
      ]
    },
    {
      "timestamp": 1769896400000,
      "testCaseStatus": "Failed",
      "result": "Max value 150 is not between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "150"
        }
      ]
    }
  ],
  "paging": {
    "total": 2
  }
}

GET

dataQuality

testCases

testCaseResults

{fqn}

GET /v1/dataQuality/testCases/testCaseResults/{fqn}

# Get test results
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}"

# Get results with time range
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between?startTs=1769900000000&endTs=1769990000000" \
  -H "Authorization: Bearer {access_token}"

# Add a test result
curl -X POST "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "timestamp": 1769982800000,
    "testCaseStatus": "Success",
    "result": "Max value 42 is between 1 and 100",
    "testResultValue": [
      {"name": "maxValue", "value": "42"}
    ]
  }'

{
  "data": [
    {
      "timestamp": 1769982800000,
      "testCaseStatus": "Success",
      "result": "Max value 42 is between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "42"
        }
      ]
    },
    {
      "timestamp": 1769896400000,
      "testCaseStatus": "Failed",
      "result": "Max value 150 is not between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "150"
        }
      ]
    }
  ],
  "paging": {
    "total": 2
  }
}

Test Case Results

Retrieve test case execution results or add new results programmatically. Each result includes a status, timestamp, and detailed result values.

Get Test Case Results

string

required

Fully qualified name (FQN) returned when creating the test case. URL-encode it when necessary.

integer

Start timestamp (epoch milliseconds) to filter results.

integer

End timestamp (epoch milliseconds) to filter results.

Each result also includes duration, the time the run took in milliseconds, and, for a run that an error aborted, errorDetails. See Add a Test Case Result for both fields.

Add a Test Case Result

Use POST /v1/dataQuality/testCases/testCaseResults/{fqn} to add a new test result.

string

required

Fully qualified name (FQN) returned when creating the test case. URL-encode it when necessary.

Body Parameters

integer

required

Epoch timestamp (milliseconds) of the test execution.

string

required

Status of the test execution: Success, Failed, Aborted, or Queued.

string

Human-readable summary of the test result.

array

required

Array of detailed result values produced by the test.

Show properties

string

required

Name of the result metric.

string

required

Value of the result metric.

number

Wall-clock time that the test case run took, in milliseconds.

object

Details of the error that aborted the run. Collate shows them in the Execution error section of the Run Details card.

Show properties

string

Type of the error, for example the exception class name.

string

Human-readable error message.

string

Formatted stack trace of the error.

GET /v1/dataQuality/testCases/testCaseResults/{fqn}

# Get test results
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}"

# Get results with time range
curl "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between?startTs=1769900000000&endTs=1769990000000" \
  -H "Authorization: Bearer {access_token}"

# Add a test result
curl -X POST "{base_url}/api/v1/dataQuality/testCases/testCaseResults/sample_data.ecommerce_db.shopify.dim_address.shop_id.column_value_max_to_be_between" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "timestamp": 1769982800000,
    "testCaseStatus": "Success",
    "result": "Max value 42 is between 1 and 100",
    "testResultValue": [
      {"name": "maxValue", "value": "42"}
    ]
  }'

{
  "data": [
    {
      "timestamp": 1769982800000,
      "testCaseStatus": "Success",
      "result": "Max value 42 is between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "42"
        }
      ]
    },
    {
      "timestamp": 1769896400000,
      "testCaseStatus": "Failed",
      "result": "Max value 150 is not between 1 and 100",
      "testResultValue": [
        {
          "name": "maxValue",
          "value": "150"
        }
      ]
    }
  ],
  "paging": {
    "total": 2
  }
}

Returns

Get results returns a list of test case result objects for the requested FQN and time range. Add result returns the test case result object that was created.

Response

array

Array of test case result objects.

Show properties

integer

Epoch timestamp (milliseconds) of the test execution.

string

Status of the test: Success, Failed, or Aborted.

string

Human-readable summary of the test result.

array

Detailed result values.

Show properties

string

Name of the result metric.

string

Value of the result metric.

object

Pagination information.

Show properties

integer

Total count of results.

Test Case Status Values

Status	Description
`Success`	The test passed all assertions
`Failed`	The test failed one or more assertions
`Aborted`	The test was aborted due to an error or timeout

Error Handling

Code	Error Type	Description
`401`	`UNAUTHORIZED`	Invalid or missing authentication token
`403`	`FORBIDDEN`	User lacks permission to view or add test results
`404`	`NOT_FOUND`	Test case with given FQN does not exist

​Test Case Results

​Get Test Case Results

​Add a Test Case Result

​Body Parameters

​Returns

​Response

​Test Case Status Values

​Error Handling

Test Case Results

Get Test Case Results

Add a Test Case Result

Body Parameters

Returns

Response

Test Case Status Values

Error Handling