SFTP STEP - Flow Action Query

Arnab13
Tera Contributor

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.
    Arnab13_1-1735833425927.png

     

    Arnab13_2-1735833457997.png
  • 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!
6 REPLIES 6

Arnab13
Tera Contributor

@Runjay Patel Can you assist please?

Runjay Patel
Giga Sage

Hi @Arnab13 ,

 

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

RunjayPatel_0-1735835074220.png

 

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

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

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

 

@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?

Hi @Arnab13 ,

 

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