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

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"})

Using Date.now() while exporting files | SnapLogic - Integration Nation

21 Replies

Supratim
Contributor III
4 years ago
@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
  Valued Contributor
  4 years ago
  
  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
    Contributor III
    4 years ago
    @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.
bojanvelevski
Valued Contributor
4 years ago
Hey @darshthakkar,

Turn on the expressions support, and wrap the static part of the path in quotes. Than simply add the Date.now() function at the end. It will look something like this:

"sftp://localnetwork:22/usr/local/Enterprise/server/sharedcommon/incoming/SCM/Users/DT/inbound/ErrorLog.xlsx" + Date.now()

But I suppose you want the Date first, than the file extension so I would go with this:

"sftp://localnetwork:22/usr/local/Enterprise/server/sharedcommon/incoming/SCM/Users/DT/inbound/ErrorLog_" + Date.now() + ".xlsx"

Regards,
Bojan
- darshthakkar
  Valued Contributor
  4 years ago
  
  bojanvelevski:
  
  “sftp://localnetwork:22/usr/local/Enterprise/server/sharedcommon/incoming/SCM/Users/DT/inbound/ErrorLog_” + Date.now() + “.xlsx”
  
  Thanks @bojanvelevski for providing the actual string however it is failing as seen in the below snap:
  - bojanvelevski
    Valued Contributor
    4 years ago
    First, check the spelling, I wrote the expression from the image you provided, so I may have missed something.
    
    Also, I noticed that you’re using 2 different snaps in your samples above, so check if the Account is properly configured.
darshthakkar
Valued Contributor
4 years ago

darshthakkar:

(1) Successful execution [passing pipeline parameter and selecting the ‘=’ decorator

@siwadon: Thanks for the clarification, I’ve replied to my previous comment so that you can check the screenshot of a successful run.

Date.now() works well if I’m passing a parameter for writing my files however if I provide a static name to a file (e.g. TestFile) and want to ingest Date.now(), it doesn’t work.

Again, Date.now() to a static file name would work if the files are written in snapLogic Manager however I faced the challenge while writing the files to a sftp.

Let me know if you need any further clarifications and I would be more than happy to provide you all the details.
- siwadon
  Employee
  4 years ago
  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"})
  - darshthakkar
    Valued Contributor
    4 years ago
    This worked, THANKS A TON for your help @siwadon.
khanh_tran
New Contributor III
5 years ago

j.angelevski:

{}.extend(…$group)

Woah. That’s great. I didn’t know that. You’re my hero. hahaha. Here is my result. I worked.