Obtaining a Model
Function
This API is used to obtain information about all models in the current space.
Calling Method
For details, see Calling APIs.
URI
GET /v2/{project_id}/design/workspaces
|
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. |
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
workspace_type |
No |
String |
Defines the enumeration of model workspace types. Options:
|
|
limit |
No |
Integer |
Number of records to be queried on each page, that is, Y records to be queried. The default value is 50, and the value range is [1,100]. |
|
offset |
No |
Integer |
Start coordinate of the query, that is, the number of skipped data records. The value can only be 0 or an integer multiple of limit. If the value does not meet the requirement, the value is rounded down. The default value is 0. |
|
dw_type |
No |
String |
Data Connection Type |
Request Parameters
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
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 field is mandatory for authentication using tokens. |
|
workspace |
Yes |
String |
Workspace ID. For details about how to obtain the workspace ID, see Instance ID and Workspace ID. |
|
X-Project-Id |
No |
String |
Project ID. For details about how to obtain the project ID, see Project ID and Account ID. This parameter is mandatory for API requests that use AK/SK authentication in multi-project scenarios. |
|
Content-Type |
No |
String |
Default value: application/json;charset=UTF-8 This parameter is optional. If the body is available, this parameter is mandatory. If the body is unavailable, you do not need to set this parameter or verify it. |
Response Parameters
Status code: 200
|
Parameter |
Type |
Description |
|---|---|---|
|
data |
data object |
data: unified outermost data structure of the returned result. |
|
Parameter |
Type |
Description |
|---|---|---|
|
value |
value object |
value: unified outer data structure of the returned result. |
|
Parameter |
Type |
Description |
|---|---|---|
|
total |
Integer |
Total number. |
|
records |
Array of WorkspaceVO objects |
WorkspaceVO information. |
|
Parameter |
Type |
Description |
|---|---|---|
|
id |
String |
ID, which is a string |
|
name |
String |
Name of the workspace. |
|
description |
String |
Description. |
|
is_physical |
Boolean |
Indicates whether a table is a physical table. |
|
frequent |
Boolean |
Indicates whether it is commonly used. |
|
top |
Boolean |
Hierarchical governance. |
|
level |
String |
Data governance layers. Options:
|
|
dw_type |
String |
Data connection type, which corresponds to the type of the data warehouse where the table is located. The value can be DWS, MRS_HIVE, POSTGRESQL, MRS_SPARK, CLICKHOUSE, MYSQL, ORACLE, or DORIS. |
|
create_time |
String |
Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z. |
|
update_time |
String |
Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z. |
|
create_by |
String |
Creator. |
|
update_by |
String |
Person who updates the information. |
|
type |
String |
Defines the workspace type enumeration. Options:
|
|
biz_catalog_ids |
String |
{"l1Ids":[],"l2Ids":[],"l3Ids":[]}: ID list of associated service catalogs. |
|
databases |
Array of strings |
Array of database names. |
|
table_model_prefix |
String |
Model verification prefix. The value contains a maximum of 100 characters, including digits, letters, and underscores (_), and starts with a letter. |
Status code: 400
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code, for example, DS.6000, indicating that the request fails to be processed. |
|
error_msg |
String |
Error message |
|
data |
Object |
Returned data information. |
Status code: 401
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code, for example, DS.6000, indicating that the request fails to be processed. |
|
error_msg |
String |
Error message |
|
data |
Object |
Returned data information. |
Status code: 403
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code, for example, DS.6000, indicating that the request fails to be processed. |
|
error_msg |
String |
Error message |
|
data |
Object |
Returned data information. |
Example Requests
This API is used to obtain information about all models in the current space.
GET https://{endpoint}/v2/{project_id}/design/workspaces
Example Responses
Status code: 200
This operation succeeds. The returned data is a WorkspaceVO array and the total number of data records.
{
"data" : {
"value" : {
"records" : [ {
"id" : "1014218815216717824",
"name" : "test",
"description" : "abc",
"is_physical" : true,
"frequent" : false,
"top" : true,
"level" : "SDI",
"dw_type" : "DWS",
"create_time" : "2022-08-30T17:03:28.822+08:00",
"update_time" : "2022-08-30T17:03:28.822+08:00",
"create_by" : "abc",
"update_by" : "abc",
"type" : "THIRD_NF",
"biz_catalog_ids" : null,
"databases" : null
} ]
}
}
}
Status code: 400
BadRequest
{
"error_code" : "DS.60xx",
"error_msg" : "The user request is illegal."
}
Status code: 401
Unauthorized
{
"error_code" : "DS.60xx",
"error_msg" : "User authentication failed."
}
Status code: 403
Forbidden
{
"error_code" : "DS.60xx",
"error_msg" : "The user does not have permission to call this API."
}
Status Codes
|
Status Code |
Description |
|---|---|
|
200 |
This operation succeeds. The returned data is a WorkspaceVO array and the total number of data records. |
|
400 |
BadRequest |
|
401 |
Unauthorized |
|
403 |
Forbidden |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.