Using Date.now() while exporting files

[darshthakkar]

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

[Supratim]

@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”}))

[darshthakkar]

Supratim:

“%s/%s%s.csv”.sprintf(“baseSFTPPath”,“constantFileName”,Date.now().toLocaleDateTimeString({“format”:“yyyyMMddHH:mm:ss”}))

Thank you @Supratim for providing the string for file writer but this is failing as well.

[Supratim]

@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.

[darshthakkar]

Supratim:

@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.

Done, still not working for me.