Export servicenow data with attachments.

Vedasri1
Tera Contributor

Hi,

I am trying to exporting a table with attachment, I created "database view" with sys_attachment, sys_attachment_doc and incident table. But after exporting the table I am getting name of a attached file instead of the attached file. Can anyone explain how to export the a data (records) from servicenow with attachment.

Thanks & Regards,

Vedasri.

1 ACCEPTED SOLUTION

Hi,

 

Apart from the integration will not be achievable unless it is a service now instance. Through integration as well you need to check if attachments are getting inserted or not.

 

Regards,

Ram M

View solution in original post

23 REPLIES 23

Hi,

 

Then importing xml will work fine including the attachments. Please try for a couple of records (between sub prod instances) that contains attachments and check if it worked as per your requirement.

Make sure once the data was uploaded then Number maintenance to be updated to the latest number else the duplicate numbers will be created.

 

Regards,

Ram M

Hi,

Sorry for late reply. I want to export servicenow data into a file/xml ets., with attachments not to other servicenow instance. As you said I exported some records which have attachments, but I have not get attachment instead I get metadata of that attached record information including base64 encoded chunck data of that attachment. Please let me know if you have any idea about exporting with attachments.

 

Regards,

Vedasri.

Hi,

 

May i know the table which you are trying to export as i have done it for Knowledge and it worked fine. Please let me know the table on which you are performing the action.

 

Regards,

Ram M

Hi,

I am performing with incident table, Actually i have to export all the data from servicenow instance, 1st i tried with incident table.

 

Regards,

Vedasri.

Hi,

 

I have tried uploading the data of incident from my personal instances and it worked as expected uploading with attachments. Please check with sys id instead of number in the target instance.

 

Regards,

Ram M