数据集预览接口（支持筛选行数据

POST

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

请求参数

Path 参数

Header 参数

Body 参数application/json

示例

{
  "offset": 0,
  "limit": 1000,
  "filter": {
    "combineType": "AND",
    "conditions": [
      {
        "not": false,
        "type": "condition",
        "value": {
          "name": "id",
          "filterType": "GT",
          "filterValue": ["1"]
        }
      }
    ]
  }
}

请求示例代码

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;' \
--header 'Content-Type: application/json' \
--data-raw '{
  "offset": 0,
  "limit": 1000,
  "filter": {
    "combineType": "AND",
    "conditions": [
      {
        "not": false,
        "type": "condition",
        "value": {
          "name": "id",
          "filterType": "GT",
          "filterValue": ["1"]
        }
      }
    ]
  }
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "result": "ok",
    "response": {
        "dsId": "f8002e3f5801743cc930e551",
        "name": "测试excel",
        "displayType": "MYSQL",
        "storageId": "f8002e3f5801743cc930e551",
        "domId": "demo",
        "uId": "b1766b1ac99bf4679a1bd762",
        "parentDirId": "bbf86c8c533064a34a972bf7",
        "cnId": "mysql",
        "acId": "c73a5244dffce4c41b138ab0",
        "rowCount": 1,
        "colCount": 2,
        "status": "FINISHED",
        "columns": [// 字段信息
            {
                "name": "id",
                "fdType": "INT",
                "dsId": "f8002e3f5801743cc930e551",
                "fdId": "k4936dfe957a0406c9379040",
                "metaType": "METRIC",
                "seqNo": 0,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            },
            {
                "name": "value",
                "fdType": "STRING",
                "dsId": "f8002e3f5801743cc930e551",
                "fdId": "k13d0bcc0fb61465ca9bbd9e",
                "metaType": "DIM",
                "seqNo": 1,
                "isAggregated": false,
                "calculationType": "normal",
                "level": "dataset",
                "isDetectionSensitive": false,
                "isSensitive": false,
                "isRestricted": false
            }
        ],
        "ctime": "2024-03-18 11:30:36+0800",
        "utime": "2024-03-19 19:10:27+0800",
        "version": 4,
        "cardCount": 0,
        "preview": [ // data 信息，顺序按照columns里的字段顺序排列
            [
                "1",
                "xxx"
            ]
        ]
    }
}

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

数据集删除

提供修改SQL模型结构接口