Hi Henrik
Yes - a pretty simple and straight forward request I think...
In our environment, a customer transfers 'Data' files to our SFTP server. Once the files have been sent from the customer end, they then send a reconciliation file (the famous RECCY.TXT file I have been working with lately). This is a list of files and file sizes that 'they' say they have sent.
So, we are looking for the 'RECCY.TXT' file in a particular folder on the SFTP server. At the moment, there is no Event Trigger so we do this on a 5 minute scheduled trigger basis. (Hint at new feature request there).
Once the RECCY file is received we then read the contents, so we know what the customer 'says' they sent to us. The piece that is missing is that WE need to List the actual physical files that ARE in the customers SFTP folder and compare our list with the Customers RECCY list. IF they both agree, then we continue downloading. If they Don't agree, then we leave what's there and instigate a Notification process (Email to the customer) asking them politely to sort their files out 😂
So, it basically is an Audit facility that protects both the customer and ourselves.
Somehow we need to put this process in place immediately as we can't bypass the audit checks for business compliance reasons. For now it will have to be a manual process (aaargh) as I can't even run a Powershell script to check the folders as the 'get-ftp' cmdlet is not supported in VC :-(
Hope that makes it a wee bit clearer?
Cheers
Andy