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.

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