案例文章
推荐的的流程模板
请稍后...
Code
1581
邮件接收到表格内容，将表格内数据同步到维格表
<p>邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。</p>
zh-Hans
2022-09-20T03:45:33.000Z
2022-09-20T03:45:33.000Z
2023-07-17T06:13:30.000Z
ay4830az
邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。
anyone
68ZG0OTgxCLy
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[
{
"desc": "向之前生成的邮件地址发送邮件，接收到邮件时同步数据并触发流程",
"app_id": 125,
"action_type": "1",
"sort": "1",
"action_id": 477,
"note": null
},
{
"desc": "删除单词或字符间多余的空格",
"app_id": 108,
"action_type": "2",
"sort": "2",
"action_id": 1681,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "3",
"action_id": 334,
"note": null
},
{
"desc": "手动输入或继承变量生成数组",
"app_id": 1000454,
"action_type": "2",
"sort": "4",
"action_id": 1001703,
"note": null
},
{
"desc": "通过文本字符对字段值进行拆分，拆分后的字段值将进行逐个执行",
"app_id": 131,
"action_type": "2",
"sort": "5",
"action_id": 501,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "6",
"action_id": 334,
"note": null
},
{
"desc": "向维格表中添加数据",
"app_id": 310,
"action_type": "2",
"sort": "7",
"action_id": 364,
"note": null
}
]
7
false
{
"1": [],
"2": [
{
"key": "text",
"label": "文本内容",
"required": true,
"multiples": false,
"type": "text"
},
{
"key": "is_keep_one",
"label": "是否保留1个空格",
"required": false,
"type": "string",
"dropdown": true,
"defaulttext": "1",
"choices": [
{
"key": "0",
"label": "否"
},
{
"key": "1",
"label": "是"
}
]
}
],
"3": [
{
"label": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"4": [],
"5": [
{
"dropdown": false,
"help_txt": "循环执行可以将一组包含多个数据字段分隔开，并逐个推送到后续的流程步骤中，更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">（帮助中心）</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": ",",
"dropdown": false,
"help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤",
"label": "分隔符",
"type": "string",
"dynamic": false,
"key": "separator",
"required": false
},
{
"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": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"7": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
]
}
[]
[]
[
{
"id": 86,
"name": "邮件触发",
"description": "<p>邮件触发是集简云的内置应用，通过创建集简云邮件账户，并向此邮件账户发送邮件，即可触发流程，并可以将邮件中的正文内容，邮件发送人，接收人，发送时间等信息作为变量在后续步骤中使用。</p>",
"popular": 103,
"published_at": "2021-10-25T05:36:52.000Z",
"created_at": "2021-10-25T05:36:50.000Z",
"updated_at": "2023-02-20T11:20:24.000Z",
"app_id": "125",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "发送邮件触发流程",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": 97,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3469,
"name": "email-trigger.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "email_trigger_ec28d8c23c",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.32,
"url": "/uploads/email_trigger_ec28d8c23c.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:43:54.000Z",
"updated_at": "2022-04-21T08:43:55.000Z"
}
},
{
"id": 71,
"name": "文本处理",
"description": "<p>文本处理是集简云内置应用，用于对文字内容的格式进行调整，以便在后续的流程中更好的使用。</p>",
"popular": -13,
"published_at": "2021-10-25T03:47:29.000Z",
"created_at": "2021-10-25T03:47:27.000Z",
"updated_at": "2022-04-21T08:49:18.000Z",
"app_id": "108",
"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": 3476,
"name": "wenbenzhuanhuan.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "wenbenzhuanhuan_0a62076317",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.96,
"url": "/uploads/wenbenzhuanhuan_0a62076317.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:49:15.000Z",
"updated_at": "2022-04-21T08:49:15.000Z"
}
},
{
"id": 631,
"name": "数组处理",
"description": "<p>数组处理是集简云的一款内置应用，用于将文本变量内容生成一组数组或者将一组数组转换成文本内容，以便用于后续的流程步骤中。</p>",
"popular": -1,
"published_at": "2022-08-25T05:54:52.000Z",
"created_at": "2022-08-25T05:39:49.000Z",
"updated_at": "2023-10-26T08:20:48.000Z",
"app_id": "1000454",
"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": 5862,
"name": "shuzuchuli.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "shuzuchuli_114ea035f2",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.71,
"url": "/uploads/shuzuchuli_114ea035f2.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-08-25T05:54:16.000Z",
"updated_at": "2022-08-25T05:54:16.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": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.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": 3150,
"key": null,
"published_at": "2022-08-26T10:11:02.000Z",
"created_at": "2022-08-26T10:11:02.000Z",
"updated_at": "2022-08-26T10:11:02.000Z",
"action_id": "1001703",
"action_name": "将文本转换为数组",
"error": null,
"description": "手动输入或继承变量生成数组",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
},
{
"id": 1596,
"key": null,
"published_at": "2022-04-28T11:08:45.000Z",
"created_at": "2022-04-28T11:08:45.000Z",
"updated_at": "2023-11-06T07:42:03.000Z",
"action_id": "1681",
"action_name": "删除空格",
"error": null,
"description": "删除单词或字符间多余的空格",
"action_type": "action",
"app": null,
"template": null,
"action_key": "1681"
},
{
"id": 2716,
"key": null,
"published_at": "2022-07-25T08:33:20.000Z",
"created_at": "2022-07-25T08:33:20.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2431",
"action_name": "添加记录",
"error": null,
"description": "向维格表中添加数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "364"
},
{
"id": 226,
"key": null,
"published_at": "2021-11-26T05:39:45.000Z",
"created_at": "2021-11-26T05:39:44.000Z",
"updated_at": "2023-11-06T07:42:12.000Z",
"action_id": "334",
"action_name": "文本分隔",
"error": null,
"description": "对一整段文本进行分隔，分隔后的字段可以作为字段参数用于后续的步骤中，比如换行分隔，英文逗号分隔等",
"action_type": "action",
"app": null,
"template": null,
"action_key": "334"
},
{
"id": 402,
"key": null,
"published_at": "2021-11-30T05:39:51.000Z",
"created_at": "2021-11-30T05:39:49.000Z",
"updated_at": "2023-11-06T07:42:46.000Z",
"action_id": "477",
"action_name": "当接收到邮件时",
"error": null,
"description": "当接收到邮件时流程触发",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "477"
},
{
"id": 422,
"key": null,
"published_at": "2021-11-30T06:25:32.000Z",
"created_at": "2021-11-30T06:25:29.000Z",
"updated_at": "2023-11-06T07:42:50.000Z",
"action_id": "501",
"action_name": "通过文本分隔符拆分并循环执行",
"error": null,
"description": "当外部系统有查询任务时，通过循环执行汇总查询信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "501"
}
]
[
{
"id": 42,
"title": "内容同步",
"sort": 1,
"scene": 10,
"published_at": "2022-12-08T09:27:27.000Z",
"created_at": "2022-12-08T09:27:26.000Z",
"updated_at": "2022-12-12T08:29:32.000Z",
"template": 1692,
"seo": []
}
]
[]
100+
100+
100+
69
71
Msg
1581
邮件接收到表格内容，将表格内数据同步到维格表
<p>邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。</p>
zh-Hans
2022-09-20T03:45:33.000Z
2022-09-20T03:45:33.000Z
2023-07-17T06:13:30.000Z
ay4830az
邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。
anyone
68ZG0OTgxCLy
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[
{
"desc": "向之前生成的邮件地址发送邮件，接收到邮件时同步数据并触发流程",
"app_id": 125,
"action_type": "1",
"sort": "1",
"action_id": 477,
"note": null
},
{
"desc": "删除单词或字符间多余的空格",
"app_id": 108,
"action_type": "2",
"sort": "2",
"action_id": 1681,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "3",
"action_id": 334,
"note": null
},
{
"desc": "手动输入或继承变量生成数组",
"app_id": 1000454,
"action_type": "2",
"sort": "4",
"action_id": 1001703,
"note": null
},
{
"desc": "通过文本字符对字段值进行拆分，拆分后的字段值将进行逐个执行",
"app_id": 131,
"action_type": "2",
"sort": "5",
"action_id": 501,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "6",
"action_id": 334,
"note": null
},
{
"desc": "向维格表中添加数据",
"app_id": 310,
"action_type": "2",
"sort": "7",
"action_id": 364,
"note": null
}
]
7
false
{
"1": [],
"2": [
{
"key": "text",
"label": "文本内容",
"required": true,
"multiples": false,
"type": "text"
},
{
"key": "is_keep_one",
"label": "是否保留1个空格",
"required": false,
"type": "string",
"dropdown": true,
"defaulttext": "1",
"choices": [
{
"key": "0",
"label": "否"
},
{
"key": "1",
"label": "是"
}
]
}
],
"3": [
{
"label": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"4": [],
"5": [
{
"dropdown": false,
"help_txt": "循环执行可以将一组包含多个数据字段分隔开，并逐个推送到后续的流程步骤中，更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">（帮助中心）</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": ",",
"dropdown": false,
"help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤",
"label": "分隔符",
"type": "string",
"dynamic": false,
"key": "separator",
"required": false
},
{
"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": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"7": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
]
}
[]
[]
[
{
"id": 86,
"name": "邮件触发",
"description": "<p>邮件触发是集简云的内置应用，通过创建集简云邮件账户，并向此邮件账户发送邮件，即可触发流程，并可以将邮件中的正文内容，邮件发送人，接收人，发送时间等信息作为变量在后续步骤中使用。</p>",
"popular": 103,
"published_at": "2021-10-25T05:36:52.000Z",
"created_at": "2021-10-25T05:36:50.000Z",
"updated_at": "2023-02-20T11:20:24.000Z",
"app_id": "125",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "发送邮件触发流程",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": 97,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3469,
"name": "email-trigger.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "email_trigger_ec28d8c23c",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.32,
"url": "/uploads/email_trigger_ec28d8c23c.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:43:54.000Z",
"updated_at": "2022-04-21T08:43:55.000Z"
}
},
{
"id": 71,
"name": "文本处理",
"description": "<p>文本处理是集简云内置应用，用于对文字内容的格式进行调整，以便在后续的流程中更好的使用。</p>",
"popular": -13,
"published_at": "2021-10-25T03:47:29.000Z",
"created_at": "2021-10-25T03:47:27.000Z",
"updated_at": "2022-04-21T08:49:18.000Z",
"app_id": "108",
"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": 3476,
"name": "wenbenzhuanhuan.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "wenbenzhuanhuan_0a62076317",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.96,
"url": "/uploads/wenbenzhuanhuan_0a62076317.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:49:15.000Z",
"updated_at": "2022-04-21T08:49:15.000Z"
}
},
{
"id": 631,
"name": "数组处理",
"description": "<p>数组处理是集简云的一款内置应用，用于将文本变量内容生成一组数组或者将一组数组转换成文本内容，以便用于后续的流程步骤中。</p>",
"popular": -1,
"published_at": "2022-08-25T05:54:52.000Z",
"created_at": "2022-08-25T05:39:49.000Z",
"updated_at": "2023-10-26T08:20:48.000Z",
"app_id": "1000454",
"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": 5862,
"name": "shuzuchuli.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "shuzuchuli_114ea035f2",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.71,
"url": "/uploads/shuzuchuli_114ea035f2.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-08-25T05:54:16.000Z",
"updated_at": "2022-08-25T05:54:16.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": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.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": 3150,
"key": null,
"published_at": "2022-08-26T10:11:02.000Z",
"created_at": "2022-08-26T10:11:02.000Z",
"updated_at": "2022-08-26T10:11:02.000Z",
"action_id": "1001703",
"action_name": "将文本转换为数组",
"error": null,
"description": "手动输入或继承变量生成数组",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
},
{
"id": 1596,
"key": null,
"published_at": "2022-04-28T11:08:45.000Z",
"created_at": "2022-04-28T11:08:45.000Z",
"updated_at": "2023-11-06T07:42:03.000Z",
"action_id": "1681",
"action_name": "删除空格",
"error": null,
"description": "删除单词或字符间多余的空格",
"action_type": "action",
"app": null,
"template": null,
"action_key": "1681"
},
{
"id": 2716,
"key": null,
"published_at": "2022-07-25T08:33:20.000Z",
"created_at": "2022-07-25T08:33:20.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2431",
"action_name": "添加记录",
"error": null,
"description": "向维格表中添加数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "364"
},
{
"id": 226,
"key": null,
"published_at": "2021-11-26T05:39:45.000Z",
"created_at": "2021-11-26T05:39:44.000Z",
"updated_at": "2023-11-06T07:42:12.000Z",
"action_id": "334",
"action_name": "文本分隔",
"error": null,
"description": "对一整段文本进行分隔，分隔后的字段可以作为字段参数用于后续的步骤中，比如换行分隔，英文逗号分隔等",
"action_type": "action",
"app": null,
"template": null,
"action_key": "334"
},
{
"id": 402,
"key": null,
"published_at": "2021-11-30T05:39:51.000Z",
"created_at": "2021-11-30T05:39:49.000Z",
"updated_at": "2023-11-06T07:42:46.000Z",
"action_id": "477",
"action_name": "当接收到邮件时",
"error": null,
"description": "当接收到邮件时流程触发",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "477"
},
{
"id": 422,
"key": null,
"published_at": "2021-11-30T06:25:32.000Z",
"created_at": "2021-11-30T06:25:29.000Z",
"updated_at": "2023-11-06T07:42:50.000Z",
"action_id": "501",
"action_name": "通过文本分隔符拆分并循环执行",
"error": null,
"description": "当外部系统有查询任务时，通过循环执行汇总查询信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "501"
}
]
[
{
"id": 42,
"title": "内容同步",
"sort": 1,
"scene": 10,
"published_at": "2022-12-08T09:27:27.000Z",
"created_at": "2022-12-08T09:27:26.000Z",
"updated_at": "2022-12-12T08:29:32.000Z",
"template": 1692,
"seo": []
}
]
[]
100+
100+
100+
69
71
Data
1581
邮件接收到表格内容，将表格内数据同步到维格表
<p>邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。</p>
zh-Hans
2022-09-20T03:45:33.000Z
2022-09-20T03:45:33.000Z
2023-07-17T06:13:30.000Z
ay4830az
邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。
anyone
68ZG0OTgxCLy
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[
{
"desc": "向之前生成的邮件地址发送邮件，接收到邮件时同步数据并触发流程",
"app_id": 125,
"action_type": "1",
"sort": "1",
"action_id": 477,
"note": null
},
{
"desc": "删除单词或字符间多余的空格",
"app_id": 108,
"action_type": "2",
"sort": "2",
"action_id": 1681,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "3",
"action_id": 334,
"note": null
},
{
"desc": "手动输入或继承变量生成数组",
"app_id": 1000454,
"action_type": "2",
"sort": "4",
"action_id": 1001703,
"note": null
},
{
"desc": "通过文本字符对字段值进行拆分，拆分后的字段值将进行逐个执行",
"app_id": 131,
"action_type": "2",
"sort": "5",
"action_id": 501,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "6",
"action_id": 334,
"note": null
},
{
"desc": "向维格表中添加数据",
"app_id": 310,
"action_type": "2",
"sort": "7",
"action_id": 364,
"note": null
}
]
7
false
{
"1": [],
"2": [
{
"key": "text",
"label": "文本内容",
"required": true,
"multiples": false,
"type": "text"
},
{
"key": "is_keep_one",
"label": "是否保留1个空格",
"required": false,
"type": "string",
"dropdown": true,
"defaulttext": "1",
"choices": [
{
"key": "0",
"label": "否"
},
{
"key": "1",
"label": "是"
}
]
}
],
"3": [
{
"label": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"4": [],
"5": [
{
"dropdown": false,
"help_txt": "循环执行可以将一组包含多个数据字段分隔开，并逐个推送到后续的流程步骤中，更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">（帮助中心）</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": ",",
"dropdown": false,
"help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤",
"label": "分隔符",
"type": "string",
"dynamic": false,
"key": "separator",
"required": false
},
{
"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": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"7": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
]
}
[]
[]
[
{
"id": 86,
"name": "邮件触发",
"description": "<p>邮件触发是集简云的内置应用，通过创建集简云邮件账户，并向此邮件账户发送邮件，即可触发流程，并可以将邮件中的正文内容，邮件发送人，接收人，发送时间等信息作为变量在后续步骤中使用。</p>",
"popular": 103,
"published_at": "2021-10-25T05:36:52.000Z",
"created_at": "2021-10-25T05:36:50.000Z",
"updated_at": "2023-02-20T11:20:24.000Z",
"app_id": "125",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "发送邮件触发流程",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": 97,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3469,
"name": "email-trigger.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "email_trigger_ec28d8c23c",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.32,
"url": "/uploads/email_trigger_ec28d8c23c.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:43:54.000Z",
"updated_at": "2022-04-21T08:43:55.000Z"
}
},
{
"id": 71,
"name": "文本处理",
"description": "<p>文本处理是集简云内置应用，用于对文字内容的格式进行调整，以便在后续的流程中更好的使用。</p>",
"popular": -13,
"published_at": "2021-10-25T03:47:29.000Z",
"created_at": "2021-10-25T03:47:27.000Z",
"updated_at": "2022-04-21T08:49:18.000Z",
"app_id": "108",
"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": 3476,
"name": "wenbenzhuanhuan.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "wenbenzhuanhuan_0a62076317",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.96,
"url": "/uploads/wenbenzhuanhuan_0a62076317.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:49:15.000Z",
"updated_at": "2022-04-21T08:49:15.000Z"
}
},
{
"id": 631,
"name": "数组处理",
"description": "<p>数组处理是集简云的一款内置应用，用于将文本变量内容生成一组数组或者将一组数组转换成文本内容，以便用于后续的流程步骤中。</p>",
"popular": -1,
"published_at": "2022-08-25T05:54:52.000Z",
"created_at": "2022-08-25T05:39:49.000Z",
"updated_at": "2023-10-26T08:20:48.000Z",
"app_id": "1000454",
"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": 5862,
"name": "shuzuchuli.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "shuzuchuli_114ea035f2",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.71,
"url": "/uploads/shuzuchuli_114ea035f2.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-08-25T05:54:16.000Z",
"updated_at": "2022-08-25T05:54:16.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": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.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": 3150,
"key": null,
"published_at": "2022-08-26T10:11:02.000Z",
"created_at": "2022-08-26T10:11:02.000Z",
"updated_at": "2022-08-26T10:11:02.000Z",
"action_id": "1001703",
"action_name": "将文本转换为数组",
"error": null,
"description": "手动输入或继承变量生成数组",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
},
{
"id": 1596,
"key": null,
"published_at": "2022-04-28T11:08:45.000Z",
"created_at": "2022-04-28T11:08:45.000Z",
"updated_at": "2023-11-06T07:42:03.000Z",
"action_id": "1681",
"action_name": "删除空格",
"error": null,
"description": "删除单词或字符间多余的空格",
"action_type": "action",
"app": null,
"template": null,
"action_key": "1681"
},
{
"id": 2716,
"key": null,
"published_at": "2022-07-25T08:33:20.000Z",
"created_at": "2022-07-25T08:33:20.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2431",
"action_name": "添加记录",
"error": null,
"description": "向维格表中添加数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "364"
},
{
"id": 226,
"key": null,
"published_at": "2021-11-26T05:39:45.000Z",
"created_at": "2021-11-26T05:39:44.000Z",
"updated_at": "2023-11-06T07:42:12.000Z",
"action_id": "334",
"action_name": "文本分隔",
"error": null,
"description": "对一整段文本进行分隔，分隔后的字段可以作为字段参数用于后续的步骤中，比如换行分隔，英文逗号分隔等",
"action_type": "action",
"app": null,
"template": null,
"action_key": "334"
},
{
"id": 402,
"key": null,
"published_at": "2021-11-30T05:39:51.000Z",
"created_at": "2021-11-30T05:39:49.000Z",
"updated_at": "2023-11-06T07:42:46.000Z",
"action_id": "477",
"action_name": "当接收到邮件时",
"error": null,
"description": "当接收到邮件时流程触发",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "477"
},
{
"id": 422,
"key": null,
"published_at": "2021-11-30T06:25:32.000Z",
"created_at": "2021-11-30T06:25:29.000Z",
"updated_at": "2023-11-06T07:42:50.000Z",
"action_id": "501",
"action_name": "通过文本分隔符拆分并循环执行",
"error": null,
"description": "当外部系统有查询任务时，通过循环执行汇总查询信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "501"
}
]
[
{
"id": 42,
"title": "内容同步",
"sort": 1,
"scene": 10,
"published_at": "2022-12-08T09:27:27.000Z",
"created_at": "2022-12-08T09:27:26.000Z",
"updated_at": "2022-12-12T08:29:32.000Z",
"template": 1692,
"seo": []
}
]
[]
100+
100+
100+
69
71
permission
1581
邮件接收到表格内容，将表格内数据同步到维格表
<p>邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。</p>
zh-Hans
2022-09-20T03:45:33.000Z
2022-09-20T03:45:33.000Z
2023-07-17T06:13:30.000Z
ay4830az
邮件触发当接收到还有表格内容的邮件时，通过使用文本处理删除空格，文本处理文本分隔，数组处理将文本转换为数组，循环执行通过文本分隔符拆分并循环执行，文本处理文本分隔，最终将数据逐一添加到维格表。
anyone
68ZG0OTgxCLy
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[
{
"desc": "向之前生成的邮件地址发送邮件，接收到邮件时同步数据并触发流程",
"app_id": 125,
"action_type": "1",
"sort": "1",
"action_id": 477,
"note": null
},
{
"desc": "删除单词或字符间多余的空格",
"app_id": 108,
"action_type": "2",
"sort": "2",
"action_id": 1681,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "3",
"action_id": 334,
"note": null
},
{
"desc": "手动输入或继承变量生成数组",
"app_id": 1000454,
"action_type": "2",
"sort": "4",
"action_id": 1001703,
"note": null
},
{
"desc": "通过文本字符对字段值进行拆分，拆分后的字段值将进行逐个执行",
"app_id": 131,
"action_type": "2",
"sort": "5",
"action_id": 501,
"note": null
},
{
"desc": "将文本内容根据分隔方式（英文逗号，空格，换行，英文分号等）进行文本分隔",
"app_id": 108,
"action_type": "2",
"sort": "6",
"action_id": 334,
"note": null
},
{
"desc": "向维格表中添加数据",
"app_id": 310,
"action_type": "2",
"sort": "7",
"action_id": 364,
"note": null
}
]
7
false
{
"1": [],
"2": [
{
"key": "text",
"label": "文本内容",
"required": true,
"multiples": false,
"type": "text"
},
{
"key": "is_keep_one",
"label": "是否保留1个空格",
"required": false,
"type": "string",
"dropdown": true,
"defaulttext": "1",
"choices": [
{
"key": "0",
"label": "否"
},
{
"key": "1",
"label": "是"
}
]
}
],
"3": [
{
"label": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"4": [],
"5": [
{
"dropdown": false,
"help_txt": "循环执行可以将一组包含多个数据字段分隔开，并逐个推送到后续的流程步骤中，更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">（帮助中心）</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": ",",
"dropdown": false,
"help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤",
"label": "分隔符",
"type": "string",
"dynamic": false,
"key": "separator",
"required": false
},
{
"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": "需要分隔的文本内容",
"key": "text",
"help_txt": "请求选择要文本内容，分隔后将自动变成字段key与字段值的格式，以便后续步骤中使用",
"required": true,
"multiples": false,
"type": "text"
},
{
"label": "选择分隔方式",
"key": "separated",
"help_txt": "设置以什么方式进行分隔，例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式，以便后续步骤中使用。",
"type": "string",
"required": true,
"default": ",",
"dropdown": true,
"choices": [
{
"key": ",",
"label": "英文逗号分隔"
},
{
"key": " ",
"label": "空格分隔"
},
{
"key": ";",
"label": "英文分号分隔"
},
{
"key": "\n",
"label": "换行分隔"
}
]
}
],
"7": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
]
}
[]
[]
[
{
"id": 86,
"name": "邮件触发",
"description": "<p>邮件触发是集简云的内置应用，通过创建集简云邮件账户，并向此邮件账户发送邮件，即可触发流程，并可以将邮件中的正文内容，邮件发送人，接收人，发送时间等信息作为变量在后续步骤中使用。</p>",
"popular": 103,
"published_at": "2021-10-25T05:36:52.000Z",
"created_at": "2021-10-25T05:36:50.000Z",
"updated_at": "2023-02-20T11:20:24.000Z",
"app_id": "125",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "发送邮件触发流程",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": 97,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3469,
"name": "email-trigger.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "email_trigger_ec28d8c23c",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.32,
"url": "/uploads/email_trigger_ec28d8c23c.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:43:54.000Z",
"updated_at": "2022-04-21T08:43:55.000Z"
}
},
{
"id": 71,
"name": "文本处理",
"description": "<p>文本处理是集简云内置应用，用于对文字内容的格式进行调整，以便在后续的流程中更好的使用。</p>",
"popular": -13,
"published_at": "2021-10-25T03:47:29.000Z",
"created_at": "2021-10-25T03:47:27.000Z",
"updated_at": "2022-04-21T08:49:18.000Z",
"app_id": "108",
"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": 3476,
"name": "wenbenzhuanhuan.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "wenbenzhuanhuan_0a62076317",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.96,
"url": "/uploads/wenbenzhuanhuan_0a62076317.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:49:15.000Z",
"updated_at": "2022-04-21T08:49:15.000Z"
}
},
{
"id": 631,
"name": "数组处理",
"description": "<p>数组处理是集简云的一款内置应用，用于将文本变量内容生成一组数组或者将一组数组转换成文本内容，以便用于后续的流程步骤中。</p>",
"popular": -1,
"published_at": "2022-08-25T05:54:52.000Z",
"created_at": "2022-08-25T05:39:49.000Z",
"updated_at": "2023-10-26T08:20:48.000Z",
"app_id": "1000454",
"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": 5862,
"name": "shuzuchuli.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "shuzuchuli_114ea035f2",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 2.71,
"url": "/uploads/shuzuchuli_114ea035f2.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-08-25T05:54:16.000Z",
"updated_at": "2022-08-25T05:54:16.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": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.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": 3150,
"key": null,
"published_at": "2022-08-26T10:11:02.000Z",
"created_at": "2022-08-26T10:11:02.000Z",
"updated_at": "2022-08-26T10:11:02.000Z",
"action_id": "1001703",
"action_name": "将文本转换为数组",
"error": null,
"description": "手动输入或继承变量生成数组",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
},
{
"id": 1596,
"key": null,
"published_at": "2022-04-28T11:08:45.000Z",
"created_at": "2022-04-28T11:08:45.000Z",
"updated_at": "2023-11-06T07:42:03.000Z",
"action_id": "1681",
"action_name": "删除空格",
"error": null,
"description": "删除单词或字符间多余的空格",
"action_type": "action",
"app": null,
"template": null,
"action_key": "1681"
},
{
"id": 2716,
"key": null,
"published_at": "2022-07-25T08:33:20.000Z",
"created_at": "2022-07-25T08:33:20.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2431",
"action_name": "添加记录",
"error": null,
"description": "向维格表中添加数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "364"
},
{
"id": 226,
"key": null,
"published_at": "2021-11-26T05:39:45.000Z",
"created_at": "2021-11-26T05:39:44.000Z",
"updated_at": "2023-11-06T07:42:12.000Z",
"action_id": "334",
"action_name": "文本分隔",
"error": null,
"description": "对一整段文本进行分隔，分隔后的字段可以作为字段参数用于后续的步骤中，比如换行分隔，英文逗号分隔等",
"action_type": "action",
"app": null,
"template": null,
"action_key": "334"
},
{
"id": 402,
"key": null,
"published_at": "2021-11-30T05:39:51.000Z",
"created_at": "2021-11-30T05:39:49.000Z",
"updated_at": "2023-11-06T07:42:46.000Z",
"action_id": "477",
"action_name": "当接收到邮件时",
"error": null,
"description": "当接收到邮件时流程触发",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "477"
},
{
"id": 422,
"key": null,
"published_at": "2021-11-30T06:25:32.000Z",
"created_at": "2021-11-30T06:25:29.000Z",
"updated_at": "2023-11-06T07:42:50.000Z",
"action_id": "501",
"action_name": "通过文本分隔符拆分并循环执行",
"error": null,
"description": "当外部系统有查询任务时，通过循环执行汇总查询信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "501"
}
]
[
{
"id": 42,
"title": "内容同步",
"sort": 1,
"scene": 10,
"published_at": "2022-12-08T09:27:27.000Z",
"created_at": "2022-12-08T09:27:26.000Z",
"updated_at": "2022-12-12T08:29:32.000Z",
"template": 1692,
"seo": []
}
]
[]
100+
100+
100+
69
71
触发动作
执行动作
