Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

Hi @matthew_hughes 

 

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

*************************************************************************************************************
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/dratulgrover [ 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. 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Shamma Negi
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