欢迎使用普元产品知识库,本知识库包含普元应用开发平台EOSPlatform,流程平台BPS,企业服务总线ESB,微服务平台Microservice,运维管理平台Devops,数据集成平台DI
欢迎使用普元文档库
问题描述:使用Json输出组件,导出的不是标准的json格式,数组数据中没有[ ]和逗号分割。
导出的格式见后面附件中内容《test.js》
导出的为:
{
"data" : {
"OPERATOR_ID" : 1,
"TENANT_ID" : "default",
"USER_ID" : "sysadmin",
"PASSWORD" : "k2xvHUmCHWw=",
"INVALDATE" : null,
"USER_NAME" : "sysadmin",
"AUTHMODE" : "local",
"STATUS" : "1",
"UNLOCKTIME" : "2013/03/16 11:58:31.000.000000000",
"MENUTYPE" : "default",
"LASTLOGIN" : "2016/11/30 22:16:47.000.000000000",
"ERRCOUNT" : 0,
"STARTDATE" : null,
"ENDDATE" : null,
"VALIDTIME" : null,
"MACCODE" : null,
"IPADDRESS" : null,
"EMAIL" : null,
"CREATEUSER" : "sysadmin",
"CREATETIME" : "2013/03/16 11:58:31.000.000000000"
}
}{
"data" : {
"OPERATOR_ID" : 10,
"TENANT_ID" : "default",
"USER_ID" : "systemadmin",
"PASSWORD" : "k2xvHUmCHWw=",
"INVALDATE" : null,
"USER_NAME" : "系统管理员",
"AUTHMODE" : "local",
"STATUS" : "1",
"UNLOCKTIME" : "2014/08/24 11:58:31.000.000000000",
"MENUTYPE" : "default",
"LASTLOGIN" : "2014/08/24 11:58:31.000.000000000",
"ERRCOUNT" : null,
"STARTDATE" : null,
"ENDDATE" : null,
"VALIDTIME" : null,
"MACCODE" : null,
"IPADDRESS" : null,
"EMAIL" : null,
"CREATEUSER" : null,
"CREATETIME" : "2014/08/24 11:58:31.000.000000000"
}
}
正确的应该为:
[{
"data": {
"OPERATOR_ID": 1,
"TENANT_ID": "default",
"USER_ID": "sysadmin",
"PASSWORD": "k2xvHUmCHWw=",
"INVALDATE": null,
"USER_NAME": "sysadmin",
"AUTHMODE": "local",
"STATUS": "1",
"UNLOCKTIME": "2013/03/16 11:58:31.000.000000000",
"MENUTYPE": "default",
"LASTLOGIN": "2016/11/30 22:16:47.000.000000000",
"ERRCOUNT": 0,
"STARTDATE": null,
"ENDDATE": null,
"VALIDTIME": null,
"MACCODE": null,
"IPADDRESS": null,
"EMAIL": null,
"CREATEUSER": "sysadmin",
"CREATETIME": "2013/03/16 11:58:31.000.000000000"
}
}, {
"data": {
"OPERATOR_ID": 10,
"TENANT_ID": "default",
"USER_ID": "systemadmin",
"PASSWORD": "k2xvHUmCHWw=",
"INVALDATE": null,
"USER_NAME": "aaa",
"AUTHMODE": "local",
"STATUS": "1",
"UNLOCKTIME": "2014/08/24 11:58:31.000.000000000",
"MENUTYPE": "default",
"LASTLOGIN": "2014/08/24 11:58:31.000.000000000",
"ERRCOUNT": null,
"STARTDATE": null,
"ENDDATE": null,
"VALIDTIME": null,
"MACCODE": null,
"IPADDRESS": null,
"EMAIL": null,
"CREATEUSER": null,
"CREATETIME": "2014/08/24 11:58:31.000.000000000"
}
}]
解决方案:需要在json输出组件中将一个数据的数目行选项置空,如图:
则导出的json文件格式如图: