1：获取表单字段信息
打开需要对接的申请工作流。获取里面的表单字段信息。
注意：域名/api/workflow/reqform/loadForm，这个是表单字段信息
2：表单字段说明
找到返回数据中tableInfo，fieldinfomap的信息
main:主表字段信息
detail_1：明细表信息
fieldid：前端提交的时候带的ID
fieldlabel：前端显示信息
fieldname：后端配置的字段名（方案里面的配置信息）
3：webservice请求参数示例说明
{
"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
}
]
}
]
}
}
4：获取提交的数据
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:
5:适配器
DoCreateWorkflowRequestAdapter：创建流程
WeaverE9V2QueryAdapter：查询流程信息
6:首先使用流程申请创建一条流程。表单明细行都填一条数据
该步骤可以得到用户ID，和流程workflowid
workflowid=377
http://OA域名/.....?_rdm=1694432088860#/main/workflow/req?iscreate=1&workflowid=377
7：查看刚保存数据，得到创建流程的字段
该步骤可以得到和流程requestid
requestid=330599
http://OA域名/.....?_rdm=XXX#/main/workflow/req?requestid=330599
8: 创建查询方案，得到流程写入字段示例值
api:getWorkflowRequest
9：请求数据得到medata数据
配置步骤
第一步：认识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
