金蝶云星空ERP附件上传接口开发思路

article/2025/8/26 18:35:42

1️⃣

需求描述：需要通过调用金蝶API接口实现指定单据的附件上传。本文以收料通知单为例，以Java代码示例进行讲解。
tips：阅读本文开始前，希望你是一名开发者同时阅读过：
https://vip.kingdee.com/article/87232573931076096
https://vip.kingdee.com/article/183394

2️⃣

首先我们需要了解金蝶附件上传接口是哪一个，如果不清楚，我们可以通过抓包的方式进行查看，但是如果看过上面的文章，我们可以找到上传接口: 你的服务器地址/FileUpLoadServices/FileService.svc/upload2attachment/?fileName=上传文件名称&fileId=&token=登录返回的token&last=true&dbid=数据中心id
请求体具体就是字节流的方式放入请求体，不同编程语言具体写法不一致，本文以Java为例最后会附上相关代码。

3️⃣

这样我们可以通过查询

SELECT * from T_BAS_FileServerFileInfo where ffilename='你上传的文件名'

可以查看到你上传的文件（使用的是文件服务器存储到服务器地址）
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传

上传成功了，肯定有一个疑问，这仅仅上传了文件，但是并没有在具体单据显示啊，其实看了第一个tips的能发现，附件是通过T_BAS_Attachment表与实际业务关联起来的。所以下面需要通过保存api将附件信息关联起来。

4️⃣

下面就和保存一样，请求url其实就是保存的。通过分析分析官方的url我们可以得出请求json格式：

{"parameters": ["BOS_Attachmen",{"NeedReturnFields": [],"IsAutoSubmitAndAudi": "false","Creator": "","NeedUpDateFields": [],"IsVerifyBaseDataField": "false","IsEntryBatchFill": "false","NumberSearch": "true","InterationFlags": "","ValidateFlag": "true","SubSystemId": "","IsDeleteEntry": "false","Model": {"FInterID": "单据的fid","FEntryKey": " 单据体标识（如果是单据头，则传一个空格）","FEntryInterID": -1 单据体分录主键，单据头传-1,"FBillNo": "单据体编号","FBillType": "你要上传附件表单","FAttachmentName": "上传文件的名字","FAttachmentSize": "上传文件的大小","FExtName": "拓展名","FAttachmentDes": "描述","FAttachmen": "","FFILEID": "通过步骤三返回的fileid","FCREATEMEN": " { "FUSERID", 10086}","FCreateTime": "上传时间"}}]
}

然后进行保存就可以了通过查询

SELECT * from T_BAS_Attachment where fbillno in('你上传附件的单号')

在这里插入图片描述

然后通过前端附件就可以进行查看到上传的文件了
在这里插入图片描述

5️⃣

最后附上Java相关代码

public ResultVO upload(String token,String cookie, MultipartFile content, String formId,String fbillno) throws IOException {System.out.println("cookie"+cookie);ResultVO rv = new ResultVO();List<ArrayList>fidList=new ArrayList<>();String fid=null;String fileName=null;String fileId=null;fileName=content.getOriginalFilename();String jsonFormat = getExecuteBillQueryJsonFormatNew(formId,"FID", "FBillNo in('"+fbillno+"')");//json格式化JSONObject obj = JSON.parseObject(jsonFormat);rv = executeBillQuery(cookie, obj);if (rv != null) {String[] l = JSON.parseObject(rv.getData().toString(), String[].class);String[] n=JSON.parseObject(l[0], String[].class);fid=n[0];}byte[] bytes=content.getBytes();InputStream in = new ByteArrayInputStream(bytes);Date date = new Date();SimpleDateFormat dateFormat= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");String url= "http://你的服务器地址/k3cloud/FileUpLoadServices/FileService.svc/upload2attachment/?filename="+fileName+"&fileid=&last=true&dbid="+kdCloundConfig.getAcctID()+"&token="+token+"";Map<String, Object> paramMap = new HashMap<>();paramMap.put("data",in);String result2 = HttpRequest.post(url).form(paramMap)//表单内容.timeout(20000)//超时，毫秒.execute().body();System.out.println("result2"+result2);//  System.out.println("FileId"+ JsonPath.read(result2, "$.Upload2AttachmentResult.FileId"));fileId=JsonPath.read(result2, "$.Upload2AttachmentResult.FileId");String saveurl = kdCloundConfig.getUrl() + kdCloundConfig.getSave();//业务数据内码FInterID//-1 FEntryInterID代码单据头附件，单据体附件需指定具体业务数据单据体内码，//FBillNo 业务数据编码//PUR_ReceiveBill 附件关联的业务对象IdSystem.out.println("fid"+fid+"fbillno"+fbillno+"formId"+formId+"fileName"+fileName+content.getSize()+content.getOriginalFilename().substring(content.getOriginalFilename().lastIndexOf("."))+dateFormat.format(date));JSONObject jsonObject = new JSONObject();jsonObject.put("FUSERID",643384);String data="{\n" +"\t\"parameters\": [\n" +"\t\t\"BOS_Attachment\",\n" +"\t\t{\n" +"\t\t\t\"NeedReturnFields\": [],\n" +"\t\t\t\"IsAutoSubmitAndAudit\": \"false\",\n" +"\t\t\t\"Creator\": \"\",\n" +"\t\t\t\"NeedUpDateFields\": [],\n" +"\t\t\t\"IsVerifyBaseDataField\": \"false\",\n" +"\t\t\t\"IsEntryBatchFill\": \"false\",\n" +"\t\t\t\"NumberSearch\": \"true\",\n" +"\t\t\t\"InterationFlags\": \"\",\n" +"\t\t\t\"ValidateFlag\": \"true\",\n" +"\t\t\t\"SubSystemId\": \"\",\n" +"\t\t\t\"IsDeleteEntry\": \"false\",\n" +"\t\t\t\"Model\": {\n" +"\t\t\t\t\"FInterID\": "+fid+",\n" +"\t\t\t\t\"FEntryKey\": \" \",\n" +"\t\t\t\t\"FEntryInterID\": -1,\n" +"\t\t\t\t\"FBillNo\": \""+fbillno+"\",\n" +"\t\t\t\t\"FBillType\": \""+formId+"\",\n" +"\t\t\t\t\"FAttachmentName\": \""+fileName+"\",\n" +"\t\t\t\t\"FAttachmentSize\": "+ (double)(Math.round(content.getSize()/1024))+",\n" +"\t\t\t\t\"FExtName\": \""+content.getOriginalFilename().substring(content.getOriginalFilename().lastIndexOf("."))+"\",\n" +"\t\t\t\t\"FAttachmentDes\": \"地磅上传\",\n" +"\t\t\t\t\"FAttachment\": \"\",\n" +"\t\t\t\t\"FFILEID\": \""+fileId+"\",\n" +"\t\t\t\t\"FCREATEMEN\": "+jsonObject.toJSONString()+",\n" +"\t\t\t\t\"FCreateTime\": \""+dateFormat.format(date)+"\"\n" +"\t\t\t}\n" +"\t\t}\n" +"\t]\n" +"}";Map<String, Object> header = new HashMap<>();header.put("Cookie", cookie);String result = HttpUtil.httpPost(saveurl, header, data);rv.setCode(ResultEnumErrorCode.SUCCESS.getCode());rv.setMessage(ResultEnumErrorCode.SUCCESS.getMsg());rv.setData(result);logger.info("upload:formId:{}执行结果：{}", formId, result);if (ObjectUtil.isEmpty(rv)) {rv.setCode(ResultEnumErrorCode.SYSTEM_ERROR_B0001.getCode());rv.setMessage(ResultEnumErrorCode.SYSTEM_ERROR_B0001.getMsg());logger.error("upload：formId:{}系统执行出错！", formId);}return rv;}