Exporting XML without attachments?

greg54
Tera Expert

‎10-20-2015 06:48 AM

Hi,

I am curious if you can export XML from a table without it including attachments? I am finding when I export even a small data set in our environment, I am getting all of the sys_attachment and sys_attachment_doc entries as well which is causing the XML files to be massive. Is there any way to get only the table you are exporting?

I am assuming it would be with a sysparm_XXXX in the URL, but I am not able to find a defined list of these.

Any help is greatly appreciated!

0 Helpfuls
  • 2,766 Views
3 REPLIES 3

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

‎10-20-2015 07:11 AM

Hi Greg,



What about using something like:



https://<yourinstance>.service-now.com/incident_list.do?XML&useUnloadFormat=true



This gives you all records from incident table in XML format without the attachments.



See on wiki:



XML Web Service - ServiceNow Wiki



Regards,


Sergiu


greg54
Tera Expert
In response to sergiu_panaite

‎10-20-2015 08:01 AM

Thank you very much!!!


0 Helpfuls

sergiu_panaite
ServiceNow Employee
ServiceNow Employee
In response to greg54

‎10-20-2015 10:55 PM

Hi Greg,



If you found my post useful can you mark it as such or answered if the case?



Regards,


Sergiu


0 Helpfuls