Flow Designer Query

[ArnabB]

I'm trying to fetch files from Mid Server to attach to a data source and run transform to move the data to Target table.

I am trying this approach -

• Scheduling a flow to trigger every day at 12 midnight
• The flow will call an action
  • I'm not really sure what to define as Input to the action - Kindly suggest  
• In the Action I am using SFTP Step (docs link below) - 
  • https://www.servicenow.com/docs/bundle/xanadu-build-workflows/page/administer/flow-designer/referenc... 
• I am not getting the option to attach the file to the desired data source (attached screenshot).

Also, I am not getting how to attach the file to the desired data source and run the transform automatically through the same flow.

Please suggest! Thank you! 

[Ankur Bawiskar]

@ArnabB 

that flow action/step is for SFTP which is not related to mid server

there are other alternatives to achieve your requirement

check this link

How to import a CSV file from a MID Server 

also check this link

Automated Data Import - Using MID Server and PowerShell 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[ArnabB]

@Ankur Bawiskar 
Hi. The recommendation is to look for a OOTB solution rather than using custom powershell script. Is there any reason you're saying that SFTP Step - Copy Files To Instance will not work to copy data from Mid Server to Data Source?

[Ankur Bawiskar]

@ArnabB 

SFTP will move files from sftp server to instance

But you want to fetch files from mid server right?

[ArnabB]

@Ankur Bawiskar 

Yes we want to move files from Mid Server to a particular data source in the ServiceNow instance and also run the transform map after that.