SFTP STEP - Flow Action Query

[Arnab13]

I am trying to fetch files from SFTP Server (via Mid Server) and attach them to a particular Data Source in ServiceNow. I am using the "SFTP Step - Copy Files to this Instance" https://www.servicenow.com/docs/bundle/xanadu-build-workflows/page/administer/flow-designer/referenc... 

• I am unsure how to choose a particular Data Source in Target Record, I am using Reference.Data Source as input and using data source.name(transformation string contains name of data source I want the files to get attached). I have attached the screenshots, can you please confirm if that's the way it should be done or otherwise is there another way to do this? Also, the Table comes up a blank.
  
• Another query - I want to run the transform map after the file is attached to the data source through the same flow action. How can I do the same?
  
  Please assist. Thanks in advance!

[Arnab13]

@Runjay Patel Can you assist please?

[Runjay Patel]

Hi @Arnab13 ,

Why floe designer? we have easy way to import data from  SFTP server using data source.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Arnab13]

@Runjay Patel How to make this recurring, should we use a Scheduled Job to fetch the file and attach to this data source at a given time during the day?

[Runjay Patel]

Hi @Arnab13 ,

Yes, first make it work through manual once all set up then schedule it.