Unable to import attachments through XML

[Learner10]

Hello Community,

Can anyone let us know if there is any possibility to import the attachments through XML from one personal developer instance to another personal developer instance. So we have 10 attachments related to the incident table in instance A, and we need to import those attachments into instance B through XML. Because we have tried to import the attachments through xml, we are able to import them successfully , but when we are trying to download the attachment from the record, we are getting a "no attachment found" error.

It would be a great help if anyone could achieve this kind of logic.

Thanks,

Learner

[Gunjan Kiratkar]

Hi @Learner10 

There is currently no Out-Of-Box feature on the ServiceNow Platform that directly downloads all attachments from the instance.

Attachments are stored in two separate tables: sys_attachment and sys_attachment_doc. The sys_attachment table contains an entry for each attachment that is tied to a particular record and the sys_attachment_doc table is the actual content of the attachments broken up into smaller chunks. 

Here are some custom solutions that can help you get started:

• KB0790002: Bulk export of all attachments in Servicenow instance
• KB0957578: How to export all attachments for a table for use in a third-party system
• Community: Download attachments at once from sys_attachment table
• Community: Attachments mass download
• Community: Download all Attachments from Attachment table
• Community: How to retrieve an attachment from service now via SOAP Web Service
• External: Understanding Attachments in ServiceNow

Keep in mind that these are solutions that are outside of the official ServiceNow platform and support for these solutions from ServiceNow will be limited.

For more info refer :https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0993378 

[Saurav11]

Hello,

Are you also importing the incident records to which the xml was attached first and then importing the attachment or are you directly importing the attachment?

[Learner10]

We have loaded the records first after that we have imported the attachments through xml