集简云开放平台
  1. 数据表
集简云开放平台
  • SDK/API嵌入方案说明(请先阅读)
  • 通用功能
    • 接口签名sign计算说明
  • SDK嵌入方账户相关(前端组件嵌入)
    • SDK嵌入方案介绍
    • 前端SDK在线示例与Demo文件
    • 获取个性化设置
      POST
  • API嵌入方案(后端接口嵌入)
    • 使用说明
    • 步骤1:换取企业凭证+同步用户
      • 说明
      • 获取企业凭证corp_token
      • 请求开通企业
      • 新增用户到企业
      • 获取用户user_token
    • 步骤3: 获取应用动作需要字段参数
      • 获取dynamic字段
      • 获取动作可用字段
    • 步骤4:执行指定应用动作
      • 执行动作(嵌入方案)
    • 高级:流程创建
      • 使用说明
      • 创建或更新流程
      • 更新流程状态
      • 获取企业下流程列表
      • 获取页面信息
    • 企业成员相关
      • 查询企业内成员
      • 修改成员
      • 新增用户到企业
    • 企业费用相关
      • 查询嵌入方余额
      • 查询指定企业付费版本
      • 查询指定企业使用量与余额
      • 查询指定企业使用量
    • 企业账号授权相关
      • 查询指定应用授权时需要添加的字段列表
      • 添加授权到指定用户下的指定应用
      • 获取企业下绑定账号列表
      • 查询可用应用列表
      • 根据应用ID获取动作列表
  • 前端页面嵌入(ifram嵌入)方案
    • 使用说明
    • 请求开通企业
      POST
    • 获取用户user_token (指定企业的iframe登录权限)
      POST
  • 子流程对接方案相关
    • 说明
    • 子流程接口访问凭证
      POST
    • 查询子流程列表
      POST
    • 触发子流程
      POST
    • 查询指定子流程
      POST
    • 删除流程
      POST
  • 数据表
    • 接口调用说明
    • 获取项目下表数据
      GET
    • 获取所有项目
      GET
    • 获取表字段信息
      GET
    • 获取表数据
      POST
    • 新增行数据
      POST
    • 修改行数据
      POST
    • 删除行数据
      POST
  1. 数据表

获取所有项目

测试中
GET
/v1/api/datatable/openapi/projects

请求参数

Header 参数
data-table-apikey
string 
可选
示例值:
8Fa3Qljb90dsNgT4

示例代码

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://developer.jijyun.cn/v1/api/datatable/openapi/projects'

返回响应

🟢200成功
application/json
Body
Code
integer 
必需
Msg
string 
必需
Data
array [object {5}] 
必需
row_id
string 
必需
行id,其他接口参数project_id的值
project_name
string 
项目名称
必需
icon
string  | null 
icon
必需
subhead
string  | null 
项目描述信息
必需
create_time
string 
项目创建时间
必需
示例
{"Code":2000,"Msg":"成功","Data":[{"row_id":"BJMNXR1687241335149535361","project_name":"中原测试1","icon":"34","subhead":"","create_time":"2023-06-20T14:08:55"},{"row_id":"DJCHEB1687744015699262842","project_name":"测试项目","icon":"31","subhead":"","create_time":"2023-06-26T09:46:55"},{"row_id":"DQSITR1692694634477582340","project_name":"测试项目","icon":"26","subhead":"","create_time":"2023-08-22T16:57:14"},{"row_id":"DUKQLI1704873437976719829","project_name":"123","icon":"24","subhead":"","create_time":"2024-01-10T15:57:17"},{"row_id":"EQXVRW1688092707283989376","project_name":"AI图像创作","icon":null,"subhead":"在表格中输入图像创作命令,即可自动完成文字生成图片、以图生图、图像清晰度调整等任务,释放你的创作激情","create_time":"2023-10-26T16:27:24"},{"row_id":"FZBUVJ1704873460371656198","project_name":"222","icon":"26","subhead":"","create_time":"2024-01-10T15:57:40"},{"row_id":"IALSGN1694483346708278638","project_name":"流量","icon":null,"subhead":null,"create_time":"2023-09-12T09:49:06"},{"row_id":"JQRFTD1693558199123628092","project_name":"测试","icon":null,"subhead":"测试","create_time":"2023-09-01T16:49:59"},{"row_id":"KSHDGA1692693876256055213","project_name":"杨红霞测试项目","icon":"21","subhead":"","create_time":"2023-08-22T16:44:36"},{"row_id":"LCPJKU1687169813439975287","project_name":"微信公众号ChatGPT对话存储","icon":null,"subhead":"当有用户在公众号后台留言时,如果消息内容包含咨询产品、服务的相关关键词,使用ChatGPT文档问答的文档训练集来针对性解答用户问题。如果消息不包含关键词,则使用ChatGPT的上下文对话功能,让公众号智能回复用户。同时将对话信息存储到集简云数据表,方便后续查找回顾。","create_time":"2023-10-25T17:54:14"},{"row_id":"LWITOZ1694162803242781064","project_name":"流量","icon":null,"subhead":null,"create_time":"2023-09-08T16:46:43"},{"row_id":"MXPTWE1684894356526830464","project_name":"默认表测试","icon":"32","subhead":"","create_time":"2023-05-24T10:12:36"},{"row_id":"NDEHIW1694142922696785084","project_name":"流量123","icon":null,"subhead":null,"create_time":"2023-09-08T11:15:22"},{"row_id":"NJSEXI1689917455407625108","project_name":"工资管理","icon":"26","subhead":"","create_time":"2023-07-21T13:30:55"},{"row_id":"OWSPUX1710754159419343344","project_name":"123","icon":"31","subhead":"","create_time":"2024-03-18T17:29:19"},{"row_id":"QWNXGL1685424859954698498","project_name":"拍照自动识别发票信息并录入到表格","icon":null,"subhead":"财务人员往往需要手动将发票信息录入到表格内,费时费力,通过此流程模板可以实现拍照即可将发票信息自动同步至表格内。","create_time":"2023-06-16T15:59:06"},{"row_id":"RWZXGO1686131823143149771","project_name":"646565","icon":null,"subhead":null,"create_time":"2023-06-07T17:57:03"},{"row_id":"SPGLJY1694503048120138659","project_name":"流量","icon":null,"subhead":null,"create_time":"2023-09-12T15:17:28"},{"row_id":"SYPIXK1694165582214873984","project_name":"转译测试","icon":null,"subhead":"测试","create_time":"2023-09-08T17:33:02"},{"row_id":"SZHPXU1686032736315558958","project_name":"客户管理","icon":"24","subhead":"","create_time":"2023-06-06T14:25:36"},{"row_id":"TFUJPH1711523136757594680","project_name":"东铭测试项目","icon":"13","subhead":"","create_time":"2024-03-27T15:05:36"},{"row_id":"VAJZIK1713318125970631791","project_name":"cxf测试","icon":"33","subhead":"","create_time":"2024-04-17T09:42:05"},{"row_id":"WEHRPN1706769132629091029","project_name":"等等","icon":"34","subhead":"","create_time":"2024-02-01T14:32:12"},{"row_id":"WMBKCQ1693377113460625315","project_name":"测试打印模板","icon":"36","subhead":"","create_time":"2023-08-30T14:31:53"},{"row_id":"WPOBNG1689329114686433537","project_name":"574","icon":"13","subhead":"","create_time":"2023-07-14T18:05:14"},{"row_id":"YVQKWB1693558228655874390","project_name":"测试AAA","icon":null,"subhead":"测试","create_time":"2023-09-01T16:50:28"},{"row_id":"ZPBLKN1694155662792333619","project_name":"辅导费","icon":null,"subhead":null,"create_time":"2023-09-08T14:47:42"}]}
修改于 2024-05-24 01:55:54
上一页
获取项目下表数据
下一页
获取表字段信息
Built with