Hi All,
I would like to know if there is any best practice to handle dynamic file name inside the delimited file source. HR systems generate different file name daily by appending the timestamp in the file.
Coming from IIQ, I usually put a script to change the file name before loading it to SailPoint.
Any comments are appreciated, thanks!
I would utilize File Upload Utility and a script, you can rename the file with the script
@b-julian Delimited File source in ISC expects a fixed file path and doesn’t natively support dynamic file names or wildcard patterns.
A common approach is to use an external script or scheduler (Shell, PowerShell, etc.) to rename the latest HR file to a consistent name (for example, employee.csv) before the aggregation runs. This is similar to what many of us used to do in IdentityIQ.
Another option is to move or copy the latest timestamped file to a fixed location with a static name that ISC can always reference.
@b-julian you should have a script to transfer the file to archive once you load it so in that case this issue should not come. Or if you use SAAS base connector you can use file upload utility to specify specific file names
Thanks all for the feedback, I think I will stick to use the script just like in IIQ then.
