Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Automate file transfer from SFTP to EPM

edited Oct 7, 2024 12:19PM in EPM Platform and Freeform 6 comments

Our current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on SFTP once the file is moved to EPM.

I need help on the below.

  1. We are trying to do the same with copyFromSftp REST API but I am not able to automate retrieving a file from SFTP with timestamp.
    For Example: If the filename is Testfile_MMDDYYYY_HHMMSS.csv, not able to automate retriving such files.
    If it is Testfile_MMDDYYYY.csv, I am able to retrieve using current date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!