BAQ report - REST API

Kinetic ERP
1

Hello,
i called Ice.RPT.baqreportSvc/SubmitToAgent to submit a baq report. the json string is as below.

but I got the following error message. i don’t know what means root elment is missing.

can anyone help me on that.

thanks,

Eddy

"Program Ice.Services.Lib.RunTask when executing task 500023 raised an unexpected exception with the following message: RunTask:
System.Xml.XmlException: Root element is missing. "

{
“ds”: {
“BAQReportParam”: [
{
“BAQID”: “SSRS_SHP_TransportRequest”,
“ReportTitle”: “TransportRequest”,
“Filter1”:
{
“BAQReport”: [
{
“Company”: “xxxx”,
“BAQRptID”: “TransportReq”,
“ExportID”: “SSRS_SHP_TransportRequest”,
“ReportID”: “TransportReq”,
“SSRSReportName”: “TransportReq.rdl”,
“SysRevID”: 99621608,
“SysRowID”: “0f4f2c30-0eb5-4d68-93de-b946a80753d8”
}]
,
“BAQFptFilter”: [
{
“Company”: “xxxx”,
“BAQrptID”: “TransportReq”,
“DataTableID”: “ShipHead”,
“FieldName”: “PackNum”,
“AdapterName”: “CustShipAdapter”,
“Seq”: 1,
“LookupField”: “PackNum”,
“FilterLabel”: “Pack ID”,
“TableLabel”: “Pack ID”,
“FilterField”: “PackNum”,
“DisplayName”: “ShipHead_PackNum”,
“EpiGuid”: “bdc9d47f-89aa-405c-bacf-8bd2a04a3a51”,
“SysRevID”: 99453685,
“SysRowID”: “9f63d129-94f6-491b-be5b-f553f0b7e4b7”,
“FilterValue”: “53”
}]

	}
	,
    "Filter2": "53",
    "UserID": "epicorrpt",
    "BAQRptID": "TransportReq",
    "ReportID": "TransportReq",
    "SysRowID": "00000000-0000-0000-0000-000000000000",
    "AutoAction": "SSRSPREVIEW",
    "AgentSchedNum": 0,
    "AgentID": "SystemTaskAgent",
    "AgentTaskNum": 0,
    "ReportStyleNum": 1,
    "WorkstationID": "MTL-xxxx-L 1",
    "ArchiveCode": 0,
    "SSRSRenderFormat": "PDF",
    "RowMod": "A"
  }
],
"ReportStyle": [
  {
    "Company": "xxxx",
    "ReportID": "TransportReq",
    "StyleNum": 1
  }
]

},
“agentID”: “SystemTaskAgent”,
“agentSchedNum”: 0,
“agentTaskNum”: 0,
“maintProgram”: “Ice.UIRpt.BAQReport;TransportReq”
}

2

Im still waiting for the solution of this case

3

From what I can see, the value for Filter1 isn’t in JSON, it’s written in XML. This corresponds to the error message you’re receiving referencing XML and root elements. Your JSON block for Filter1 needs to be surrounded with specific opening and closing tags, and each element within needs to be made into a tag.

It would be something similar to this, but mine may have extra options like the “BAQRptOptionFld” tags.

<DynamicReportDataSet xmlns="http://www.epicor.com/Ice/300/BO/DynamicReport/DynamicReport">
	<BAQReport>
		<Company></Company>
		<BAQRptID></BAQRptID>
		<Description></Description>
		<ReportTitle></ReportTitle>
		<FormTitle></FormTitle>
		<ExportID></ExportID>
		<SystemFlag></SystemFlag>
		<Completed></Completed>
		<GlobalReport></GlobalReport>
		<IsCrystalReport></IsCrystalReport>
		<ReportID></ReportID>
		<CrystalReportName></CrystalReportName>
		<CGCCode></CGCCode>
		<SSRSReportName></SSRSReportName>
		<SysRevID></SysRevID>
		<SysRowID></SysRowID>
		<TempRowID></TempRowID>
		<BitFlag></BitFlag>
		<RowMod></RowMod>
	</BAQReport>
	<BAQRptOptionFld>
		<Company></Company>
		<BAQRptID></BAQRptID>
		<DataTableID></DataTableID>
		<FieldName></FieldName>
		<CompOp></CompOp>
		<Seq></Seq>
		<DefaultValue></DefaultValue>
		<FieldLabel></FieldLabel>
		<DisplayName></DisplayName>
		<FieldFormat></FieldFormat>
		<EpiGuid></EpiGuid>
		<IsVisible></IsVisible>
		<DataType></DataType>
		<SystemFlag></SystemFlag>
		<DispOrder></DispOrder>
		<SysRevID></SysRevID>
		<SysRowID></SysRowID>
		<FieldValue />
		<TempRowID></TempRowID>
		<BitFlag></BitFlag>
		<RowMod></RowMod>
	</BAQRptOptionFld>
	<BAQRptOptionFld>
		<Company></Company>
		<BAQRptID></BAQRptID>
		<DataTableID></DataTableID>
		<FieldName></FieldName>
		<CompOp></CompOp>
		<Seq></Seq>
		<DefaultValue></DefaultValue>
		<FieldLabel></FieldLabel>
		<DisplayName></DisplayName>
		<FieldFormat></FieldFormat>
		<EpiGuid></EpiGuid>
		<IsVisible></IsVisible>
		<DataType></DataType>
		<SystemFlag></SystemFlag>
		<DispOrder></DispOrder>
		<SysRevID></SysRevID>
		<SysRowID></SysRowID>
		<FieldValue />
		<TempRowID></TempRowID>
		<BitFlag></BitFlag>
		<RowMod></RowMod>
	</BAQRptOptionFld>
	<BAQRptFilter>
		<Company></Company>
		<BAQRptID></BAQRptID>
		<DataTableID></DataTableID>
		<FieldName></FieldName>
		<AdapterName></AdapterName>
		<Seq></Seq>
		<LookupField></LookupField>
		<FilterLabel></FilterLabel>
		<TabLabel></TabLabel>
		<DisplayName></DisplayName>
		<EpiGuid></EpiGuid>
		<IsVisible></IsVisible>
		<FilterField></FilterField>
		<SystemFlag></SystemFlag>
		<DispOrder></DispOrder>
		<DataType></DataType>
		<SysRevID></SysRevID>
		<SysRowID></SysRowID>
		<TempRowID></TempRowID>
		<FilterValue></FilterValue>
		<BitFlag></BitFlag>
		<RowMod></RowMod>
	</BAQRptFilter>
</DynamicReportDataSet>
1 Like