Flow Designer Query

ArnabB
Tera Contributor

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 -

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! 

7 REPLIES 7

@ArnabB 

then SFTP step won't help here

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

I checked the requirements, it is to bring the files from SFTP Server (via Mid Server), not necessarily from the Mid Server directly, sorry for the confusion.

 

I need advise regarding couple of things - 

 

1. How to choose a particular Data Source in Target Record. I am using Reference.Data Source as Input. I get data source.sys_id or data source.name in target record, but not sure it'll work. Should I use transformation of sys_id contains the particular sys_id of a data source?

2. How to run the transform map through the flow right after the file is attached to the data source?

@ArnabB 

I haven't used that flow action so not very sure on that.

try to search in docs or community how it can be used

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader