How to Import Attachments along with respective Stories?

[Aswartha1]

Hi All,

I have a requirement to Import Stories and respective Attachments to Custom Table of another Instance.

Currently we are upgrading our Instance to Paris Version, for that we want to move rm_story Data into Custom Table of another instance. I am getting all the Data except attachments of respective Stories and please help me with below queries as well

1) is there any field for attachments in rm_story table like to store attachment name or anything else?

2)if we simply import attachments from sys_attachment table then in Target instance how can i map these attachments with respective stories?

anyone please help me with this.

Thanks,

Aswartha Reddy 

[Shivanand F Mad]

Hi Aswartha,

Please try with XML import instead of excel sheet.

[Harsh Vardhan]

If its one time import then exporting xml and importing that xml back on target instance would be easy approach. 

if you want to import it using attachment api then you have to first export all the story with sys_id column and on target instance you will store it either on OOTB column which is not in use or custom column. Then you have to use here attachment API to push the attachment on target instance . Now here sys_id which you stored in target instance story record, that will come into the picture to set the attachment on those record. 

https://developer.servicenow.com/dev.do#!/reference/api/orlando/rest/c_AttachmentAPI