I am attempting to configure a GetSFTP processor to retrieve a single file
for 'yesterday'. I do not have any control over what is located in the
remote file system and I definitely don't want to pull everything.
I have not been able to find a way to target the single file using a
dynamically generated name.
Initially, I thought I would be able to make use of the following NiFi
Expression:
/opt/logs/${now():toNumber():minus(86400000):format('ddMMyyyy')}.txt
However, I haven't been able to figure out a spot where I can plug in the
expression. The 'Remote Path' field accepts an expression, but appears to
be limited to path only and will not select for a full path/filename.
The next approach was to specify a 'File Filter Regex', but NiFi
expressions are not supported.
Is there a way to pre-calculate the filename for use by the file filter
regex?
Thanks!
Michael