All Products
Search
Document Center

Quick BI:QueryDatasetList

Last Updated:Jan 23, 2025

Queries the datasets of a specified workspace. The datasets are sorted in descending order by creation time.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
WorkspaceIdstringYes

The name of the data source.

95296e95-ca89-4c7d-8af9-dedf0ad0****
DirectoryIdstringNo

The ID of the request.

schemaad8aad00-9c55-4984-a767-b4e0ec60****
WithChildrenbooleanYes

The total number of pages returned.

true
KeywordstringNo

Information about the directory where the dataset is located

Queries the datasets of a specified workspace. The datasets are sorted in descending order by creation time.
PageNumintegerYes

The ID of the workspace.

1
PageSizeintegerNo

Specifies the directory ID.

  • If this field is not empty, all datasets in the directory are obtained.
10

Response parameters

ParameterTypeDescriptionExample
object
Successboolean

Whether to recursively wrap the dataset in the subdirectory. Valid values:

  • true: returns datasets in all recursive subdirectories in the directoryId directory.
  • false: Only datasets in the directory specified by directoryId are returned, excluding subdirectories.
true
RequestIdstring

The keyword used to search for the dataset name.

D787E1A3-A93C-424A-B626-C2B05DF8D885
Resultobject

Test dataset

TotalPagesinteger

Current page number for dataset list:

  • Pages start from page 1.
  • Default value: 1.
1
PageNuminteger

The number of rows per page in a paged query.

  • Default value: 10.
  • Maximum value: 1,000.
1
PageSizeinteger

Indicates whether the request is successful. Valid values:

  • true: The request was successful.
  • false: The request failed.
10
TotalNuminteger

The ID of the request.

1
Dataarray<object>

Returns the pagination results of the dataset list. The detailed information of the dataset list is stored in the response parameter Data.

Dataobject
RowLevelboolean

The total number of pages returned.

true
WorkspaceIdstring

The page number of the returned page.

95296e95-ca89-4c7d-8af9-dedf0ad06adf
Descriptionstring

The number of rows per page set when the interface is requested.

The total number of rows in the table.
CreateTimestring

The details of the dataset list.

2020-11-02 10:36:05
OwnerNamestring

Whether to enable row-level permissions. Valid values:

  • true: The VIP Netty channel is enabled.
  • false: The incremental log backup feature is disabled.
The ID of the workspace.
WorkspaceNamestring

The description of the dataset.

Test dataset
OwnerIdstring

The creation time.

136516262323****
ModifyTimestring

The nickname of the dataset owner.

2020-11-02 10:36:05
DatasetNamestring

Tom

company_sales_record_copy12
DatasetIdstring

The name of the workspace.

5820f58c-c734-4d8a-baf1-7979af4f****
DataSourceobject

Test Space

DsTypestring

The user ID of the dataset owner in the Quick BI.

mysql
DsNamestring

The time when the scaling group was modified.

The name of the training dataset.
DsIdstring

The ID of the training dataset that you want to remove from the specified custom linguistic model.

261b252d-c3c3-498a-a0a7-5d1ec6cd****
Directoryobject

The information about the data source to which the dataset belongs.

PathIdstring

The type of the data source.

schemaad8aad00-9c55-4984-a767-b4e0ec60****
PathNamestring

The name of the data source.

Test a data source
Namestring

The ID of the data source.

Information about the directory where the dataset is located
Idstring

The ID of the directory path.

schemaad8aad00-9c55-4984-a767-b4e0ec60****

Examples

Sample success responses

JSONformat

{
  "Success": true,
  "RequestId": "D787E1A3-A93C-424A-B626-C2B05DF8D885",
  "Result": {
    "TotalPages": 1,
    "PageNum": 1,
    "PageSize": 10,
    "TotalNum": 1,
    "Data": [
      {
        "RowLevel": true,
        "WorkspaceId": "95296e95-ca89-4c7d-8af9-dedf0ad06adf",
        "Description": "The total number of rows in the table.\n",
        "CreateTime": "2020-11-02 10:36:05",
        "OwnerName": "The ID of the workspace.\n",
        "WorkspaceName": "Test dataset\n",
        "OwnerId": "136516262323****",
        "ModifyTime": "2020-11-02 10:36:05",
        "DatasetName": "company_sales_record_copy12",
        "DatasetId": "5820f58c-c734-4d8a-baf1-7979af4f****",
        "DataSource": {
          "DsType": "mysql",
          "DsName": "The name of the training dataset.\n",
          "DsId": "261b252d-c3c3-498a-a0a7-5d1ec6cd****"
        },
        "Directory": {
          "PathId": "schemaad8aad00-9c55-4984-a767-b4e0ec60****",
          "PathName": "Test a data source\n",
          "Name": "Information about the directory where the dataset is located\n",
          "Id": "schemaad8aad00-9c55-4984-a767-b4e0ec60****"
        }
      }
    ]
  }
}

Error codes

HTTP status codeError codeError messageDescription
400Instance.ExpiredYour instance has expired.Your instance has expired.
400Instance.Not.ExistThe specified instance does not exist.The specified instance does not exist.
400Access.ForbiddenAccess forbidden. Your instance version or access key is not allowed to call the API operation.-
400Invalid.OrganizationThe specified organizational unit does not exist.The specified organizational unit does not exist.
400User.Not.In.OrganizationThe specified user is not in the organizational unit.The specified user is not in the organizational unit.
400Invalid.Param.ErrorThe parameter is invalid.The parameter is invalid.
400Workspace.NotIn.OrganizationThe workspace is not owned by the organization.The workspace is not owned by the organization.
400CubeSchema.Not.ExistThe cube schema does not exist.cube schema do not exists.
400System.Param.EmptyYou must specify the %s parameter.You must specify the %s parameter.
400Internal.System.ErrorAn internal system error occurred.An internal system error occurred.
400Invalid.ParameterAn error occurred while verifying parameters.An error occurred while verifying parameters.
400Invalid.Parameter.ErrorThe parameter is invalid:%s.invalid parameter: ${0}.
400Invalid.User.AdminYou are not an administrator of this organization.Only organization administrators can perform this operation.
400UserInfo.ErrorThe personal information is invalid.The personal information is invalid.
400ApiUser.Not.ExistsThe specified user does not exist.The specified user does not exist.

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
2024-05-22The Error code has changed. The response structure of the API has changedView Change Details