新建数据集

开发中

POST

暂无描述

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Body 参数application/json

示例

{
    "cmd": "doris.add_data_set",
    "param": {
        "data_source_id": "1",
        "name": "数据集名称",
        "description": "数据集描述",
        "sql": "select a.f3c5f6c1c as level, TIMESTAMPDIFF(YEAR,a.f2938cbe9,now()) AS age, date_format(a.f54acdae6,'%Y-%m-%d') as in_date, date_format(a.f54acdae6,'%Y-%m') as in_month, a.f92c80df9 as xueli, a.f7c240fde as zhuanye, a.f17c754cc as marry, a.f517afbfb as zhenzhi, a.f361eb454 as hukou, a.f755939b7 as zhuzhi from tb189 as a join tb189_f6fe45b19 as b on b.tb189_id=a.id join tb190 as c on c.id=b.tb190_id where c.f1114465e='江苏立卓信息技术有限公司'",
        "fields": "[{\"fid\":\"level\",\"label\":\"级别\"},{\"fid\":\"age\",\"label\":\"年龄\"},{\"fid\":\"in_date\",\"label\":\"入职日期\"},{\"fid\":\"in_month\",\"label\":\"入职年月\"},{\"fid\":\"xueli\",\"label\":\"学历\"},{\"fid\":\"zhuanye\",\"label\":\"专业\"},{\"fid\":\"marry\",\"label\":\"婚姻状况\"},{\"fid\":\"zhenzhi\",\"label\":\"政治面貌\"},{\"fid\":\"hukou\",\"label\":\"户口\"},{\"fid\":\"zhuzhi\",\"label\":\"住址\"}]"
    }
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.tolink.cloud/' \
--header 'Content-Type: application/json' \
--data-raw '{
    "cmd": "doris.add_data_set",
    "param": {
        "data_source_id": "1",
        "name": "数据集名称",
        "description": "数据集描述",
        "sql": "select a.f3c5f6c1c as level, TIMESTAMPDIFF(YEAR,a.f2938cbe9,now()) AS age, date_format(a.f54acdae6,'\''%Y-%m-%d'\'') as in_date, date_format(a.f54acdae6,'\''%Y-%m'\'') as in_month, a.f92c80df9 as xueli, a.f7c240fde as zhuanye, a.f17c754cc as marry, a.f517afbfb as zhenzhi, a.f361eb454 as hukou, a.f755939b7 as zhuzhi from tb189 as a join tb189_f6fe45b19 as b on b.tb189_id=a.id join tb190 as c on c.id=b.tb190_id where c.f1114465e='\''江苏立卓信息技术有限公司'\''",
        "fields": "[{\"fid\":\"level\",\"label\":\"级别\"},{\"fid\":\"age\",\"label\":\"年龄\"},{\"fid\":\"in_date\",\"label\":\"入职日期\"},{\"fid\":\"in_month\",\"label\":\"入职年月\"},{\"fid\":\"xueli\",\"label\":\"学历\"},{\"fid\":\"zhuanye\",\"label\":\"专业\"},{\"fid\":\"marry\",\"label\":\"婚姻状况\"},{\"fid\":\"zhenzhi\",\"label\":\"政治面貌\"},{\"fid\":\"hukou\",\"label\":\"户口\"},{\"fid\":\"zhuzhi\",\"label\":\"住址\"}]"
    }
}'

返回响应

🟢200成功

application/json

Body

示例

{}

🟢200错误

修改于 2023-06-08 08:07:07

执行SELECT

修改数据集