• 当前模板排行信息
  • 周排行
  • 月排行
  • 季度排行
  • 年度排行

    教学视频

    案例文章

推荐的的流程模板
请稍后...
自定义您的业务流程
选择的触发与执行动作,建立自动化的业务流程。
当这个情况发生时触发动作
  • 当审批任务开始时
    当钉钉(自建应用)有审批任务开始时,触发流程
  • 当审批任务转交时
    当钉钉(自建应用)有审批任务转交时,触发流程
  • 当审批任务结束时
    当钉钉(自建应用)有审批任务结束时,触发流程
  • 当审批流程开始时
    当钉钉(自建应用)有审批任务开始时,触发流程
  • 当审批流程结束时
    当钉钉(自建应用)有审批流程结束时,触发流程
  • 当员工打卡时
    当钉钉(自建应用)有员工打卡时,触发流程
  • 当员工排班变更时
    当钉钉(自建应用)有员工排班变更时,触发流程
  • 当员工加班时
    当钉钉(自建应用)有员工加班时,触发流程
  • 群会话添加成员时
    当钉钉(自建应用)有群会话添加成员时,触发流程
  • 群会话用户主动退群时
    当钉钉(自建应用)有群会话用户主动退群时,触发流程
  • 当智能表单有新增数据时
    当钉钉(自建应用)有智能表单有新增数据时,触发流程
  • 当有日志新增时
    当有日志新增时流程触发
  • 当指定部门有新员工加入时
    当指定部门有新员工加入时
  • 当有新的待入职员工时
    当有新的待入职员工时同步数据并触发流程
  • 当通讯录中有人员增加时
    当通讯录中有人员增加时
  • 当通讯录中有人员信息被修改时
    当通讯录中有人员信息被修改时
  • 当群会话解散群时
    API创建的企业群,当企业群会话解散群时,触发此事件
  • 当符合条件的审批任务结束时
    当符合条件的审批任务结束时
  • 当符合条件的审批流实例结束时
    当符合条件的审批流实例结束时
  • 当有客户新增时
    当有客户新增时
  • 当有联系人新增时
    当有企业客户更新时
  • 当有跟进记录新增时
    当有个人客户新增时
  • 当有员工离职时
    当有员工离职时
  • 有数据新增时
    当SqlServer有新数据增加时触发流程
  • 有符合条件的数据新增时
    当SqlServer有符合条件的数据新增时触发流程
做这件事情执行动作
  • 发送文本消息
    通过输入指定成员ID发送文本
  • 发送Markdown
    通过输入指定成员ID发送Markdown消息
  • 发送文本通知
    发送部门或全体的文本格式通知(通过下拉列表或插入数据方式)
  • 发送markdown通知
    发送部门或全体的Markdown格式通知(通过下拉列表或插入数据方式)
  • 发送文本通知给部门内指定成员
    发送文本通知给部门内指定成员(通过下拉列表或插入数据方式)
  • 发送Markdown通知给部门内指定
    发送Markdown通知给部门内指定成员(通过下拉列表或插入数据方式)
  • 根据员工手机号查询员工ID
    钉钉(自建应用)根据员工手机号查询员工ID
  • 发起待办事项
    钉钉(自建应用)发起待办事项
  • 查询审批实例详情
    钉钉(自建应用)查询审批实例详情
  • 创建日程
    当系统有新增计划或任务时客自动创建日程
  • 创建日志
    当系统有新任务时自动创建日志
  • 获取日志模板详情
    当有新增日志时,获取日志模板详情
  • 使用服务助手推送消息
    使用服务助手推送消息
  • 创建视频会议
    创建视频会议,用户可以自定义会议主题,邀请参会人员
  • 关闭视频会议
    调用本接口关闭视频会议,仅限该会议的主持人有关闭视频会议的权限
  • 批量查询视频会议信息
    查询会议信息以及参会人员,目前只支持查询正在进行的会议
  • 创建新用户
    创建新用户
  • 更新指定用户信息
    更新指定的用户信息
  • 同意或拒绝审批任务
    根据指定模板ID、实例ID、审批节点ID和审批人,对单个审批任务进行处理
  • 获取审批实例ID列表
    调用本接口获取权限范围内的相关部门审批实例ID列表
  • 发起审批实例
    在钉钉中发起一个审批实例
  • 查询用户详情
    使用用户id查询用户的详细信息
  • 获取员工花名册字段信息
    获取员工花名册字段信息
  • 更新员工花名册信息
    更新智能人事中花名册信息
  • 批量获取员工离职信息
    批量获取智能人事员工离职信息
  • 创建群会话
    创建新的群会话
  • 获取群会话信息
    获取群设置和成员信息
  • 修改群会话
    修改群设置和群成员信息
  • 发起审批实例1.0.1
    基于执行动作发起审批实例兼容了表单明细控件的功能
  • 创建审批模板
    创建审批模板
  • 获取在职员工列表
    获取在职员工列表
  • 创建个人或企业客户
    创建个人或企业客户
  • 批量新增联系人数据
    批量新增联系人数据
  • 删除用户
    删除用户
  • 查询审批实例详情1.0.1
    查询审批实例详情(新抹平)
  • 查询审批实例详情1.0.2
    使用钉钉自建应用询审批实例详情(兼容表格抹平)
  • 撤销审批实例
    根据审批实例id撤销发起的审批实例
  • 新增数据
    向SQL数据库中添加数据信息
  • 更新数据
    更新SQL数据库中的数据信息
  • 查询数据
    在SqlServer查询数据
  • 批量查询数据
    通过多条件字段组合查询数据
  • 批量新建数据
    一次在数据库中插入多条数据
  • 执行SQL语句
    在数据库中执行自定义的SQL语句
  • 模糊搜索数据
    搜索字段中包含指定值的数据列表
  • 通过文本分隔符拆分并循环执行
    当外部系统有查询任务时,通过循环执行汇总查询信息
  • 通过数组拆分并循环执行
    通过数组拆分并循环执行
  • 通过数字拆分并执行流程
    按照用户设定的数字控制后续循环次数依次执行流程
  • 汇总循环内数据
    将循环内的数据按照每次循环任务执行的结果进行汇总输出为一个数组 可以在后续步骤中插入数组使用
开始创建吧
立即创建使用
相关文章
查看更多>
  • week 100+
  • month 100+
  • quarter 100+
  • year 100+
  • user_name 张守琚
  • used_count 0
  • shared_tem_count 57
  • Code 2212 钉钉同步审批数据至SQL Server数据库 <p>钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据</p> zh-Hans 2023-01-18T08:19:03.000Z 2023-01-18T08:19:03.000Z 2023-01-18T08:23:47.000Z br4815gv 钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据 anyone i47FxenAtG0W official lk5246 passed 张守琚 br4815gv 张守琚 [ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "app_id": 69, "action_id": 3045, "action_type": "2", "sort": "2", "note": null }, { "desc": "使用钉钉自建应用根据用户id查询用户的详细信息", "app_id": 69, "action_id": 1953, "action_type": "2", "sort": "3", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "4", "note": null }, { "desc": "通过数组对字段值进行拆分,或通过数组对其中的数据集进行拆分,拆分后将逐个输出字段值或输出数组中的数据集的字段", "app_id": 131, "action_id": 1427, "action_type": "2", "sort": "5", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "6", "note": null } ] 0 false 5 { "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [ { "key": "userid", "label": "用户的userId", "type": "string", "required": true, "help_txt": "示例:manager4220,可通过[查询员工ID]动作获取到用户的id" }, { "key": "language", "label": "通讯录语言", "type": "string", "dropdown": true, "choices": [ { "key": "zh_CN", "label": "中文" }, { "key": "en_US", "label": "英文" } ], "help_txt": "默认值为中文" } ], "4": [ { "label": "A75253", "key": "A75253" }, { "label": "A75254", "key": "A75254" }, { "label": "A75255", "key": "A75255" }, { "label": "A75256", "key": "A75256" }, { "label": "A75257", "key": "A75257" }, { "label": "A75258", "key": "A75258" }, { "label": "A75259", "key": "A75259" }, { "label": "A75260", "key": "A75260" }, { "label": "A75261", "key": "A75261" }, { "label": "A75262", "key": "A75262" }, { "label": "A75263", "key": "A75263" }, { "label": "A75264", "key": "A75264" }, { "label": "A75265", "key": "A75265" }, { "label": "A75291", "key": "A75291" }, { "label": "A75292", "key": "A75292" }, { "label": "A75293", "key": "A75293" }, { "label": "A75294", "key": "A75294" }, { "label": "A75295", "key": "A75295" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://thoughts.teambition.com/sharespace/5f48d064ccddd8001666ccb5/docs/622088a509c7700041a57c9b\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "A75253", "key": "A75253" }, { "label": "A75267", "key": "A75267" }, { "label": "A75268", "key": "A75268" }, { "label": "A75269", "key": "A75269" }, { "label": "A75270", "key": "A75270" }, { "label": "A75271", "key": "A75271" }, { "label": "A75272", "key": "A75272" }, { "label": "A75273", "key": "A75273" }, { "label": "A75274", "key": "A75274" }, { "label": "A75275", "key": "A75275" }, { "label": "A75276", "key": "A75276" }, { "label": "A75277", "key": "A75277" }, { "label": "A75278", "key": "A75278" }, { "label": "A75279", "key": "A75279" }, { "label": "A75280", "key": "A75280" }, { "label": "A75281", "key": "A75281" }, { "label": "A75282", "key": "A75282" }, { "label": "A75283", "key": "A75283" }, { "label": "A75284", "key": "A75284" }, { "label": "A75285", "key": "A75285" }, { "label": "A75286", "key": "A75286" }, { "label": "A75287", "key": "A75287" }, { "label": "A75288", "key": "A75288" }, { "label": "A75289", "key": "A75289" }, { "label": "A75290", "key": "A75290" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ] } [] [] [ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-17T10:24:09.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": 131, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 24, "name": "SQL Server", "description": "<p>Microsoft SQL Server 是一个全面的数据库平台,使用集成的商业智能 (BI)工具提供了企业级的数据管理。其数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能,使您可以构建和管理用于业务的高可用和高性能的数据应用程序。</p>", "popular": 170, "published_at": "2021-10-25T03:00:51.000Z", "created_at": "2021-10-25T03:00:49.000Z", "updated_at": "2022-06-13T08:56:00.000Z", "app_id": "62", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库管理平台", "available": true, "appid": null, "website": "https://www.microsoft.com/zh-cn/sql-server", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1851, "name": "SQL Server.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "SQL_Server_cfd0d1ff2d", "ext": ".svg", "mime": "image/svg+xml", "size": 57.08, "url": "/uploads/SQL_Server_cfd0d1ff2d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T03:01:08.000Z", "updated_at": "2022-01-26T03:01:08.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "批量同步数据", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } } ] [ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 302, "key": null, "published_at": "2021-11-29T09:04:33.000Z", "created_at": "2021-11-29T09:04:31.000Z", "updated_at": "2021-11-29T09:04:33.000Z", "action_id": "138", "action_name": "新增数据", "error": null, "description": "向SQL数据库中添加数据信息", "action_type": "action", "app": null, "template": null }, { "id": 1208, "key": null, "published_at": "2022-03-10T11:38:47.000Z", "created_at": "2022-03-10T11:38:47.000Z", "updated_at": "2022-03-10T11:38:47.000Z", "action_id": "1427", "action_name": "通过数组拆分并循环执行", "error": null, "description": "通过数组拆分并循环执行", "action_type": "action", "app": null, "template": null }, { "id": 2001, "key": null, "published_at": "2022-06-02T11:30:22.000Z", "created_at": "2022-06-02T11:30:22.000Z", "updated_at": "2022-06-02T11:30:22.000Z", "action_id": "1953", "action_name": "查询用户详情", "error": null, "description": "使用用户id查询用户的详细信息", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 4006, "key": null, "published_at": "2022-11-10T01:29:28.000Z", "created_at": "2022-11-10T01:29:28.000Z", "updated_at": "2022-11-10T01:29:28.000Z", "action_id": "3045", "action_name": "查询审批实例详情1.0.2", "error": null, "description": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "action_type": "action", "app": null, "template": null } ] [] [] 100+ 100+ 100+ 100+ 57
  • Msg 2212 钉钉同步审批数据至SQL Server数据库 <p>钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据</p> zh-Hans 2023-01-18T08:19:03.000Z 2023-01-18T08:19:03.000Z 2023-01-18T08:23:47.000Z br4815gv 钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据 anyone i47FxenAtG0W official lk5246 passed 张守琚 br4815gv 张守琚 [ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "app_id": 69, "action_id": 3045, "action_type": "2", "sort": "2", "note": null }, { "desc": "使用钉钉自建应用根据用户id查询用户的详细信息", "app_id": 69, "action_id": 1953, "action_type": "2", "sort": "3", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "4", "note": null }, { "desc": "通过数组对字段值进行拆分,或通过数组对其中的数据集进行拆分,拆分后将逐个输出字段值或输出数组中的数据集的字段", "app_id": 131, "action_id": 1427, "action_type": "2", "sort": "5", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "6", "note": null } ] 0 false 5 { "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [ { "key": "userid", "label": "用户的userId", "type": "string", "required": true, "help_txt": "示例:manager4220,可通过[查询员工ID]动作获取到用户的id" }, { "key": "language", "label": "通讯录语言", "type": "string", "dropdown": true, "choices": [ { "key": "zh_CN", "label": "中文" }, { "key": "en_US", "label": "英文" } ], "help_txt": "默认值为中文" } ], "4": [ { "label": "A75253", "key": "A75253" }, { "label": "A75254", "key": "A75254" }, { "label": "A75255", "key": "A75255" }, { "label": "A75256", "key": "A75256" }, { "label": "A75257", "key": "A75257" }, { "label": "A75258", "key": "A75258" }, { "label": "A75259", "key": "A75259" }, { "label": "A75260", "key": "A75260" }, { "label": "A75261", "key": "A75261" }, { "label": "A75262", "key": "A75262" }, { "label": "A75263", "key": "A75263" }, { "label": "A75264", "key": "A75264" }, { "label": "A75265", "key": "A75265" }, { "label": "A75291", "key": "A75291" }, { "label": "A75292", "key": "A75292" }, { "label": "A75293", "key": "A75293" }, { "label": "A75294", "key": "A75294" }, { "label": "A75295", "key": "A75295" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://thoughts.teambition.com/sharespace/5f48d064ccddd8001666ccb5/docs/622088a509c7700041a57c9b\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "A75253", "key": "A75253" }, { "label": "A75267", "key": "A75267" }, { "label": "A75268", "key": "A75268" }, { "label": "A75269", "key": "A75269" }, { "label": "A75270", "key": "A75270" }, { "label": "A75271", "key": "A75271" }, { "label": "A75272", "key": "A75272" }, { "label": "A75273", "key": "A75273" }, { "label": "A75274", "key": "A75274" }, { "label": "A75275", "key": "A75275" }, { "label": "A75276", "key": "A75276" }, { "label": "A75277", "key": "A75277" }, { "label": "A75278", "key": "A75278" }, { "label": "A75279", "key": "A75279" }, { "label": "A75280", "key": "A75280" }, { "label": "A75281", "key": "A75281" }, { "label": "A75282", "key": "A75282" }, { "label": "A75283", "key": "A75283" }, { "label": "A75284", "key": "A75284" }, { "label": "A75285", "key": "A75285" }, { "label": "A75286", "key": "A75286" }, { "label": "A75287", "key": "A75287" }, { "label": "A75288", "key": "A75288" }, { "label": "A75289", "key": "A75289" }, { "label": "A75290", "key": "A75290" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ] } [] [] [ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-17T10:24:09.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": 131, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 24, "name": "SQL Server", "description": "<p>Microsoft SQL Server 是一个全面的数据库平台,使用集成的商业智能 (BI)工具提供了企业级的数据管理。其数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能,使您可以构建和管理用于业务的高可用和高性能的数据应用程序。</p>", "popular": 170, "published_at": "2021-10-25T03:00:51.000Z", "created_at": "2021-10-25T03:00:49.000Z", "updated_at": "2022-06-13T08:56:00.000Z", "app_id": "62", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库管理平台", "available": true, "appid": null, "website": "https://www.microsoft.com/zh-cn/sql-server", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1851, "name": "SQL Server.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "SQL_Server_cfd0d1ff2d", "ext": ".svg", "mime": "image/svg+xml", "size": 57.08, "url": "/uploads/SQL_Server_cfd0d1ff2d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T03:01:08.000Z", "updated_at": "2022-01-26T03:01:08.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "批量同步数据", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } } ] [ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 302, "key": null, "published_at": "2021-11-29T09:04:33.000Z", "created_at": "2021-11-29T09:04:31.000Z", "updated_at": "2021-11-29T09:04:33.000Z", "action_id": "138", "action_name": "新增数据", "error": null, "description": "向SQL数据库中添加数据信息", "action_type": "action", "app": null, "template": null }, { "id": 1208, "key": null, "published_at": "2022-03-10T11:38:47.000Z", "created_at": "2022-03-10T11:38:47.000Z", "updated_at": "2022-03-10T11:38:47.000Z", "action_id": "1427", "action_name": "通过数组拆分并循环执行", "error": null, "description": "通过数组拆分并循环执行", "action_type": "action", "app": null, "template": null }, { "id": 2001, "key": null, "published_at": "2022-06-02T11:30:22.000Z", "created_at": "2022-06-02T11:30:22.000Z", "updated_at": "2022-06-02T11:30:22.000Z", "action_id": "1953", "action_name": "查询用户详情", "error": null, "description": "使用用户id查询用户的详细信息", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 4006, "key": null, "published_at": "2022-11-10T01:29:28.000Z", "created_at": "2022-11-10T01:29:28.000Z", "updated_at": "2022-11-10T01:29:28.000Z", "action_id": "3045", "action_name": "查询审批实例详情1.0.2", "error": null, "description": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "action_type": "action", "app": null, "template": null } ] [] [] 100+ 100+ 100+ 100+ 57
  • Data 2212 钉钉同步审批数据至SQL Server数据库 <p>钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据</p> zh-Hans 2023-01-18T08:19:03.000Z 2023-01-18T08:19:03.000Z 2023-01-18T08:23:47.000Z br4815gv 钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据 anyone i47FxenAtG0W official lk5246 passed 张守琚 br4815gv 张守琚 [ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "app_id": 69, "action_id": 3045, "action_type": "2", "sort": "2", "note": null }, { "desc": "使用钉钉自建应用根据用户id查询用户的详细信息", "app_id": 69, "action_id": 1953, "action_type": "2", "sort": "3", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "4", "note": null }, { "desc": "通过数组对字段值进行拆分,或通过数组对其中的数据集进行拆分,拆分后将逐个输出字段值或输出数组中的数据集的字段", "app_id": 131, "action_id": 1427, "action_type": "2", "sort": "5", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "6", "note": null } ] 0 false 5 { "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [ { "key": "userid", "label": "用户的userId", "type": "string", "required": true, "help_txt": "示例:manager4220,可通过[查询员工ID]动作获取到用户的id" }, { "key": "language", "label": "通讯录语言", "type": "string", "dropdown": true, "choices": [ { "key": "zh_CN", "label": "中文" }, { "key": "en_US", "label": "英文" } ], "help_txt": "默认值为中文" } ], "4": [ { "label": "A75253", "key": "A75253" }, { "label": "A75254", "key": "A75254" }, { "label": "A75255", "key": "A75255" }, { "label": "A75256", "key": "A75256" }, { "label": "A75257", "key": "A75257" }, { "label": "A75258", "key": "A75258" }, { "label": "A75259", "key": "A75259" }, { "label": "A75260", "key": "A75260" }, { "label": "A75261", "key": "A75261" }, { "label": "A75262", "key": "A75262" }, { "label": "A75263", "key": "A75263" }, { "label": "A75264", "key": "A75264" }, { "label": "A75265", "key": "A75265" }, { "label": "A75291", "key": "A75291" }, { "label": "A75292", "key": "A75292" }, { "label": "A75293", "key": "A75293" }, { "label": "A75294", "key": "A75294" }, { "label": "A75295", "key": "A75295" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://thoughts.teambition.com/sharespace/5f48d064ccddd8001666ccb5/docs/622088a509c7700041a57c9b\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "A75253", "key": "A75253" }, { "label": "A75267", "key": "A75267" }, { "label": "A75268", "key": "A75268" }, { "label": "A75269", "key": "A75269" }, { "label": "A75270", "key": "A75270" }, { "label": "A75271", "key": "A75271" }, { "label": "A75272", "key": "A75272" }, { "label": "A75273", "key": "A75273" }, { "label": "A75274", "key": "A75274" }, { "label": "A75275", "key": "A75275" }, { "label": "A75276", "key": "A75276" }, { "label": "A75277", "key": "A75277" }, { "label": "A75278", "key": "A75278" }, { "label": "A75279", "key": "A75279" }, { "label": "A75280", "key": "A75280" }, { "label": "A75281", "key": "A75281" }, { "label": "A75282", "key": "A75282" }, { "label": "A75283", "key": "A75283" }, { "label": "A75284", "key": "A75284" }, { "label": "A75285", "key": "A75285" }, { "label": "A75286", "key": "A75286" }, { "label": "A75287", "key": "A75287" }, { "label": "A75288", "key": "A75288" }, { "label": "A75289", "key": "A75289" }, { "label": "A75290", "key": "A75290" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ] } [] [] [ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-17T10:24:09.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": 131, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 24, "name": "SQL Server", "description": "<p>Microsoft SQL Server 是一个全面的数据库平台,使用集成的商业智能 (BI)工具提供了企业级的数据管理。其数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能,使您可以构建和管理用于业务的高可用和高性能的数据应用程序。</p>", "popular": 170, "published_at": "2021-10-25T03:00:51.000Z", "created_at": "2021-10-25T03:00:49.000Z", "updated_at": "2022-06-13T08:56:00.000Z", "app_id": "62", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库管理平台", "available": true, "appid": null, "website": "https://www.microsoft.com/zh-cn/sql-server", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1851, "name": "SQL Server.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "SQL_Server_cfd0d1ff2d", "ext": ".svg", "mime": "image/svg+xml", "size": 57.08, "url": "/uploads/SQL_Server_cfd0d1ff2d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T03:01:08.000Z", "updated_at": "2022-01-26T03:01:08.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "批量同步数据", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } } ] [ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 302, "key": null, "published_at": "2021-11-29T09:04:33.000Z", "created_at": "2021-11-29T09:04:31.000Z", "updated_at": "2021-11-29T09:04:33.000Z", "action_id": "138", "action_name": "新增数据", "error": null, "description": "向SQL数据库中添加数据信息", "action_type": "action", "app": null, "template": null }, { "id": 1208, "key": null, "published_at": "2022-03-10T11:38:47.000Z", "created_at": "2022-03-10T11:38:47.000Z", "updated_at": "2022-03-10T11:38:47.000Z", "action_id": "1427", "action_name": "通过数组拆分并循环执行", "error": null, "description": "通过数组拆分并循环执行", "action_type": "action", "app": null, "template": null }, { "id": 2001, "key": null, "published_at": "2022-06-02T11:30:22.000Z", "created_at": "2022-06-02T11:30:22.000Z", "updated_at": "2022-06-02T11:30:22.000Z", "action_id": "1953", "action_name": "查询用户详情", "error": null, "description": "使用用户id查询用户的详细信息", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 4006, "key": null, "published_at": "2022-11-10T01:29:28.000Z", "created_at": "2022-11-10T01:29:28.000Z", "updated_at": "2022-11-10T01:29:28.000Z", "action_id": "3045", "action_name": "查询审批实例详情1.0.2", "error": null, "description": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "action_type": "action", "app": null, "template": null } ] [] [] 100+ 100+ 100+ 100+ 57
  • permission 2212 钉钉同步审批数据至SQL Server数据库 <p>钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据</p> zh-Hans 2023-01-18T08:19:03.000Z 2023-01-18T08:19:03.000Z 2023-01-18T08:23:47.000Z br4815gv 钉钉当符合条件的审批流实例结束时,执行动作查询审批实例详情,查询用户详情获取用户ID,SQL Server新增数据,循环执行通过数组拆分并循环执行,将钉钉审批里明细表格内的数据同步至SQL Server新增数据 anyone i47FxenAtG0W official lk5246 passed 张守琚 br4815gv 张守琚 [ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "app_id": 69, "action_id": 3045, "action_type": "2", "sort": "2", "note": null }, { "desc": "使用钉钉自建应用根据用户id查询用户的详细信息", "app_id": 69, "action_id": 1953, "action_type": "2", "sort": "3", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "4", "note": null }, { "desc": "通过数组对字段值进行拆分,或通过数组对其中的数据集进行拆分,拆分后将逐个输出字段值或输出数组中的数据集的字段", "app_id": 131, "action_id": 1427, "action_type": "2", "sort": "5", "note": null }, { "desc": "向SQL数据库中添加数据信息", "app_id": 62, "action_id": 138, "action_type": "2", "sort": "6", "note": null } ] 0 false 5 { "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [ { "key": "userid", "label": "用户的userId", "type": "string", "required": true, "help_txt": "示例:manager4220,可通过[查询员工ID]动作获取到用户的id" }, { "key": "language", "label": "通讯录语言", "type": "string", "dropdown": true, "choices": [ { "key": "zh_CN", "label": "中文" }, { "key": "en_US", "label": "英文" } ], "help_txt": "默认值为中文" } ], "4": [ { "label": "A75253", "key": "A75253" }, { "label": "A75254", "key": "A75254" }, { "label": "A75255", "key": "A75255" }, { "label": "A75256", "key": "A75256" }, { "label": "A75257", "key": "A75257" }, { "label": "A75258", "key": "A75258" }, { "label": "A75259", "key": "A75259" }, { "label": "A75260", "key": "A75260" }, { "label": "A75261", "key": "A75261" }, { "label": "A75262", "key": "A75262" }, { "label": "A75263", "key": "A75263" }, { "label": "A75264", "key": "A75264" }, { "label": "A75265", "key": "A75265" }, { "label": "A75291", "key": "A75291" }, { "label": "A75292", "key": "A75292" }, { "label": "A75293", "key": "A75293" }, { "label": "A75294", "key": "A75294" }, { "label": "A75295", "key": "A75295" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://thoughts.teambition.com/sharespace/5f48d064ccddd8001666ccb5/docs/622088a509c7700041a57c9b\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "A75253", "key": "A75253" }, { "label": "A75267", "key": "A75267" }, { "label": "A75268", "key": "A75268" }, { "label": "A75269", "key": "A75269" }, { "label": "A75270", "key": "A75270" }, { "label": "A75271", "key": "A75271" }, { "label": "A75272", "key": "A75272" }, { "label": "A75273", "key": "A75273" }, { "label": "A75274", "key": "A75274" }, { "label": "A75275", "key": "A75275" }, { "label": "A75276", "key": "A75276" }, { "label": "A75277", "key": "A75277" }, { "label": "A75278", "key": "A75278" }, { "label": "A75279", "key": "A75279" }, { "label": "A75280", "key": "A75280" }, { "label": "A75281", "key": "A75281" }, { "label": "A75282", "key": "A75282" }, { "label": "A75283", "key": "A75283" }, { "label": "A75284", "key": "A75284" }, { "label": "A75285", "key": "A75285" }, { "label": "A75286", "key": "A75286" }, { "label": "A75287", "key": "A75287" }, { "label": "A75288", "key": "A75288" }, { "label": "A75289", "key": "A75289" }, { "label": "A75290", "key": "A75290" }, { "label": "UserCode", "key": "UserCode" }, { "label": "Submit", "key": "Submit" }, { "label": "Status", "key": "Status" } ] } [] [] [ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-17T10:24:09.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": 131, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 24, "name": "SQL Server", "description": "<p>Microsoft SQL Server 是一个全面的数据库平台,使用集成的商业智能 (BI)工具提供了企业级的数据管理。其数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能,使您可以构建和管理用于业务的高可用和高性能的数据应用程序。</p>", "popular": 170, "published_at": "2021-10-25T03:00:51.000Z", "created_at": "2021-10-25T03:00:49.000Z", "updated_at": "2022-06-13T08:56:00.000Z", "app_id": "62", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库管理平台", "available": true, "appid": null, "website": "https://www.microsoft.com/zh-cn/sql-server", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1851, "name": "SQL Server.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "SQL_Server_cfd0d1ff2d", "ext": ".svg", "mime": "image/svg+xml", "size": 57.08, "url": "/uploads/SQL_Server_cfd0d1ff2d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T03:01:08.000Z", "updated_at": "2022-01-26T03:01:08.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "批量同步数据", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } } ] [ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 302, "key": null, "published_at": "2021-11-29T09:04:33.000Z", "created_at": "2021-11-29T09:04:31.000Z", "updated_at": "2021-11-29T09:04:33.000Z", "action_id": "138", "action_name": "新增数据", "error": null, "description": "向SQL数据库中添加数据信息", "action_type": "action", "app": null, "template": null }, { "id": 1208, "key": null, "published_at": "2022-03-10T11:38:47.000Z", "created_at": "2022-03-10T11:38:47.000Z", "updated_at": "2022-03-10T11:38:47.000Z", "action_id": "1427", "action_name": "通过数组拆分并循环执行", "error": null, "description": "通过数组拆分并循环执行", "action_type": "action", "app": null, "template": null }, { "id": 2001, "key": null, "published_at": "2022-06-02T11:30:22.000Z", "created_at": "2022-06-02T11:30:22.000Z", "updated_at": "2022-06-02T11:30:22.000Z", "action_id": "1953", "action_name": "查询用户详情", "error": null, "description": "使用用户id查询用户的详细信息", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 4006, "key": null, "published_at": "2022-11-10T01:29:28.000Z", "created_at": "2022-11-10T01:29:28.000Z", "updated_at": "2022-11-10T01:29:28.000Z", "action_id": "3045", "action_name": "查询审批实例详情1.0.2", "error": null, "description": "使用钉钉自建应用询审批实例详情(兼容表格抹平)", "action_type": "action", "app": null, "template": null } ] [] [] 100+ 100+ 100+ 100+ 57