ListQualityResultsByEntity-DataWorks(DataWorks)-阿里云帮助中心

Use ListQualityResultsByEntity to retrieve validation results based on a partition expression.

Note

This API has been deprecated. We recommend migrating to dataworks-public(2024-05-18) - ListDataQualityScanRuns for enhanced functionality and continued support. While the deprecated API remains temporarily accessible, no further updates or bug fixes will be provided.

Operation description

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

No authorization for this operation. If you encounter issues with this operation, contact technical support.

Request parameters

Parameter	Type	Required	Description	Example
EntityId	integer	Yes	The partition expression ID. Call GetQualityEntity to obtain this ID.	15232
StartDate	string	Yes	The start of the business date range. Format: `yyyy-MM-dd HH:mm:ss`.	2020-09-20 00:00:00
EndDate	string	Yes	The end of the business date range. Format: `yyyy-MM-dd HH:mm:ss`.	2020-09-21 00:00:00
PageSize	integer	Yes	The number of entries per page. Default: 10. Maximum: 20.	10
PageNumber	integer	Yes	The page number to return.	1
ProjectName	string	Yes	The engine or data source name, as shown on the Data Source Configuration page.	autotest
ProjectId	integer	Yes	The ID of the DataWorks workspace.	12345

Response elements

Element	Type	Description	Example
	object	The data quality check results.
HttpStatusCode	integer	The HTTP status code.	200
ErrorMessage	string	The error message.	You have no permission.
RequestId	string	The ID of the request.	CBA58543-00D4-41****
Success	boolean	Whether the request succeeded.	true
ErrorCode	string	The error code.	401
Data	object	The quality check results object.
PageNumber	integer	The page number.	1
PageSize	integer	The number of entries per page. Default value: 10. Maximum value: 100.	10
TotalCount	integer	The total number of entries.	50
RuleChecks	array<object>	The monitoring rule check results.
	array<object>	The check result.
BlockType	integer	The monitoring rule strength. Valid values: 1: Strong Rule. A critical alert blocks the associated Scheduling Task. 0: Weak Rule.	0
WarningThreshold	number	The warning threshold, indicating the acceptable deviation from the expected value.	0.1
Property	string	The monitored column name in the data source table.	type
TableName	string	The monitored table name.	dual
Comment	string	The description of the monitoring rule.	The description of the rule.
CheckResultStatus	integer	The check result status, corresponding to the UI display. Valid values: 0: Normal 1: Warning 2: Critical	0
TemplateName	string	The name of the rule template.	Expected value verification
CheckerName	string	The name of the checker.	fulx
RuleId	integer	The monitoring rule ID.	123123232
FixedCheck	boolean	Whether the check uses a fixed value. Valid values: true: Fixed value check. false: Not a fixed value check.	false
Op	string	The comparison operator.	>
UpperValue	number	The predicted upper limit, automatically generated after a threshold is set.	25555
ActualExpression	string	The partition expression of the checked data.	ds=20200912
ExternalId	string	The node ID of the Scheduling Task.	1112323123
TimeCost	string	The time taken to run the check, in seconds.	202
Trend	string	The trend of the check result.	abs
ExternalType	string	The scheduling system type. Only CWF is supported.	CWF2
BizDate	integer	The business date. For offline data, typically the day before the check runs.	1600704000000
CheckResult	integer	The check result. Usually matches `CheckResultStatus`. Valid values: 0: Normal 1: Warning 2: Critical	0
ResultString	string	The check result, returned as a string.	test
MatchExpression	string	The partition filter expression.	ds=$[yyyymmdd]
CheckerType	integer	The type of the checker. Valid values: 0: Fixed Value 1: Fluctuation 2: Dynamic Threshold	1
ProjectName	string	The monitored compute engine or data source name.	autotest
BeginTime	integer	The check start time, in milliseconds since epoch (UNIX timestamp).	1600704000000
DateType	string	The scheduling cycle. Common value: YMD (year, month, day).	YMD
CriticalThreshold	number	The deviation threshold that triggers a critical alert. If triggered for a Strong Rule, the associated Scheduling Task is blocked.	0.5
IsPrediction	boolean	Whether the result is a predicted value. Valid values: true: Predicted value. false: Not a predicted value.	true
RuleName	string	The name of the monitoring rule.	The name of the rule.
CheckerId	integer	The ID of the checker.	7
DiscreteCheck	boolean	Whether the check is discrete. Valid values: true: Discrete check. false: Not a discrete check.	true
EndTime	integer	The check end time, in milliseconds since epoch (UNIX timestamp).	1600704000000
MethodName	string	The sample data collection method. Valid values: `avg`, `count`, `sum`, `min`, `max`, `count_distinct`, `user_defined`, `table_count`, `table_size`, `table_dt_load_count`, `table_dt_refuseload_count`, `null_value`, `null_value/table_count`, `(table_count-count_distinct)/table_count`, and `table_count-count_distinct`.	count_distinct
LowerValue	number	The predicted lower limit, automatically generated after a threshold is set.	2344
EntityId	integer	The ID of the partition filter expression.	15432322
WhereCondition	string	The filter condition of the monitoring rule.	id>0
ExpectValue	number	The expected value.	200
TemplateId	integer	The ID of the rule template.	5
TaskId	string	The ID of the check task.	16008552981681a0d6****
Id	integer	The unique ID of the check result.	121212121
ReferenceValue	array<object>	The historical sample values.
	object	A historical check result.
DiscreteProperty	string	The grouped field value when a `group by` clause is used. Example: grouping by gender yields male, female, or null.	0
Value	number	The historical check value.	19
BizDate	string	The business date. For offline data, typically the day before the check runs.	2020-12-03
SingleCheckResult	integer	The result of a single check.	0
Threshold	number	The threshold applied to this historical data point.	0.5
SampleValue	array<object>	The current sample values.
	object	A sample check result.
DiscreteProperty	string	The grouped field value when a `group by` clause is used. Example: grouping by gender yields male, female, or null.	0
BizDate	string	The business date. For offline data, typically the day before the check runs.	2020-12-03
Value	number	The current sample value.	19

Examples

Success response

JSON format

{
  "HttpStatusCode": 200,
  "ErrorMessage": "You have no permission.",
  "RequestId": "CBA58543-00D4-41****",
  "Success": true,
  "ErrorCode": "401",
  "Data": {
    "PageNumber": 1,
    "PageSize": 10,
    "TotalCount": 50,
    "RuleChecks": [
      {
        "BlockType": 0,
        "WarningThreshold": 0.1,
        "Property": "type",
        "TableName": "dual",
        "Comment": "The description of the rule.",
        "CheckResultStatus": 0,
        "TemplateName": "Expected value verification",
        "CheckerName": "fulx",
        "RuleId": 123123232,
        "FixedCheck": false,
        "Op": ">",
        "UpperValue": 25555,
        "ActualExpression": "ds=20200912",
        "ExternalId": "1112323123",
        "TimeCost": "202",
        "Trend": "abs",
        "ExternalType": "CWF2",
        "BizDate": 1600704000000,
        "CheckResult": 0,
        "ResultString": "test",
        "MatchExpression": "ds=$[yyyymmdd]",
        "CheckerType": 1,
        "ProjectName": "autotest",
        "BeginTime": 1600704000000,
        "DateType": "YMD",
        "CriticalThreshold": 0.5,
        "IsPrediction": true,
        "RuleName": "The name of the rule.",
        "CheckerId": 7,
        "DiscreteCheck": true,
        "EndTime": 1600704000000,
        "MethodName": "count_distinct",
        "LowerValue": 2344,
        "EntityId": 15432322,
        "WhereCondition": "id>0",
        "ExpectValue": 200,
        "TemplateId": 5,
        "TaskId": "16008552981681a0d6****",
        "Id": 121212121,
        "ReferenceValue": [
          {
            "DiscreteProperty": "0",
            "Value": 19,
            "BizDate": "2020-12-03",
            "SingleCheckResult": 0,
            "Threshold": 0.5
          }
        ],
        "SampleValue": [
          {
            "DiscreteProperty": "0",
            "BizDate": "2020-12-03",
            "Value": 19
          }
        ]
      }
    ]
  }
}

Error codes

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.