Automatically export records from a table into a scheduled report

[matthew_hughes]

We've got a department table that has over 1000 entries. I'm wanting to export these automatically as an XML file. At the moment I can only do it via the below method.

I'm wanting to include the list of departments as an XML file in a scheduled report. However, when I click on the list of available formats, the following appear:

I was just wondering if anyone knows how I can get an XML file automatically created and included in a scheduled report.

[AndersBGS]

Hi @matthew_hughes ,

According to ServiceNow OOTB standards, this is not possible: https://developer.servicenow.com/dev.do#!/learn/courses/utah/app_store_learnv2_reportanalytics_utah_... Scheduled reports are automatically run at a pre-defined frequency and emailed as files to a list of recipients. Scheduled report formats are CSV, XLS, PNG, and PDF.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

HI @matthew_hughes 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Shamma Negi]

There is no OOB option available for this.

Scheduled reports are automatically run at a pre-defined frequency and emailed as files to a list of recipients. Scheduled report formats are CSV, XLS, PNG, and PDF.

Custom option : 

https://<instance_name>.service-now.com/incident_list.do?XML&sysparm_query=category=inquiry

It generates the XML data of the table.

[Ankur Bawiskar]

@matthew_hughes 

I would love to understand the business requirement here.

Why would you share xml of record to users via email using scheduled report?

[Michael George]

I, too, would like to hear the business case for this, but in the meantime, I'll toss out another idea. Use the rest API against the table with appropriate filters and request XML as the output type. If you need it on a schedule, create a scheduled job to run a script to do the interfacing with the API.