Automatically export records from a table into a scheduled report

matthew_hughes
Kilo Sage

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.

matthew_hughes_1-1702470699625.png

 

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:

 

matthew_hughes_2-1702470803614.png

 

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

 

9 REPLIES 9

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @matthew_hughes 

 

I guess , need to code in manner to expert in XML , OOTB it is not available. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

So it's not possible to do that within ServiceNow?

Possible is not write word . It can be done for sure but required a lot of code and customization. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Shamma Negi
Kilo Sage
Kilo Sage

Can you try using the below URL:

 

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

 

It generates the XML data of the table.

 

 

Regards,Shamma Negi