- 公共功能
- 登录注册
- 工作区
- 邀请成员
- 通讯录（用户、部门、角色）
- 应用包
- 应用分组
- 应用
- 工作台
- 应用设置（表单引擎，流程引擎，拓展设置，应用发布）
- 应用展现层
- 公式
- 个人中心
- 企业管理
- 开放平台
- 官方网站
- 子管理员
- 报表
- 门户
- 购买相关
- OCR
- 代码生成
- 数据导入
- 流程测试
- 考勤
- 农业大屏
- 应用模板商城
- 应用包上线配置
- study
- 站内信
- sand测试流程测试模板
- 测试接口
- 响水大屏
- tplus
- 协办
- 费用管控
- 首页相关内容
- pm
- 水产养殖
- 应用商城
- 联系我们
- 图零后台管理
- 知识库
- doris相关
- Ai后台管理
- CRM二
- 自建应用设置
- EHR二期
- APP应用测试
- 未命名接口GET
- 数据上报GET
获取数据集列表
开发中
POST
/
暂无描述请求参数
Authorization
在 Header 添加参数
Authorization
，其值为在 Bearer 之后拼接 Token示例：
Authorization: Bearer ********************Body 参数application/json
cmd
string
必需
param
object
必需
page
integer
必需
pageSize
integer
必需
_like_keyword
string
必需
示例
{
"cmd": "doris.data_set_list",
"param": {
"page": 1,
"pageSize": 10,
"_like_keyword": ""
}
}示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.tolink.cloud/' \
--header 'Content-Type: application/json' \
--data-raw '{
"cmd": "doris.data_set_list",
"param": {
"page": 1,
"pageSize": 10,
"_like_keyword": ""
}
}'返回响应
🟢200成功
application/json
Body
code
integer
示例：0
data
object
示例：-
result
object
新增的报表ID
msg
string
示例：操作成功
示例
{
"code": 0,
"data": {
"result": {
"rows": [
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"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",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"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": "17",
"name": "数据集名称3111",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述0",
"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": "18",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述0",
"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": "19",
"name": "数据集名称0",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述0",
"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": "21",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"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": "22",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"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": "23",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"fields": [
{
"fid": "in_month",
"label": "in_month"
},
{
"fid": "age",
"label": "age"
},
{
"fid": "level",
"label": "level"
},
{
"fid": "zhenzhi",
"label": "zhenzhi"
},
{
"fid": "hukou",
"label": "hukou"
},
{
"fid": "zhuanye",
"label": "zhuanye"
},
{
"fid": "zhuzhi",
"label": "zhuzhi"
},
{
"fid": "marry",
"label": "marry"
},
{
"fid": "xueli",
"label": "xueli"
},
{
"fid": "in_date",
"label": "in_date"
}
],
"id": "27",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"fields": [
{
"fid": "level",
"label": "级别1"
},
{
"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": "28",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
},
{
"data_source_id": "1",
"data_source_name": "name",
"description": "数据集描述3",
"fields": [
{
"fid": "level",
"label": "级别11"
},
{
"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": "29",
"name": "数据集名称3",
"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='江苏立卓信息技术有限公司'"
}
],
"total": 12
}
},
"msg": "操作成功"
}🟢200错误
修改于 2023-06-08 08:07:07