sending files from sys_attachment from servicenow to sftp server without using sftp spoke

GirijaS48087926
Tera Contributor

3 weeks ago

Is it possible to send the files from sys_attachment table to sftp server without using sftp spoke?

We dont have spoke enabled as of now. And also dont have any file transfer application like MFT, etc.

Looking for the alternative approach to send the large files from sys_attachment table to sftp server.

 

Would be appreciated if can get any valuable input or feasible approach if anyone already achieved it.

 

Thanks in Advance!

0 Helpfuls
  • 419 Views
2 REPLIES 2

pururavasin
Tera Contributor

3 weeks ago

Hello @GirijaS48087926 ,

 

Please use scheduled export, which will run via MID server & ECC queue.

 

Please mark this answer as helpful/correct.

 

Best regards,

Puru.

0 Helpfuls

Ehab Pilloor
Giga Sage

3 weeks ago

Hi @GirijaS48087926,

 

There are several ways to send files from ServiceNow to an SFTP server:

  • IntegrationHub SFTP Spoke (preferred, if available—requires licensing)

  • MID Server SFTP Script/Command (uses MID server for SFTP execution)

  • Legacy Orchestration SFTP Activities (older, but still in some enterprises)

Refer the below overview for each type.

1. Using Integration Hub Spoke

  • Install SFTP spoke.
  • Crate a flow with appropriate trigger condition
  • For action retrieve sys_id for attachment then use 'Copy Attachments to SFTP Server' action by providing the the SFTP connection alias, the target directory/file name on the SFTP server, and the attachment.

 

2. Using Mid Server Custom Script

  • Set up MID server in your network environment.
  • Export the file to the MID Server's local file system using Export Sets.
  • Use a Script step (within Flow Designer or Orchestration) or PowerShell/Unix script on the MID Server to execute the SFTP PUT command and transfer the file

 

3. Orchestration SFTP Activities

  • Use the SFTP File Transfer activity pack to configure and automate the transfer via a ServiceNow Workflow.
  • Set up SSH/SFTP credentials.
  • Use the "SFTP Put File" activity in the workflow, referencing your attachment.

 

For more detail information, please refer the below references.

Outbound SFTP Integration ,  Pass File from Servicenow to SFTP , Put .csv file from MID server to SFTP , SFTP File Transfer Workflow Steps 

 

Reference post: https://www.servicenow.com/community/itsm-forum/send-report-s-an-attachment-to-sftp-server/m-p/33299...

 

Please Accept this response as Solution if it assisted you with your question & Mark this response as Helpful.

 

Kind Regards,

Ehab Pilloor

0 Helpfuls