Send report s an attachment to sftp server

[sreekeerthi]

Hi,

We have a requirement to send report as an attachment to SFTP server. for this, I have created a table and a scheduled script to generate csv file of the report everyday and attach it to the table. I have created the credentials and also connections alias. But struck with the flow on how to send this over SFTP. Can anyone please help on this request.

Thank you in Advance!

Regards,

Sree Keerthi Kasula

[Bhimashankar H · Accepted solution]

Hi @sreekeerthi ,

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 

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[Ankur Bawiskar · Accepted solution]

@sreekeerthi 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.

[Bhimashankar H]

Hi @sreekeerthi ,

I hope you saw my reply. Please go throw the reference added in my original post.

If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. It will help future readers as well having similar kind of questions and close the thread.

Thanks,
Bhimashankar H

[sreekeerthi]

Thank you for all the suggestions. These were very helpful.