Querying Tables for Which No Static Masking Task Has Been Performed

Function

Calling Method

For details, see Calling APIs.

URI

GET /v1/{project_id}/security/diagnose/masking-result

**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
limit	No	Integer	Number of items displayed on each page
offset	No	Integer	Offset, which is the position where the query starts. The value must be greater than or equal to 0.
diagnose_id	Yes	String	Diagnosis task ID, which can be obtained through the diagnosis result API of the data permission control module
datasource_type	No	String	Data Source Type Hive data source DWS Data Source DLI Data Source
database	No	String	Database name
cluster_name	No	String	Cluster Name

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
workspace	Yes	String	Workspace ID. For details about how to obtain the workspace ID, see Instance ID and Workspace ID.
X-Auth-Token	Yes	String	IAM token, which is obtained by calling the IAM API for obtaining a user token (value of X-Subject-Token in the response header). This parameter is mandatory for token authentication.

Response Parameters

Status code: 200

**Table 4** Response body parameters
Parameter	Type	Description
total	Integer	Total number of tables
tables	Array of DiagnoseNoMaskingDetail objects	Tables queried

**Table 5** DiagnoseNoMaskingDetail
Parameter	Type	Description
id	String	UUID
project_id	String	Project ID.
task_id	String	Diagnosis task ID
datasource_type	String	Data Source Type
cluster_name	String	Cluster name.
database	String	Database
schema	String	Schema name
table	String	Table Name
remark	String	Remarks

Example Requests

/v1/0833a5737480d53b2f25c010dc1a7b88/security/diagnose/masking-result?limit=10&offset=0&diagnose_id=695e9ea4dd864e55b5dbdd91ad61ebd0

Example Responses

Status code: 200

{
  "total" : 1,
  "tables" : [ {
    "id" : "02520cbff97c58ed963844bf5590bded",
    "project_id" : "0833a5737480d53b2f25c010dc1a7b88",
    "task_id" : "eb0e436378924a05878029e0b153a257",
    "datasource_type" : "DWS",
    "cluster_name" : "dws",
    "database" : "test1",
    "schema" : "public",
    "table" : "table",
    "remark" : "remark"
  } ]
}