案例文章
推荐的的流程模板
请稍后...
Code
1781
有成CRM有新订单后写入到数据库表内
<p>有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)</p>
zh-Hans
2022-10-27T06:40:24.000Z
2022-10-27T06:40:24.000Z
2023-11-26T06:29:21.000Z
1
wz8473ve
有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)
anyone
7Qn34ifTrNpO
official
jm1834
passed
张三丰
wz8473ve
张三丰
[
{
"desc": "每当有合同订单新增时同步数据并触发流程",
"app_id": 332,
"action_type": "1",
"sort": "1",
"action_id": 2359,
"note": null
},
{
"desc": "查询SQL数据库中的数据信息",
"app_id": 62,
"action_type": "2",
"sort": "2",
"action_id": 407,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "3",
"action_id": 138,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "4",
"action_id": 138,
"note": null
}
]
28
false
3
{
"1": [],
"2": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
],
"3": [
{
"label": "id",
"key": "id"
},
{
"label": "customer_id",
"key": "customer_id"
},
{
"label": "custom_name",
"key": "custom_name"
},
{
"label": "product_amount",
"key": "product_amount"
},
{
"label": "warehouse_id",
"key": "warehouse_id"
},
{
"label": "flow_status",
"key": "flow_status"
},
{
"label": "customer_amount_0_value",
"key": "customer_amount_0_value"
},
{
"label": "custom_industry",
"key": "custom_industry"
},
{
"label": "custom_level",
"key": "custom_level"
},
{
"label": "order_amount",
"key": "order_amount"
},
{
"label": "order_amount_value",
"key": "order_amount_value"
},
{
"label": "created",
"key": "created"
},
{
"label": "order_date",
"key": "order_date"
},
{
"label": "project_name",
"key": "project_name"
}
],
"4": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
]
}
false
[]
[]
[
{
"id": 473,
"name": "有成CRM",
"description": "<p>有成CRM是一款供客户关系管理软件,主要功能有客户管理、跟进记录、呼叫中心、业绩分析、进销存等,能够帮助企业快速提升业绩,是销售们的成单利器。</p>",
"popular": 155,
"published_at": "2022-07-14T05:56:26.000Z",
"created_at": "2022-07-14T05:53:42.000Z",
"updated_at": "2023-03-27T10:10:23.000Z",
"app_id": "332",
"category": "CRM",
"locale": "zh-Hans",
"short_description": "CRM系统",
"available": true,
"appid": null,
"website": "http://www.ycbg.com/crm.html",
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5185,
"name": "Youchengcaiwu.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Youchengcaiwu_e82d131381",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 4.47,
"url": "/uploads/Youchengcaiwu_e82d131381.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-14T05:52:16.000Z",
"updated_at": "2022-07-14T05:52:16.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": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
},
{
"id": 11,
"name": "产品研发",
"locale": "zh-Hans",
"published_at": "2022-06-01T03:32:31.000Z",
"created_at": "2022-06-01T03:31:22.000Z",
"updated_at": "2022-06-01T03:32:31.000Z",
"sort": 10
}
]
[
{
"id": 302,
"key": null,
"published_at": "2021-11-29T09:04:33.000Z",
"created_at": "2021-11-29T09:04:31.000Z",
"updated_at": "2023-11-06T07:38:03.000Z",
"action_id": "138",
"action_name": "新增数据",
"error": null,
"description": "向SQL数据库中添加数据信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "138"
},
{
"id": 2622,
"key": null,
"published_at": "2022-07-15T10:42:51.000Z",
"created_at": "2022-07-15T10:42:51.000Z",
"updated_at": "2023-11-06T07:48:08.000Z",
"action_id": "2359",
"action_name": "当有合同订单新增时",
"error": null,
"description": "每当有合同订单新增时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2359"
},
{
"id": 350,
"key": null,
"published_at": "2021-11-29T09:54:21.000Z",
"created_at": "2021-11-29T09:54:19.000Z",
"updated_at": "2023-11-06T07:38:12.000Z",
"action_id": "407",
"action_name": "查询数据",
"error": null,
"description": "在SqlServer查询数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "407"
}
]
[
{
"id": 49,
"title": "数据库同步",
"sort": 4,
"scene": 11,
"published_at": "2022-12-08T09:29:07.000Z",
"created_at": "2022-12-08T09:29:06.000Z",
"updated_at": "2022-12-14T03:27:34.000Z",
"template": 765,
"seo": []
},
{
"id": 43,
"title": "数据统计",
"sort": 2,
"scene": 10,
"published_at": "2022-12-08T09:27:43.000Z",
"created_at": "2022-12-08T09:27:42.000Z",
"updated_at": "2022-12-12T08:02:00.000Z",
"template": null,
"seo": []
}
]
[]
100+
100+
100+
25
34
Msg
1781
有成CRM有新订单后写入到数据库表内
<p>有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)</p>
zh-Hans
2022-10-27T06:40:24.000Z
2022-10-27T06:40:24.000Z
2023-11-26T06:29:21.000Z
1
wz8473ve
有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)
anyone
7Qn34ifTrNpO
official
jm1834
passed
张三丰
wz8473ve
张三丰
[
{
"desc": "每当有合同订单新增时同步数据并触发流程",
"app_id": 332,
"action_type": "1",
"sort": "1",
"action_id": 2359,
"note": null
},
{
"desc": "查询SQL数据库中的数据信息",
"app_id": 62,
"action_type": "2",
"sort": "2",
"action_id": 407,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "3",
"action_id": 138,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "4",
"action_id": 138,
"note": null
}
]
28
false
3
{
"1": [],
"2": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
],
"3": [
{
"label": "id",
"key": "id"
},
{
"label": "customer_id",
"key": "customer_id"
},
{
"label": "custom_name",
"key": "custom_name"
},
{
"label": "product_amount",
"key": "product_amount"
},
{
"label": "warehouse_id",
"key": "warehouse_id"
},
{
"label": "flow_status",
"key": "flow_status"
},
{
"label": "customer_amount_0_value",
"key": "customer_amount_0_value"
},
{
"label": "custom_industry",
"key": "custom_industry"
},
{
"label": "custom_level",
"key": "custom_level"
},
{
"label": "order_amount",
"key": "order_amount"
},
{
"label": "order_amount_value",
"key": "order_amount_value"
},
{
"label": "created",
"key": "created"
},
{
"label": "order_date",
"key": "order_date"
},
{
"label": "project_name",
"key": "project_name"
}
],
"4": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
]
}
false
[]
[]
[
{
"id": 473,
"name": "有成CRM",
"description": "<p>有成CRM是一款供客户关系管理软件,主要功能有客户管理、跟进记录、呼叫中心、业绩分析、进销存等,能够帮助企业快速提升业绩,是销售们的成单利器。</p>",
"popular": 155,
"published_at": "2022-07-14T05:56:26.000Z",
"created_at": "2022-07-14T05:53:42.000Z",
"updated_at": "2023-03-27T10:10:23.000Z",
"app_id": "332",
"category": "CRM",
"locale": "zh-Hans",
"short_description": "CRM系统",
"available": true,
"appid": null,
"website": "http://www.ycbg.com/crm.html",
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5185,
"name": "Youchengcaiwu.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Youchengcaiwu_e82d131381",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 4.47,
"url": "/uploads/Youchengcaiwu_e82d131381.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-14T05:52:16.000Z",
"updated_at": "2022-07-14T05:52:16.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": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
},
{
"id": 11,
"name": "产品研发",
"locale": "zh-Hans",
"published_at": "2022-06-01T03:32:31.000Z",
"created_at": "2022-06-01T03:31:22.000Z",
"updated_at": "2022-06-01T03:32:31.000Z",
"sort": 10
}
]
[
{
"id": 302,
"key": null,
"published_at": "2021-11-29T09:04:33.000Z",
"created_at": "2021-11-29T09:04:31.000Z",
"updated_at": "2023-11-06T07:38:03.000Z",
"action_id": "138",
"action_name": "新增数据",
"error": null,
"description": "向SQL数据库中添加数据信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "138"
},
{
"id": 2622,
"key": null,
"published_at": "2022-07-15T10:42:51.000Z",
"created_at": "2022-07-15T10:42:51.000Z",
"updated_at": "2023-11-06T07:48:08.000Z",
"action_id": "2359",
"action_name": "当有合同订单新增时",
"error": null,
"description": "每当有合同订单新增时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2359"
},
{
"id": 350,
"key": null,
"published_at": "2021-11-29T09:54:21.000Z",
"created_at": "2021-11-29T09:54:19.000Z",
"updated_at": "2023-11-06T07:38:12.000Z",
"action_id": "407",
"action_name": "查询数据",
"error": null,
"description": "在SqlServer查询数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "407"
}
]
[
{
"id": 49,
"title": "数据库同步",
"sort": 4,
"scene": 11,
"published_at": "2022-12-08T09:29:07.000Z",
"created_at": "2022-12-08T09:29:06.000Z",
"updated_at": "2022-12-14T03:27:34.000Z",
"template": 765,
"seo": []
},
{
"id": 43,
"title": "数据统计",
"sort": 2,
"scene": 10,
"published_at": "2022-12-08T09:27:43.000Z",
"created_at": "2022-12-08T09:27:42.000Z",
"updated_at": "2022-12-12T08:02:00.000Z",
"template": null,
"seo": []
}
]
[]
100+
100+
100+
25
34
Data
1781
有成CRM有新订单后写入到数据库表内
<p>有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)</p>
zh-Hans
2022-10-27T06:40:24.000Z
2022-10-27T06:40:24.000Z
2023-11-26T06:29:21.000Z
1
wz8473ve
有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)
anyone
7Qn34ifTrNpO
official
jm1834
passed
张三丰
wz8473ve
张三丰
[
{
"desc": "每当有合同订单新增时同步数据并触发流程",
"app_id": 332,
"action_type": "1",
"sort": "1",
"action_id": 2359,
"note": null
},
{
"desc": "查询SQL数据库中的数据信息",
"app_id": 62,
"action_type": "2",
"sort": "2",
"action_id": 407,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "3",
"action_id": 138,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "4",
"action_id": 138,
"note": null
}
]
28
false
3
{
"1": [],
"2": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
],
"3": [
{
"label": "id",
"key": "id"
},
{
"label": "customer_id",
"key": "customer_id"
},
{
"label": "custom_name",
"key": "custom_name"
},
{
"label": "product_amount",
"key": "product_amount"
},
{
"label": "warehouse_id",
"key": "warehouse_id"
},
{
"label": "flow_status",
"key": "flow_status"
},
{
"label": "customer_amount_0_value",
"key": "customer_amount_0_value"
},
{
"label": "custom_industry",
"key": "custom_industry"
},
{
"label": "custom_level",
"key": "custom_level"
},
{
"label": "order_amount",
"key": "order_amount"
},
{
"label": "order_amount_value",
"key": "order_amount_value"
},
{
"label": "created",
"key": "created"
},
{
"label": "order_date",
"key": "order_date"
},
{
"label": "project_name",
"key": "project_name"
}
],
"4": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
]
}
false
[]
[]
[
{
"id": 473,
"name": "有成CRM",
"description": "<p>有成CRM是一款供客户关系管理软件,主要功能有客户管理、跟进记录、呼叫中心、业绩分析、进销存等,能够帮助企业快速提升业绩,是销售们的成单利器。</p>",
"popular": 155,
"published_at": "2022-07-14T05:56:26.000Z",
"created_at": "2022-07-14T05:53:42.000Z",
"updated_at": "2023-03-27T10:10:23.000Z",
"app_id": "332",
"category": "CRM",
"locale": "zh-Hans",
"short_description": "CRM系统",
"available": true,
"appid": null,
"website": "http://www.ycbg.com/crm.html",
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5185,
"name": "Youchengcaiwu.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Youchengcaiwu_e82d131381",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 4.47,
"url": "/uploads/Youchengcaiwu_e82d131381.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-14T05:52:16.000Z",
"updated_at": "2022-07-14T05:52:16.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": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
},
{
"id": 11,
"name": "产品研发",
"locale": "zh-Hans",
"published_at": "2022-06-01T03:32:31.000Z",
"created_at": "2022-06-01T03:31:22.000Z",
"updated_at": "2022-06-01T03:32:31.000Z",
"sort": 10
}
]
[
{
"id": 302,
"key": null,
"published_at": "2021-11-29T09:04:33.000Z",
"created_at": "2021-11-29T09:04:31.000Z",
"updated_at": "2023-11-06T07:38:03.000Z",
"action_id": "138",
"action_name": "新增数据",
"error": null,
"description": "向SQL数据库中添加数据信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "138"
},
{
"id": 2622,
"key": null,
"published_at": "2022-07-15T10:42:51.000Z",
"created_at": "2022-07-15T10:42:51.000Z",
"updated_at": "2023-11-06T07:48:08.000Z",
"action_id": "2359",
"action_name": "当有合同订单新增时",
"error": null,
"description": "每当有合同订单新增时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2359"
},
{
"id": 350,
"key": null,
"published_at": "2021-11-29T09:54:21.000Z",
"created_at": "2021-11-29T09:54:19.000Z",
"updated_at": "2023-11-06T07:38:12.000Z",
"action_id": "407",
"action_name": "查询数据",
"error": null,
"description": "在SqlServer查询数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "407"
}
]
[
{
"id": 49,
"title": "数据库同步",
"sort": 4,
"scene": 11,
"published_at": "2022-12-08T09:29:07.000Z",
"created_at": "2022-12-08T09:29:06.000Z",
"updated_at": "2022-12-14T03:27:34.000Z",
"template": 765,
"seo": []
},
{
"id": 43,
"title": "数据统计",
"sort": 2,
"scene": 10,
"published_at": "2022-12-08T09:27:43.000Z",
"created_at": "2022-12-08T09:27:42.000Z",
"updated_at": "2022-12-12T08:02:00.000Z",
"template": null,
"seo": []
}
]
[]
100+
100+
100+
25
34
permission
1781
有成CRM有新订单后写入到数据库表内
<p>有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)</p>
zh-Hans
2022-10-27T06:40:24.000Z
2022-10-27T06:40:24.000Z
2023-11-26T06:29:21.000Z
1
wz8473ve
有成CRM有新订单后,传到第三方系统数据库表内生成单据(此流程适用于第三系统没有对外开放接口或独立部署系统,可以直接授权数据库对数据增、查)
anyone
7Qn34ifTrNpO
official
jm1834
passed
张三丰
wz8473ve
张三丰
[
{
"desc": "每当有合同订单新增时同步数据并触发流程",
"app_id": 332,
"action_type": "1",
"sort": "1",
"action_id": 2359,
"note": null
},
{
"desc": "查询SQL数据库中的数据信息",
"app_id": 62,
"action_type": "2",
"sort": "2",
"action_id": 407,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "3",
"action_id": 138,
"note": null
},
{
"desc": "向SQL数据库中添加数据信息",
"app_id": 62,
"action_type": "2",
"sort": "4",
"action_id": 138,
"note": null
}
]
28
false
3
{
"1": [],
"2": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
],
"3": [
{
"label": "id",
"key": "id"
},
{
"label": "customer_id",
"key": "customer_id"
},
{
"label": "custom_name",
"key": "custom_name"
},
{
"label": "product_amount",
"key": "product_amount"
},
{
"label": "warehouse_id",
"key": "warehouse_id"
},
{
"label": "flow_status",
"key": "flow_status"
},
{
"label": "customer_amount_0_value",
"key": "customer_amount_0_value"
},
{
"label": "custom_industry",
"key": "custom_industry"
},
{
"label": "custom_level",
"key": "custom_level"
},
{
"label": "order_amount",
"key": "order_amount"
},
{
"label": "order_amount_value",
"key": "order_amount_value"
},
{
"label": "created",
"key": "created"
},
{
"label": "order_date",
"key": "order_date"
},
{
"label": "project_name",
"key": "project_name"
}
],
"4": [
{
"label": "id",
"key": "id"
},
{
"label": "detailid",
"key": "detailid"
},
{
"label": "productname",
"key": "productname"
},
{
"label": "quantity",
"key": "quantity"
},
{
"label": "price",
"key": "price"
},
{
"label": "amount",
"key": "amount"
}
]
}
false
[]
[]
[
{
"id": 473,
"name": "有成CRM",
"description": "<p>有成CRM是一款供客户关系管理软件,主要功能有客户管理、跟进记录、呼叫中心、业绩分析、进销存等,能够帮助企业快速提升业绩,是销售们的成单利器。</p>",
"popular": 155,
"published_at": "2022-07-14T05:56:26.000Z",
"created_at": "2022-07-14T05:53:42.000Z",
"updated_at": "2023-03-27T10:10:23.000Z",
"app_id": "332",
"category": "CRM",
"locale": "zh-Hans",
"short_description": "CRM系统",
"available": true,
"appid": null,
"website": "http://www.ycbg.com/crm.html",
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5185,
"name": "Youchengcaiwu.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Youchengcaiwu_e82d131381",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 4.47,
"url": "/uploads/Youchengcaiwu_e82d131381.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-14T05:52:16.000Z",
"updated_at": "2022-07-14T05:52:16.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": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
},
{
"id": 11,
"name": "产品研发",
"locale": "zh-Hans",
"published_at": "2022-06-01T03:32:31.000Z",
"created_at": "2022-06-01T03:31:22.000Z",
"updated_at": "2022-06-01T03:32:31.000Z",
"sort": 10
}
]
[
{
"id": 302,
"key": null,
"published_at": "2021-11-29T09:04:33.000Z",
"created_at": "2021-11-29T09:04:31.000Z",
"updated_at": "2023-11-06T07:38:03.000Z",
"action_id": "138",
"action_name": "新增数据",
"error": null,
"description": "向SQL数据库中添加数据信息",
"action_type": "action",
"app": null,
"template": null,
"action_key": "138"
},
{
"id": 2622,
"key": null,
"published_at": "2022-07-15T10:42:51.000Z",
"created_at": "2022-07-15T10:42:51.000Z",
"updated_at": "2023-11-06T07:48:08.000Z",
"action_id": "2359",
"action_name": "当有合同订单新增时",
"error": null,
"description": "每当有合同订单新增时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2359"
},
{
"id": 350,
"key": null,
"published_at": "2021-11-29T09:54:21.000Z",
"created_at": "2021-11-29T09:54:19.000Z",
"updated_at": "2023-11-06T07:38:12.000Z",
"action_id": "407",
"action_name": "查询数据",
"error": null,
"description": "在SqlServer查询数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": "407"
}
]
[
{
"id": 49,
"title": "数据库同步",
"sort": 4,
"scene": 11,
"published_at": "2022-12-08T09:29:07.000Z",
"created_at": "2022-12-08T09:29:06.000Z",
"updated_at": "2022-12-14T03:27:34.000Z",
"template": 765,
"seo": []
},
{
"id": 43,
"title": "数据统计",
"sort": 2,
"scene": 10,
"published_at": "2022-12-08T09:27:43.000Z",
"created_at": "2022-12-08T09:27:42.000Z",
"updated_at": "2022-12-12T08:02:00.000Z",
"template": null,
"seo": []
}
]
[]
100+
100+
100+
25
34