All Products
Search
Document Center

Quick BI:QueryDataServiceList

Last Updated:Nov 04, 2025
This topic is generated by a machine translation engine without any human intervention. ALIBABA CLOUD DOES NOT GUARANTEE THE ACCURACY OF MACHINE TRANSLATED CONTENT. To request a human-translated version of this topic or provide feedback on this translation, please include it in the feedback form.

Query Data Service API List

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

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

  • Operation: the value that you can use in the Action element to specify the operation on a resource.
  • Access level: the access level of each operation. The levels are read, write, and list.
  • Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
    • For mandatory resource types, indicate with a prefix of * .
    • If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
  • Condition Key: the condition key that is defined by the cloud service.
  • Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.
OperationAccess levelResource typeCondition keyAssociated operation
quickbi-public:QueryDataServiceListget
*All Resources
*
    none
none

Request parameters

ParameterTypeRequiredDescriptionExample
NamestringNo

Data service name.

test
UserIdstringNo

User ID.

dasdfdsa-csddf-dsadsa
PageNointegerYes

Page number. Default value: 1.

1
PageSizeintegerYes

Number of items per page in a paginated query:

  • Default value: 10
  • Maximum value: 1000
10

Response parameters

ParameterTypeDescriptionExample
object
RequestIdstring

Request ID.

78C1AA2D-9201-599E-A0BA-6FC462E57A95
Resultobject

Return result.

TotalPagesinteger

Total number of pages.

1
TotalNuminteger

Total number of rows.

1
PageNuminteger

Page number.

1
PageSizeinteger

Number of records per page.

10
Dataarray<object>

Data service information.

QueryDataServiceModelobject
Sidstring

Unique ID of the data service.

dtsuq3i31f5j8v848b
Namestring

Data service name.

test report
Descstring

Description

test
CubeIdstring

Cube identifier ID.

d14e7448-0eb3-40d3-9375-4afef8de29fd
CubeNamestring

Dataset name.

test data source
WorkspaceIdstring

Workspace ID.

7350a155-0e94-4c6c-8620-57bbec38****
WorkspaceNamestring

Workspace name.

test workspace
GmtCreatestring

Creation time.

2023-05-18 14:00:02.0
GmtModifiedstring

Modification time.

2023-03-21 18:02:36
CreatorIdstring

Creator ID.

7cb94cd48701
CreatorNamestring

Creator's name.

zhangsan
ModifierIdstring

Modifier's userId.

7cb94cd48701
ModifierNamestring

Modifier's name

zhangsan
OwnerIdstring

Owner ID

862801339
OwnerNamestring

Owner's name

lisi
Contentobject

The model of the data service in JSON format.

ReturnFieldsarray<object>

Return information.

SelectFieldModelobject
Aliasstring

Field parameter name.

s_number
Descstring

Remark for the returned field.

Theme Configuration already exists
Aggregatorstring

Aggregation operator. For example, SUM, AVG, and MAX.

SUM
Orderbystring

Sorting.

  • asc: Ascending
  • desc: Descending
  • no: No sorting
no
Fieldobject

Corresponding cube field information.

Fidstring

Unique identifier for the original field.

1c1f88cb7d
Namestring

Unique name of the cube field, mainly used for unique positioning in the returned result.

sss
Typestring

Type.

  • Dimension: Dimension
  • Measure: Measure
dimension
Captionstring

Display name in the cube model (can be in Chinese or English).

date(year)
Columnstring

The corresponding physical field name.

shid_star
DataTypestring

Data type.

  • number: numeric
  • string: string
  • date: date
  • datetime: datetime
  • time: time
  • geographic: geographic
  • boolean: boolean
  • url: URL
datetime
Granularitystring

This attribute is included for date and geographic dimensions, indicating the supported granularity.

yearRegion
Filterobject

Request parameter information.

LogicalOperatorstring

Logical relationship between multiple SQL text keywords.

  • or: or
  • and: and
and
Typestring

Type.

  • basic: basic
  • combined: complex
basic
Filtersarray<object>

Combined conditions.

AbstractFilterobject

JSON string of detailed hierarchical portal menu list. The value range includes:

  • Type: type.
    • 1.basic: basic
    • 2.combined: complex
  • field: corresponding cube field
  • alias: parameter name
  • desc: field description
  • aggregator: aggregation function
  • operator: operator
  • essential: whether it is required
  • defaultValue: system default value. If not provided in the API call, this value will be used as a replacement.
  • interval: date offset. This is valid for dates, representing the relative value to the default value or the parameter value.
  • logicalOperator: logical operator
  • filters: combined conditions (this is a nested structure)
[{ "field": { "fid": "1c1f88cb7d", "granularity": "yearRegion", "dataType": "datetime", "column": "s_date", "caption": "date(year)", "type": "dimension" }, "defaultValue": ["2024"], "alias": "s_date", "type": "basic", "operator": "equal-to", "essential": true }]
CubeIdstring

Cube identifier ID.

56f9f34a-bdba-496a-91a3-a18b1ff73a80
CubeNamestring

Dataset name.

test data source
Detailboolean

Detail or Summary

true
Successboolean

Indicates whether the request was successful. Value range:

  • true: The request was successful
  • false: The request failed
true

Examples

Sample success responses

JSONformat

{
  "RequestId": "78C1AA2D-9201-599E-A0BA-6FC462E57A95",
  "Result": {
    "TotalPages": 1,
    "TotalNum": 1,
    "PageNum": 1,
    "PageSize": 10,
    "Data": [
      {
        "Sid": "dtsuq3i31f5j8v848b",
        "Name": "test report",
        "Desc": "test",
        "CubeId": "d14e7448-0eb3-40d3-9375-4afef8de29fd",
        "CubeName": "test data source",
        "WorkspaceId": "7350a155-0e94-4c6c-8620-57bbec38****",
        "WorkspaceName": "test workspace",
        "GmtCreate": "2023-05-18 14:00:02.0",
        "GmtModified": "2023-03-21 18:02:36",
        "CreatorId": "7cb94cd48701",
        "CreatorName": "zhangsan",
        "ModifierId": "7cb94cd48701",
        "ModifierName": "zhangsan\n",
        "OwnerId": 862801339,
        "OwnerName": "lisi",
        "Content": {
          "ReturnFields": [
            {
              "Alias": "s_number",
              "Desc": "Theme Configuration already exists",
              "Aggregator": "SUM",
              "Orderby": "no",
              "Field": {
                "Fid": "1c1f88cb7d",
                "Name": "sss",
                "Type": "dimension",
                "Caption": "date(year)",
                "Column": "shid_star",
                "DataType": "datetime",
                "Granularity": "yearRegion"
              }
            }
          ],
          "Filter": {
            "LogicalOperator": "and",
            "Type": "basic",
            "Filters": [
              [
                {
                  "field": {
                    "fid": "1c1f88cb7d",
                    "granularity": "yearRegion",
                    "dataType": "datetime",
                    "column": "s_date",
                    "caption": "date(year)",
                    "type": "dimension"
                  },
                  "defaultValue": [
                    2024
                  ],
                  "alias": "s_date",
                  "type": "basic",
                  "operator": "equal-to",
                  "essential": true
                }
              ]
            ]
          },
          "CubeId": "56f9f34a-bdba-496a-91a3-a18b1ff73a80",
          "CubeName": "test data source",
          "Detail": true
        }
      }
    ]
  },
  "Success": true
}

Error codes

HTTP status codeError codeError messageDescription
400Internal.System.ErrorAn internal system error occurred.An internal system error occurred.
500Invalid.User.OrganizationThe user is not in your organization.The user is not in your organization.
500Invalid.Parameter.ErrorThe parameter is invalid:%s.invalid parameter: ${0}.

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