Compare latest datetime from SFTP to current datetime — Cloud Customer Connect
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

Compare latest datetime from SFTP to current datetime

edited Sep 3, 2025 6:57PM in Integration 7 comments

Summary:

Compare latest datetime from SFTP to current datetime

Content (please ensure you mask any confidential information):

I am looking for a valid function in OIC inside a Switch statement to compare the datetime of the newest file in an Oracle OIC SFTP folder to the current (system) datetime, and then perform actions depending on how the IF statement evaluates to. I believe the Switch statement needs to be inside a For Each loop in order to iterate through the files in the folder to find the latest one.

I looked at the Activity Stream for the ListFiles invoke and it appears that the Response for

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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