打开需要对接的申请工作流。获取里面的表单字段信息。
注意:域名/api/workflow/reqform/loadForm,这个是表单字段信息
找到返回数据中tableInfo,fieldinfomap的信息
main:主表字段信息
detail_1:明细表信息
fieldid:前端提交的时候带的ID
fieldlabel:前端显示信息
fieldname:后端配置的字段名(方案里面的配置信息)
{
"workflowBaseInfo":{
"workflowId":"工作表单ID"
},
"requestName":"XXXX流程--2023-09-07",
"requestLevel":"1",
"creatorId":"创建人",
"workflowMainTableInfo":{
"requestRecords":[
{
"workflowRequestTableFields":[
{
"fieldName":"name",
"fieldValue":"14720",
"view":true,
"edit":true
},
{
"fieldName":"yzgsmc",
"fieldValue":"0",
"view":true,
"edit":true
},
{
"fieldName":"yzbm",
"fieldValue":"841",
"view":true,
"edit":true
},
{
"fieldName":"yzri",
"fieldValue":"2023-09-08",
"view":true,
"edit":true
},
{
"fieldName":"yzmc",
"fieldValue":"测试表单测试表单测试表单",
"view":true,
"edit":true
},
{
"fieldName":"yzsy",
"fieldValue":"测试用例1111",
"view":true,
"edit":true
},
{
"fieldName":"yzsl",
"fieldValue":"1",
"view":true,
"edit":true
},
{
"fieldName":"manager",
"fieldValue":"12586",
"view":true,
"edit":true
},
{
"fieldName":"remark",
"fieldValue":"12586",
"view":true,
"edit":true
}
]
}
]
}
}
formid: -5
f_weaver_belongto_userid: 14720
isWorkflowDoc: false
f_weaver_belongto_usertype: 0
nodetype: 0
method:
needoutprint:
src: save
isMultiDoc:
topage:
workflowtype: 15
iscreate: 1
comemessage:
remindTypes:
14720_38_addrequest_submit_token: 1694142149924
rand:
requestid: -1
htmlfieldids:
needwfback:
lastloginuserid: 14720
nodeid: 161
workflowid: 38
isbill: 1
annexdocids:
signdocids:
annexdocinfos:
handWrittenSign:
remark:
field-annexupload:
signworkflowids:
remarkLocation:
isOdocRequest: 0
remarkquote: %7B%22remark%22%3A%22%22%2C%22remarkquote%22%3A%22%22%7D
actiontype: requestOperation
closePage: false
isFirstSubmit:
existChangeRange: field5777%2Cfield5778%2Cfield10770%2Cfield5780%2Cfield10771%2Cfield8579%2Cfield5791_0%2Cfield5790_0%2Cfield5789_0%2Cfield5792_0%2Cfield5793_0%2Cfield5794_0%2Cfield5795_0%2Cfield5796_0%2Cfield5797_0%2Cfield5798_0%2Cfield5799_0%2Cfield5800_0%2Cfield5791_1%2Cfield5790_1%2Cfield5789_1%2Cfield5792_1%2Cfield5793_1%2Cfield5794_1%2Cfield5795_1%2Cfield5796_1%2Cfield5797_1%2Cfield5798_1%2Cfield5799_1%2Cfield5800_1
field9419: 12586
field5779: 2023-09-08
requestname: %E7%89%B9%E6%AE%8A%E5%90%88%E5%90%8C%E8%AF%84%E5%AE%A1%E6%B5%81%E7%A8%8B(%E5%9B%BD%E9%99%85)-%E5%91%A8%E9%B8%BF%E5%AD%9D-2023-09-08
requestlevel: 0
field10896:
field8142: 14720
field5782:
field10770: 0
field-10: 4
field5780: 0
field5781:
field5777: %E6%B5%8B%E8%AF%95%E6%B5%8B%E8%AF%95
field5778: %E6%B5%8B%E8%AF%95%E6%B5%8B%E8%AF%95
field10771: %E6%94%AF%E4%BB%98%E5%AE%9D%E7%8E%B0%E9%87%91
field8579: 222
field5788:
field6592:
nodesnum0: 2
indexnum0: 2
submitdtlid0: 0%2C1%2C
deldtlid0:
field5789_0: 1
field5790_0: 11
field5791_0: 1111
field5792_0: 111
field5793_0: 11
field5794_0: 11
field5795_0: 11
field5796_0: 11
field5797_0: 11
field5798_0: 11
field5799_0: 11
field5800_0: 11
field5801_0: 2023-09-08
field5789_1: 11
field5790_1: 111
field5791_1: 1111
field5792_1: 11
field5793_1: 11
field5794_1: 11
field5795_1: 11
field5796_1: 11
field5797_1: 11
field5798_1: 11
field5799_1: 11
field5800_1: 11
field5801_1: 2023-09-08
signatureAttributesStr: YmVhZ2VudGVyPTB8aXNhZ2VudD0wfA%3D%3D
signatureSecretKey: 5bd851e415ed5b6556e78da745861ace
selectNextFlow: 0
wfTestStr:
DoCreateWorkflowRequestAdapter:创建流程
WeaverE9V2QueryAdapter:查询流程信息
该步骤可以得到用户ID,和流程workflowid
workflowid=377
http://OA域名/.....?_rdm=1694432088860#/main/workflow/req?iscreate=1&workflowid=377
该步骤可以得到和流程requestid
requestid=330599
http://OA域名/.....?_rdm=XXX#/main/workflow/req?requestid=330599
api:getWorkflowRequest
配置步骤
第一步:认识OA系统
第二步:新建流程
第三步:查看表单信息
第四步:通过接口查询已经提交流程信息
第五步:获取配置的medata字段信息
第六步:配置回调地址方案信息
第七步:回调方案是sqlserver到zoho
select * from workflow_requestlog where requestid=288783
流程审批节点意见
select * from workflow_requestlog where requestid=330878
查询表单下拉
select * from workflow_selectitem where fieldid=10481
2022-10-04 12:41:32 | |
2022-07-09 03:44:35 | |
2023-09-06 23:04:01 | |
2021-06-10 17:23:47 | |
2023-07-04 02:41:56 | |
2021-08-01 00:02:29 | |
2022-12-18 12:51:38 | |
2021-04-28 10:07:45 | |
2022-03-24 19:46:39 | |
2024-01-04 09:23:08 | |
2021-05-30 10:48:07 | |
2023-08-07 09:21:14 | |
2024-11-30 18:03:01 | |
2024-11-20 09:35:34 | |
2024-11-11 01:50:37 | |
2024-11-13 12:04:09 | |
2024-10-24 19:26:57 | |
2024-10-28 06:15:28 | |
2024-12-07 11:26:27 | |
2025-01-21 11:26:57 | |
2023-04-08 05:51:24 | |
2023-04-05 03:21:56 | |
2023-04-05 03:18:23 | |
2023-04-05 03:03:22 | |
2023-04-05 02:14:02 |
何海波 18175716035
数据集成顾问 轻易云的技术专家,拥有丰富的数据集成规划经验。他能够为客户提供专业、全面的数据集成规划方案,熟练掌握多种集成技术和工具,帮助企业在数据集成领域得到长远发展。
胡秀丛 15813570600
数据集成顾问 项目总监 她以卓越的数据集成专长,精通ERP、MES系统,以及数据中台的构建与优化。通过创新的一站式解决方案,她助力企业实现数据的无缝对接,提升业务流程效率,确保信息流通无障碍,为企业的数字化转型提供强有力的支持。
黄宏棵 13286997615
数据集成顾问 资深系统集成顾问,专长于ERP、电商OMS、钉钉及CRM系统。他能提供高效的集成方案,优化企业运营流程,提升业务效率和决策智能化。
卢剑航 13760755942
数据集成专家 拥有十多年丰富的经验,擅长ERP、MES、数据中台、营销云中台等集成。他能够根据客户需求,为其提供一站式集成解决方案,帮助企业快速实现各类系统数据集成服务。