Scheduled Reports in xml output

[robhawlor]

HI All

New to the forum. I am trying to wok out if it is at all possible to have XML as an output format for Scheduled reports. This would seem like a basic feature that most toolsets can output to. Any assistance would be greatly appreciated.

[Alikutty A]

Hi,

Is it a list report? Can you generate your report using filters?

You can schedule a URL to be send which retrieves the XML. For eg if you need to report on all active incidents then the following URL can be mailed to the users

https://instance_name.service-now.com/incident_list.do?XML&sysparm_query=active=true

You can also check if Export Sets satisfy your requirement (it supports XML) but data is exported to a mid server

Create an export set

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[robhawlor]

Hi Alikutty

It is a list report, currently the only options to pick from on the schedule are PDF and a few Excel formats. I need the XML file rather than an xml link to maintain our current level of reporting on SLA's and various other metrics. I'm not sure if we are talking about the same type of reporting as our midserver is only for event logging and AD updates.

[Alikutty A]

Hi Robert,

I doubt if you can get XML attachment in a scheduled report. The only difference is you need to click on the link vs attachment. Once you click on the link, the attachment will be automatically downloaded.

The export sets can send you xml attachment but it will be send to the mid server and cannot be mailed to users or groups.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[robhawlor]

Hi Alikutty

That would be fine if we click the link to download. How do we specify what the fields are etc that currently make up the xls report? Apologies, I am very new to servicenow reporting.