泛微E9对接步骤

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