How to export XML without attachments

[Yu_G]

Hi everyone,

Is there a way to extract xml data from ServiceNow without attachments?

Am now working on extracting records from  customized tables of scoped application. However, attachments are not expected to be exported within the xml files.

I found a similar question in community, but the answer (https://<myinstance>.service-now.com/<tablename>_list.do?XML&useUnloadFormat=true) seems not working.

Any good idea will be greatly appreciated.

Thank you so much.

[Mark Manders · Accepted solution]

What's the reason for not wanting the attachments? If you export them, that is for a reason. And attachments are on the record for a reason. If not needed, you could just delete the attachments on the table and do an export of the 'clean' records. Or import them again and remove the attachment on the new instance. 
Or open the exported XML and remove every mention of <attachment></attachment>, including the string in between.

This article explains the difference between the XML parameter in the URL and the 'export to xml' in the instance. Maybe it will give you a solution: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0635940

I tried it with a few records on my instance (through the URL) and I had no attachments, but as the article mentions, sometimes it does.