---添加附件绑定接口API
DELETE FROM T_OPEN_APISERVICE WHERE FID = 1039063668618229760;
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',1039063668618229760,'0',{ts'2018-08-8  18:08:08'},'1',NULL,NULL,' ','0',1039063668618229760,NULL,NULL,'C','bindingAtt',NULL,NULL,1,'[{"FPK":"","Type":0,"Description":"附件和单据绑定插件","RowKey":0,"ClassName":"kd.bos.service.webapi.attachment.BatSyncAttachmentWebApiPlugin","Enabled":true,"BizAppId":""}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/bindingAtt','1',1); 


---api请求头
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1039101467316757504;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1039063668618229760,'Content-Type',1039101467316757504,1,'application/json','application/json'); 

---api名称多语言表
DELETE FROM t_open_apiservice_L WHERE FPKID = '18M0K5H/1JIQ';
INSERT INTO t_open_apiservice_L (FPKID,FID,FLOCALEID,FDISCRIPTION,FNAME) VALUES ('18M0K5H/1JIQ', '1039063668618229760', 'zh_CN', '附件和单据的绑定接口', '附件和单据的绑定');
DELETE FROM t_open_apiservice_L WHERE FPKID = '18M0K5H/1JIR';
INSERT INTO t_open_apiservice_L (FPKID,FID,FLOCALEID,FDISCRIPTION,FNAME) VALUES ('18M0K5H/1JIR', '1039063668618229760', 'zh_TW', '附件和單據的綁定接口', '附件和單據的綁定');

---api请求体表

DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039063760725108736;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','String',0,'目标单据标识','testFormNumber',1039063760725108736,1,'formNumber'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039064159251134464;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','String',0,'目标单据PkId','836117104519284736',1039064159251134464,2,'billPkId'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039064404819208192;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','Object',0,'附件数据集合','附件数据集合',1039064404819208192,3,'data'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039064613401982976;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','Array',1039064404819208192,'key是附件面板或者附件字段标识;value是附件列表','key是附件面板或者附件字段标识;value是附件列表',1039064613401982976,4,'attachmentpanel'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039066295569508352;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'0','String',1039064613401982976,'附件所属分录PkId;若附件属于单据头则不填','836117104519284737',1039066295569508352,5,'entryPkId'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039066882629462016;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','Long',1039064613401982976,'附件大小(字节数)','95270',1039066882629462016,7,'size'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039066946668095488;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'1','String',1039064613401982976,'附件在服务器的相对路径','/dev/2020/86080/att/test.xlsx',1039066946668095488,9,'path'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1039066976279918592;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1039063668618229760,'0','String',1039064613401982976,'用户ID,不填则取接口调用者ID','36550',1039066976279918592,10,'createUserId'); 




---api请求响应表
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1039069191736457216;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1039063668618229760,'success','1',0,'Boolean',1039069191736457216,1,'true','true/false'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1039069196643756032;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1039063668618229760,'data','1',0,'String',1039069196643756032,2,'请求成功','请求成功返回数据'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1039069205074343936;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1039063668618229760,'message','1',0,'String',1039069205074343936,3,'success','请求成功返回描述'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1039069224401659904;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1039063668618229760,'error_desc','1',0,'String',1039069224401659904,4,'未经授权的访问。 ','请求失败返回描述'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1039069230802204672;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1039063668618229760,'error_code','1',0,'String',1039069230802204672,5,'1','请求失败编码'); 



