How to download multiple zip files from linux server in local starting with same prefix name (e.g. ARESFF01.341,ARESFF01.342, etc) with sftp in fme?Can we use FTPCaller?If so, how? If we can do it other way also kindly suggest.
Best answer by caracadrian
Use FTPCaller to list all files in ftp folder. Set FTPCallet to Transfer Type: Download to an Attribute (URL must end in /).
Use two steps to split the _file_contents attribute: AttributeSplitter by CRLF + ListExploder and AttributeSplitter by splace " " + ListIndexer set to -1 to select the last element in the list.
StringSearcher on desired string (as in your example, use Regular expression ^ARESFF - begins with ARESFF).
Send the output from Matched port to a second FTPCaller set to the initial URL concatenated with the result of the result of StringSearcher and Transfer Type: Download to a file.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+23- Contributor
- Best Answer
Use FTPCaller to list all files in ftp folder. Set FTPCallet to Transfer Type: Download to an Attribute (URL must end in /).
Use two steps to split the _file_contents attribute: AttributeSplitter by CRLF + ListExploder and AttributeSplitter by splace " " + ListIndexer set to -1 to select the last element in the list.
StringSearcher on desired string (as in your example, use Regular expression ^ARESFF - begins with ARESFF).
Send the output from Matched port to a second FTPCaller set to the initial URL concatenated with the result of the result of StringSearcher and Transfer Type: Download to a file.
+23- Contributor
Use FTPCaller to list all files in ftp folder. Set FTPCallet to Transfer Type: Download to an Attribute (URL must end in /).
Use two steps to split the _file_contents attribute: AttributeSplitter by CRLF + ListExploder and AttributeSplitter by splace " " + ListIndexer set to -1 to select the last element in the list.
StringSearcher on desired string (as in your example, use Regular expression ^ARESFF - begins with ARESFF).
Send the output from Matched port to a second FTPCaller set to the initial URL concatenated with the result of the result of StringSearcher and Transfer Type: Download to a file.
I also atached a sample worksace to get you on your path.
I also atached a sample worksace to get you on your path.
Thanks it worked with little modification in my case.