Flow Designer Query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 12:51 PM
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) -
- 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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-30-2024 06:51 PM
then SFTP step won't help here
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-31-2024 01:57 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-31-2024 07:18 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader