This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Using Date.now() while exporting files

Go to solution
darshthakkar
Valued Contributor

‎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
image

(2) Failed execution [NEITHER passing any parameter NOR selecting ‘=’ decorator]
image

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

0 Kudos
1 ACCEPTED SOLUTION

Go to solution
siwadon
Employee
Employee
In response to darshthakkar

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

View solution in original post

21 REPLIES 21

Go to solution
siwadon
Employee
Employee
In response to darshthakkar

‎04-29-2022 03:46 PM

What does the timestamp part look like after the ID prefix? Does it has colons?

Go to solution
darshthakkar
Valued Contributor
In response to siwadon

‎04-29-2022 04:41 PM

@siwadon: I tried putting Date.now() in the file path which was having _pipelineParameter as its file name but it is showing the same error now.
It was working at the beginning of this week but I didn’t want Date.now() for the dynamic file name so I deleted all the generated files (~5k) and cleared the recycle bin as well.

If I’m able to replicate the same, I will keep you posted and apologies as I couldn’t share the required details and file as well for your validation purposes.

0 Kudos