Copy Attachments from ServiceNow to SharePoint or Shared Folder or Any database

[Raghu33]

Hi,

We got a requirement to copy attachments from ServiceNow to any other database (Oracle) or SFTP, One Drive, Shared Folder etc.

When attachments copied, it should create a folder with the record number and copy all the attachments in it. It would be great if we can copy the content of the record as well along with attachment.

Expected tables will be knowledge article, Request Item, Catalog Task, Incident.

Attachments count will be in 10Ks. Looking for a solution if anyone come across this kind of requirement.

I have explored docs and found few options like - Microsoft SharePoint Spoke etc.. 

Appreciate your response on this. Thanks, in advance.

[Danish Bhairag2]

Hi @Raghu33 ,

Did u check the Export set Functionality in ServiceNow? I think that might help you here.

https://www.servicenow.com/community/in-other-news/using-export-sets-for-sftp-file-transfer/ba-p/228...

https://www.servicenow.com/community/developer-articles/scheduled-export-file-records-to-attachment-...

Thanks,

Danish

[Raghu33]

Thank you for your response @Danish. Will it work for copying attachments? If yes, i will give a try. I observed it works for table records. 

[Danish Bhairag2]

Hi @Raghu33 ,

This feature will help u generate the attachment & copy it from mid server to the destination address shared point address.

Thanks,

Danish

[Raghu33]

Hi Danish - I am looking for copying the attachment available in a knowledge article or RITM record and save it in a database or SharePoint by creating a folder with the actual record name. Attachment format should be similar to the original attachment.