All Products
Search
Document Center

DataWorks:ListQualityResultsByEntity

Last Updated:Jun 11, 2026

Mengambil hasil validasi berdasarkan ekspresi partisi.

Catatan

API ini telah ditinggalkan. Kami merekomendasikan migrasi ke dataworks-public(2024-05-18) - ListDataQualityScanRuns guna memperoleh fungsionalitas yang lebih baik dan dukungan berkelanjutan. Meskipun API yang telah ditinggalkan ini masih dapat diakses sementara, tidak akan ada pembaruan atau perbaikan bug lebih lanjut.

Deskripsi operasi


Coba sekarang

Coba API ini di OpenAPI Explorer tanpa perlu penandatanganan manual. Panggilan yang berhasil akan secara otomatis menghasilkan contoh kode SDK sesuai dengan parameter Anda. Unduh kode tersebut dengan kredensial bawaan yang aman untuk penggunaan lokal.

Test

RAM authorization

Tidak ada otorisasi untuk operasi ini. Jika Anda mengalami masalah saat menjalankan operasi ini, hubungi dukungan teknis.

Parameter permintaan

Parameter

Type

Required

Description

Example

EntityId

integer

Yes

ID ekspresi partisi. Anda dapat memanggil operasi GetQualityEntity untuk mendapatkan ID ini.

15232

StartDate

string

Yes

Awal rentang tanggal bisnis. Nilai harus dalam format yyyy-MM-dd HH:mm:ss.

2020-09-20 00:00:00

EndDate

string

Yes

Akhir rentang tanggal bisnis. Nilai harus dalam format yyyy-MM-dd HH:mm:ss.

2020-09-21 00:00:00

PageSize

integer

Yes

Jumlah entri yang dikembalikan per halaman. Nilai default adalah 10, dan nilai maksimum adalah 20.

10

PageNumber

integer

Yes

Nomor halaman yang dikembalikan.

1

ProjectName

string

Yes

Nama engine atau sumber data. Anda dapat menemukan nama ini di halaman Konfigurasi Sumber Data.

autotest

ProjectId

integer

Yes

ID ruang kerja DataWorks.

12345

Elemen respons

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

Indicates whether the request was successful.

true

ErrorCode

string

The error code.

401

Data

object

The data object that contains the quality check results.

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 strength of the monitoring rule. The strength of a monitoring rule indicates the importance of the rule. Valid values:

  • 1: the monitoring rule is a strong rule.

  • 0: the monitoring rule is a weak rule. You can specify whether a monitoring rule is a strong 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.

0

WarningThreshold

number

The threshold for a warning alert. The threshold indicates the deviation of the check result from the expected value. You can customize this 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.

The description of the rule.

CheckResultStatus

integer

The check result of the monitoring rule. Valid values:

  • 0: indicates that the data source table is normal.

  • 1: indicates that a warning alert is reported.

  • 2: indicates that a critical alert is reported.

0

TemplateName

string

The name of the monitoring template.

Expected value verification

CheckerName

string

The name of the checker.

fulx

RuleId

integer

The ID of the monitoring rule.

123123232

FixedCheck

boolean

Indicates whether the monitoring is performed based on a fixed value. Valid values:

  • true

  • false

false

Op

string

The comparison operator.

>

UpperValue

number

The upper limit of the predicted result. The value of this parameter is automatically generated based on the threshold that you specify.

25555

ActualExpression

string

The monitored partition in the data source table.

ds=20200912

ExternalId

string

The node ID.

1112323123

TimeCost

string

The time that was taken to run the monitoring task. Unit: seconds.

202

Trend

string

The trend of the check result.

abs

ExternalType

string

The type of the scheduling system. Only CWF scheduling systems are supported.

CWF2

BizDate

integer

The data timestamp. In most cases, if the monitored business entity is offline data, the value is one day before the monitoring is performed.

1600704000000

CheckResult

integer

The check result. The value of this parameter is the same as the value of the CheckResultStatus parameter. Valid values:

  • 0: indicates that the data source table is normal.

  • 1: indicates that a warning alert is reported.

  • 2: indicates that a critical alert is reported.

0

ResultString

string

The string of the check result.

test

MatchExpression

string

The partition filter expression.

ds=$[yyyymmdd]

CheckerType

integer

The check type. Valid values:

  • 0: indicates that the monitoring is performed based on a fixed value.

  • 1: indicates that the monitoring is performed based on a non-fixed value.

  • 2: indicates that the monitoring is performed based on a dynamic threshold.

1

ProjectName

string

The name of the compute engine or data source for which data quality is monitored.

autotest

BeginTime

integer

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

number

The threshold for a critical alert. The threshold indicates the deviation of the check result from the expected value. You can specify a 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.5

IsPrediction

boolean

Indicates whether the check result is the same as the predicted result. Valid values:

  • true

  • false

true

RuleName

string

The name of the monitoring rule.

The name of the rule.

CheckerId

integer

The checker ID.

7

DiscreteCheck

boolean

Indicates whether the monitoring is discrete monitoring. Valid values:

  • true

  • false

true

EndTime

integer

The deadline for querying the check result.

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.

count_distinct

LowerValue

number

The lower limit of the predicted result. The value of this parameter is automatically generated based on the threshold that you specify.

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 monitoring template.

5

TaskId

string

The monitoring task ID.

16008552981681a0d6****

Id

integer

The primary key ID.

121212121

ReferenceValue

array<object>

The historical sample values.

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 the DiscreteProperty parameter are Male, Female, and null.

0

Value

number

The check value.

19

BizDate

string

The data timestamp. In most cases, if the monitored business entity is offline data, the value is one day before the monitoring is performed.

2020-12-03

SingleCheckResult

integer

The check result.

0

Threshold

number

The threshold.

0.5

SampleValue

array<object>

The current sample value.

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 the DiscreteProperty parameter are Male, Female, and null.

0

BizDate

string

The data timestamp. In most cases, if the monitored business entity is offline data, the value is one day before the monitoring is performed.

2020-12-03

Value

number

The current sample value.

19

Contoh

Respons sukses

JSONformat

{
  "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
          }
        ]
      }
    ]
  }
}

Kode kesalahan

Lihat Error Codes untuk daftar lengkap.

Catatan rilis

Lihat Release Notes untuk daftar lengkap.