修改数据集

开发中

POST

暂无描述

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

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

Body 参数application/json

cmd

string

命令

必需

param

object

必需

data_source_id

string

数据源ID

必需

name

string

报表名称

必需

description

string

数据集描述

必需

sql

string

SQL语句

必需

fields

string

字段备注

必需

string

必需

示例

{
  "cmd": "doris.mod_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\":\"住址\"}]",
    "id": "8"
  }
}

示例代码

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.mod_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\":\"住址\"}]",
        "id": "8"
    }
}'

返回响应

🟢200成功

application/json

Body

object {0}

示例

{}

🟢200错误

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

新建数据集

删除数据集