ListQualityResultsByRule - DataWorks - Alibaba Cloud Documentation Center

Queries monitoring results after the data quality of a data source or a compute engine is monitored based on monitoring rules.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example
RuleId	long	Yes	The monitoring rule ID. You can use the ID and information such as a partition filter expression to perform a joint query.	152322134
StartDate	string	Yes	The beginning of the time range to query. Specify the time in the yyyy-MM-dd HH:mm:ss format. This parameter is used together with the EndDate parameter. The interval between the time specified by this parameter and the time specified by the EndDate parameter cannot exceed 7 days.	2020-09-20 00:00:00
EndDate	string	Yes	The end of the time range to query. Specify the time in the yyyy-MM-dd HH:mm:ss format. This parameter is used together with the StartDate parameter. The interval between the time specified by this parameter and the time specified by the StartDate parameter cannot exceed 7 days.	2020-09-22 00:00:00
PageSize	integer	Yes	The number of entries per page. Default value: 10. Maximum value: 100.	10
PageNumber	integer	Yes	The page number.	1
ProjectName	string	Yes	The name of the compute engine or data source for which data quality is monitored.	autotest
ProjectId	long	Yes	The DataWorks workspace ID.	12345

Response parameters

Parameter	Type	Description	Example
	object	The returned result.
HttpStatusCode	integer	The HTTP status code.	200
ErrorMessage	string	The error message.	You have no permission.
RequestId	string	The request ID.	CBA58543-00D4-41****
ErrorCode	string	The error code.	401
Success	boolean	Indicates whether the request was successful.	true
Data	object	The data structure of the monitoring results returned.
PageNumber	integer	The page number.	1
PageSize	integer	The number of entries per page. Default value: 10. Maximum value: 100.	10
TotalCount	long	The total number of entries returned.	200
RuleChecks	array<object>	The returned monitoring results.
RuleChecks	object
BlockType	integer	The strength of the monitoring rule. The strength of a monitoring rule indicates the importance of the rule. Valid values: 1: indicates that the monitoring rule is a strong rule. 0: indicates that the monitoring rule is a weak rule. You can specify the strength of a monitoring rule based on your business requirements. If a monitoring rule is a strong rule and the critical threshold is exceeded, a critical alert is reported and tasks that are associated with the rule are blocked from running.	1
WarningThreshold	float	The threshold for a warning alert. The threshold specifies the deviation of the monitoring result from the expected value. You can specify a custom value for the threshold based on your business requirements.	0.1
Property	string	The field whose data quality is checked based on the monitoring rule. This field is a column in the data source table that is monitored.	type
TableName	string	The name of the table that is monitored.	dual
Comment	string	The description of the monitoring rule.
CheckResultStatus	integer	The status of the monitoring result.	2
TemplateName	string	The name of the monitoring template.
CheckerName	string	The name of the checker.	fulx
RuleId	long	The ID of the monitoring rule.	123421
FixedCheck	boolean	Indicates whether the monitoring is performed based on a fixed value. Valid values: true false	false
Op	string	The comparison operator.	>
UpperValue	float	The upper limit of the predicted result. The value of this parameter is automatically generated based on the threshold that you specify.	22200
ActualExpression	string	The partition in the monitored data source table.	ds=20200925
ExternalId	string	The node ID.	123112232
TimeCost	string	The time that was taken to run the monitoring task.	10
Trend	string	The trend of the monitoring result.	up
ExternalType	string	The type of the scheduling system. Only CWF scheduling systems are supported.	CWF2
BizDate	long	The data timestamp. If the monitored business entity is offline data, the value is usually one day before the monitoring is performed.	1600704000000
CheckResult	integer	The monitoring result.	2
ResultString	string	The string of the monitoring result.	ResultString
MatchExpression	string	The partition filter expression.	ds=$[yyyymmdd]
CheckerType	integer	The type of the checker.	0
ProjectName	string	The name of the compute engine or data source for which data quality is monitored.	autotest
BeginTime	long	The time when the monitoring started.	1600704000000
DateType	string	The scheduling frequency. In most cases, the value of this parameter is YMD. This value indicates year, month, and day.	YMD
CriticalThreshold	float	The threshold for a critical alert. The threshold indicates the deviation of the monitoring result from the expected value. You can specify a custom value for the threshold based on your business requirements. If a monitoring rule is a strong rule and the critical threshold is exceeded, a critical alert is reported and tasks that are associated with the rule are blocked from running.	0.6
IsPrediction	boolean	Indicates whether the monitoring result is the same as the predicted result. Valid values: true false	false
RuleName	string	The name of the monitoring rule.
CheckerId	integer	The checker ID.	7
DiscreteCheck	boolean	Indicates whether the monitoring is discrete monitoring. Valid values: true false	true
EndTime	long	The time when the monitoring ended.	1600704000000
MethodName	string	The method used to collect sample data, such as such as 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, or table_count-count_distinct.	max
LowerValue	float	The lower limit of the predicted result. The value of this parameter is automatically generated based on the threshold that you specify.	2344
EntityId	long	The ID of the partition filter expression.	14534343
WhereCondition	string	The filter condition of the monitoring task.	type!='type2'
ExpectValue	float	The expected value.	90
TemplateId	integer	The ID of the monitoring template.	5
TaskId	string	The monitoring task ID.	16008552981681a0d6****
Id	long	The primary key ID.	2231123
ReferenceValue	array<object>	The historical sample values.
ReferenceValue	object
DiscreteProperty	string	The values of the sample field that are grouped by using the GROUP BY clause. For example, the values of the Gender field are grouped by using the GROUP BY clause. In this case, the values of DiscreteProperty are Male, Female, and null.	type1
Value	float	The sample value.	20
BizDate	string	The data timestamp. If the monitored business entity is offline data, the value is usually one day before the monitoring is performed.	1600704000000
SingleCheckResult	integer	The string of the monitoring result.	2
Threshold	float	The threshold.	0.2
SampleValue	array<object>	The current sample values.
SampleValue	object
DiscreteProperty	string	The values of the sample field that are grouped by using the GROUP BY clause. For example, the values of the Gender field are grouped by using the GROUP BY clause. In this case, the values of DiscreteProperty are Male, Female, and null.	type2
BizDate	string	The data timestamp. If the monitored business entity is offline data, the value is usually one day before the monitoring is performed.	1600704000000
Value	float	The sample value.	23
Open	boolean	Indicates whether the monitoring rule is enabled.	true

Examples

Sample success responses

JSONformat

{
  "HttpStatusCode": 200,
  "ErrorMessage": "You have no permission.",
  "RequestId": "CBA58543-00D4-41****",
  "ErrorCode": "401",
  "Success": true,
  "Data": {
    "PageNumber": 1,
    "PageSize": 10,
    "TotalCount": 200,
    "RuleChecks": [
      {
        "BlockType": 1,
        "WarningThreshold": 0.1,
        "Property": "type",
        "TableName": "dual",
        "Comment": "",
        "CheckResultStatus": 2,
        "TemplateName": "",
        "CheckerName": "fulx",
        "RuleId": 123421,
        "FixedCheck": false,
        "Op": ">",
        "UpperValue": 22200,
        "ActualExpression": "ds=20200925",
        "ExternalId": "123112232",
        "TimeCost": "10",
        "Trend": "up",
        "ExternalType": "CWF2",
        "BizDate": 1600704000000,
        "CheckResult": 2,
        "ResultString": "ResultString",
        "MatchExpression": "ds=$[yyyymmdd]",
        "CheckerType": 0,
        "ProjectName": "autotest",
        "BeginTime": 1600704000000,
        "DateType": "YMD",
        "CriticalThreshold": 0.6,
        "IsPrediction": false,
        "RuleName": "",
        "CheckerId": 7,
        "DiscreteCheck": true,
        "EndTime": 1600704000000,
        "MethodName": "max",
        "LowerValue": 2344,
        "EntityId": 14534343,
        "WhereCondition": "type!='type2'",
        "ExpectValue": 90,
        "TemplateId": 5,
        "TaskId": "16008552981681a0d6****",
        "Id": 2231123,
        "ReferenceValue": [
          {
            "DiscreteProperty": "type1",
            "Value": 20,
            "BizDate": "1600704000000",
            "SingleCheckResult": 2,
            "Threshold": 0.2
          }
        ],
        "SampleValue": [
          {
            "DiscreteProperty": "type2",
            "BizDate": "1600704000000",
            "Value": 23
          }
        ],
        "Open": true
      }
    ]
  }
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation
2024-05-10	The internal configuration of the API is changed, but the call is not affected	View Change Details
2023-03-08	The request parameters of the API has changed	View Change Details