1.接口参数配置
2.SAP推送日志表SAPR
常用查询
2.1.查询待推送列表
SELECT * FROM SAPR WHERE Status <> '2' AND SysNo = 'WECOM' AND IFNULL(RunNum,0) < 3 ORDER BY CreateDate DESC
2.2.重置推送
UPDATE SAPR set STATUS = 0,RUNNUM = 0 WHERE ID = 'XXX'
3.回调接口参数
回调审批单列表WECOM
常用查询
3.1.查询待企业微信审批列表
SELECT * FROM WECOM WHERE SPSTATUS = 1;
3.2.查询待SAP接口执行列表
SELECT * FROM WECOM WHERE STATUS = 1;
3.3.查询SAP接口执行失败列表
SELECT * FROM WECOM WHERE STATUS = -2;
3.4.重置SAP接口执行列表
UPDATE WECOM WHERE STATUS = 1,RUNNUM = 0 WHERE ID = 'xx';
3.5.查询待接口主动获取审批状态列表
SELECT * FROM WECOM WHERE STATUS = 3 AND RUNNUM < 4;
3.6.重置审批单号自动获取最新审批状态
UPDATE WECOM SET STATUS = 3,RUNNUM = 0, outdata=null WHERE ID = 'xx'
- 企业微信审批单据的节点明细表
通过查询获取节点明细
综上,通过连续4期将SAP和企业微信的集成开发方案包完全讲解结束,有任何疑问或者需求随时私信博主哈。