Obtaining Sub-rule Fields of a Quality Report

Function

This API is used to obtain the score of a sub-rule field in a quality report.

Calling Method

For details, see Calling APIs.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.

If you are using role/policy-based authorization, see Permissions Policies and Supported Actions for details on the required permissions.
If you are using identity policy-based authorization, no identity policy-based permission required for calling this API.

URI

GET /v2/{project_id}/quality/report/sub-rule/results

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID.

**Table 2** Query Parameters
Parameter	Mandatory	Type	Description
data_connection_id	No	String	Data connection ID. If you want to obtain the technical report rule score, set data_connection_id, database_name and table_name.
database_name	No	String	Name of the database. If you want to obtain the score of the technical report rule, you must set data_connection_id, database_name and table_name.
table_name	No	String	Table name. If you want to obtain the score of the technical report rule, you must set data_connection_id, database_name and table_name.
table_object_name	No	String	Data table object name (data connection.database.schema table/table). If the service report rule score is obtained, you do not need to set data_connection_id, database_name and table_name. You only need to set table_object_name.
sub_rule_instance_id	Yes	String	Sub-rule instance ID
start_timestamp	No	Long	Start timestamp.
end_timestamp	No	Long	End timestamp.
limit	No	Long	Number of records on each page. The value range is [0,100].
offset	No	Long	Pagination offset. The minimum value is 0.

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
workspace	Yes	String	DataArts Studio workspace ID. For details about how to obtain the workspace ID, see Instance ID and Workspace ID.
X-Auth-Token	Yes	String	IAM token. For details about how to obtain the token, see Authentication.

Response Parameters

Status code: 200

**Table 4** Response body parameters
Parameter	Type	Description
header	Array of strings	Table header
rows	Array<Array<String>>	Table rows
count	Integer	Number of data rows, which is used for pagination

Status code: 400

**Table 5** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DQC.0000 which indicates that the request was successfully processed
error_msg	String	Error message

Status code: 500

**Table 6** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DQC.0000 which indicates that the request was successfully processed
error_msg	String	Error message

Example Requests

GET /v2/0833a5737480d53b2f25c010dc1a7b88/quality/report/sub-rule/results?data_connection_id=2d9dcb2076b34bbab1c675f070d6af9d&database_name=postgres&table_name=public.test&sub_rule_instance_id=1047298617787944960

Example Responses

Status code: 200

Success

{
  "count" : 1,
  "header" : [ "Field name", "Rule description", "Score", "Field weight", "Number of rows with a null value", "Total number of rows", "Null value rate", "Alarm status" ],
  "rows" : [ [ "postgres.public.test.name", "Data table null value scan", "0.0", "5", "0", "0", "1.0", "false" ] ]
}