โ04-26-2022 02:43 PM
Hi Team,
While writing files via sftp, Iโm unable to ingest Date.now() in the filename itself as seen in the snaps below:
(1) Successful execution [passing pipeline parameter and selecting the โ=โ decorator
(2) Failed execution [NEITHER passing any parameter NOR selecting โ=โ decorator]
The reason behind not selecting =
decorator is - โIโm not passing any parameter to dynamically generate filenameโ
If the file name needs to be constant and it needs to be exported via sftp with Date.now(), what tweaks should I do? Iโm pretty sure, snapLogic would be able to handle that and I might be doing something wrong here.
Thanks in advance for your help ๐
Regards,
DT
Solved! Go to Solution.
โ04-29-2022 01:26 PM
Understood but I donโt think itโs the problem with the static or dynamic reference if you can write other files to the FTP server without any problems. The only thing I could think of is that the filename contains illegal characters.
Can you please try the expression below first?
Date.now().toLocaleDateTimeString({"format":"yyyyMMddHHmmss"})
โ04-26-2022 08:59 PM
@darshthakkar Make expression enabled by clicking on the โ=โ on filename and can use below expression - โ%s/%s%s.csvโ.sprintf(โbaseSFTPPathโ,โconstantFileNameโ,Date.now().toLocaleDateTimeString({โformatโ:โyyyyMMddHH:mm:ssโ}))
โ04-27-2022 06:53 AM
Thank you @Supratim for providing the string for file writer but this is failing as well.
โ04-27-2022 09:11 PM
@darshthakkar Just to make sure you config correctly - 1. use wincsp/other tools to login the sftp server (please use same credential as used in snaplogic). And try to create a file there. If you can then it should work in snap as well.
2. Make sure you choose cloudplex/groundplex correctly.
3. And hope you validate this is sftp server not smb.
โ04-29-2022 11:47 AM
Done, still not working for me.