获取数据集数据

POST

/public-api/data-source/{dsId}/data

接口简介

该api一次最多返回5万行数据，若数据集较大，请指定过滤条件。
注：5.10.0版本以上BI开始支持该接口

请求参数

Path 参数

Header 参数

Body 参数application/json

示例

{
    "offset": 1,
    "limit": 3,
    "sortFactor": {
        "name": "id",
        "sortType": "desc"
    }
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/public-api/data-source//data' \
--header 'X-Auth-Token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxLVBBTS9VZkQwNkpQUFVCTkxacXJFcWprSHR5SXpUaCtRZmI2OHNSbFM5UnJuUFpiSmR3bFVnbHRVTnhjUmhJTVhJRnJyR0VvMzRVd3drek9RdHQ0MlhvNUhjUFJPTjVXbVUrRzZtK1ZTNTVDVjI2LzZ6NTlmMEV0UDM1ZEVLZWNSRVJBQ1hTUT0iLCJhdXRvTG9nb3V0T25DbG9zZUVuYWJsZWQiOmZhbHNlLCJpc3MiOiJndWFuZGF0YS5jb20iLCJleHAiOjE3MzM5MDUxNjEsImlhdCI6MTczMjY5NTU2MSwiaW5pdFRpbWUiOiIyMDI0LTExLTI3IDE2OjE5OjIxLjA1NSIsImp0aSI6IjExMzU3MWE4ZTE4ODI3ZTQyYmRlM2EyYWU5M2RlODc0YWFiZjAwNjM0ODNkY2E4ZDhmNGYxZjNiMTJkNjUwZTc1NDUwMTMyMWIxNzA2MjYwYjA1ZGIzZTdhZWRmZTdhMjFlNDQxNzJhYWQxZDE0OTBmZmZjZDI5NDVlODNjYjUxOWYwMmFjNjZjMmJiODQyN2IwMjY5ZmE3MmY3MWJlOGJlZDUyZGFiZWMxYzQwZjQxZmUyYmE2Nzc3NTY1NjU3YjQ5YzUxMmRkZGUwYTllYWU4ZWMzZjUzMzhhZDMzNGM2NWJjYzcwYTAwMzhiM2M2ZDUyMzkxZjM0NzVhNWVjYzciLCJwd2RWZXJzaW9uIjowLjB9.7XLS3rEZWuP7aDTBVwgmzyouVf_APlWU88ZsFGvrCJI' \
--header 'Content-Type: application/json' \
--data-raw '{
    "offset": 1,
    "limit": 3,
    "sortFactor": {
        "name": "id",
        "sortType": "desc"
    }
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "result": "ok",
    "response": {
        "dsId": "v2a769c4be17d4ec8b77b2b2",
        "name": "对比订阅测试",
        "displayType": "EXCEL",
        "storageId": "v2a769c4be17d4ec8b77b2b2",
        "domId": "testing",
        "uId": "h2afb13f76d4843e298e4f4f",
        "parentDirId": "efae4f1696f024d599bba4f0",
        "rowCount": 6,
        "colCount": 4,
        "status": "FINISHED",
        "columns": [
            {
                "name": "省",
                "fdType": "STRING",
                "dsId": "v2a769c4be17d4ec8b77b2b2",
                "fdId": "teebf36bc63d94e7ebe6b4bc",
                "metaType": "DIM",
                "seqNo": 0,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "annotation": "",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            },
            {
                "name": "性别",
                "fdType": "STRING",
                "dsId": "v2a769c4be17d4ec8b77b2b2",
                "fdId": "o0ed08788ea9949909986db2",
                "metaType": "DIM",
                "seqNo": 1,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "annotation": "",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            },
            {
                "name": "订单数",
                "fdType": "LONG",
                "dsId": "v2a769c4be17d4ec8b77b2b2",
                "fdId": "j9a566f3ee11144f9a5f9f8e",
                "metaType": "METRIC",
                "seqNo": 2,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "annotation": "",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            },
            {
                "name": "客单价",
                "fdType": "LONG",
                "dsId": "v2a769c4be17d4ec8b77b2b2",
                "fdId": "eedec668e19c34b578687e34",
                "metaType": "METRIC",
                "seqNo": 3,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "annotation": "",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            }
        ],
        "ctime": "2024-10-09 18:53:36+0800",
        "utime": "2024-10-11 09:47:50+0800",
        "version": 2,
        "cardCount": 1,
        "preview": [
            [
                "浙江",
                "男",
                "1",
                "3"
            ],
            [
                "浙江",
                "女",
                "2",
                "4"
            ],
            [
                "上海",
                "男",
                "5",
                "7"
            ],
            [
                "上海",
                "女",
                "6",
                "8"
            ],
            [
                "江苏",
                "男",
                "2",
                "3"
            ],
            [
                "江苏",
                "女",
                "5",
                "3"
            ]
        ]
    }
}

修改于 2025-07-16 03:18:58

下载数据集数据

创建数据集