Forum Discussion

NelsonArce's avatar
NelsonArce
Qrew Member
3 years ago

Pipeline Help: Inserting a Timestamp Into the File Name (SharePoint Channel)

Hello! I am generating a CSV file 6x day (i.e. every 4 hours) and uploading it to a SharePoint folder. Everything works great overalI; I am currently attaching the record_id to the beginning of each file (to solve for the latest file overwriting the last one), however I am being asked if we can begin each file with a date/time stamp instead if possible.

I successfully used {{time.now|date_ymd}} to create a date but nothing is working for time; not {{time.now}} nor {{time.today}}. Error messages are embedded for context. Has anyone succeeded doing this?


------------------------------
Nelson Arce
------------------------------
Pipelines
  • SeanConnaughto1's avatar
    SeanConnaughto1
    Qrew Cadet
    3 years ago
    You are getting that error because filenames in share point cannot have ":"

    Try this:
    {{time.now.strftime("%Y-%m-%d %H %M %S")}}​​


    That should work, you can change the text where needed, but that should make it work



    ------------------------------
    Sean Connaughton
    ------------------------------