DELETE FROM t_open_apiservice WHERE FID = 1191293086882351104;
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',' ',' ',1191293086882351104,'0',{ts'2018-08-08  18:08:08'},'1',NULL,NULL,' ','0',1191293086882351104,NULL,NULL,'C','getrptdata',NULL,NULL,1,'[{"FPK":"","Type":0,"Description":"","RowKey":0,"ClassName":"kd.fi.bcm.formplugin.intergration.BIReportFetchApiPlugin","Enabled":true,"BizAppId":""}]',{ts'2018-08-08  18:08:08'},'11H66HLOX4IC','/app/cm/getrptdata','0',1);

DELETE FROM t_open_apiservice_l WHERE FID = 1191293086882351104;
INSERT INTO t_open_apiservice_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1191293086882351104,'1QAC+B2/N9B4','zh_CN','报表查询接口'); 

DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1194289658888991744;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1191293086882351104,'Content-Type',1194289658888991744,1,'application/json',' '); 

DELETE FROM t_open_apiqueryparamentry WHERE FID = 1191293086882351104;
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String',' ','1','model',1191293086899128320,1,'体系编码');
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String',' ','1','entity',1191293086899128321,2,'组织编码');
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','MRpt','1','scene',1191293086899128322,3,'情景编码'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','FY2020','1','year',1191293086899128323,4,'财年编码'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','M_M01','1','period',1191293086899128324,5,'期间编码'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','CNY','1','currency',1191293086899128325,6,'币别编码'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','IRpt,CS','1','processList',1191293086899128326,7,'过程编码，多个编码以英文逗号分割'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','BS,CF','1','tmplList',1191293086899128327,8,'模板编码，多个编码以英文逗号分割'); 
INSERT INTO t_open_apiqueryparamentry(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1191293086882351104,'String','{"Account":"R1023,R1046","AuditTrail":"ATTotal"}','0','scope',1191293086899128328,9,'选填，其他维度范围'); 

DELETE FROM t_open_apirespentry WHERE FID = 1191293086882351104;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1191293086882351104,'param','1','Object',0,1191292618957407232,1,' ','返回入参'); 
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1191293086882351104,'data','1','Object',0,1191293193711273984,2,' ','data中不会包含值已经明确的维度'); 
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1191293086882351104,'dimension','1','Array',1191293193711273984,1191293321603990528,3,' ','数组第一个值为tmplNum,对应模板编码，后续为data中对应维度编码顺序'); 
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1191293086882351104,'data','1','Array',1191293193711273984,1191293577431369728,4,' ','每行数据最后一个为数据值，前面的值与dimension顺序对应'); 
















