Hi James,

Thanks for your reply.
The source has multiple files generated per day and I'm interested in one of 
those, so filtering is required I guess.
I don't know how to filter based on the filename, was trying to pipe things 
like this: ListSFTP -> UpdateAttribute -> FetchSFTP
but I'm sure there's a better way to filter. Can you help by giving me a 
pointer or two please?

I also tried to pipe directly from ListSFTP -> FetchSFTP and used 
${now():toNumber():minus(86400000):format('yyyymmdd')}-*.csv but then this 
doesn't match the remote file guessing because FetchSFTP doesn't do globing.

Thanks,
________________________________________
From: Joe Witt <joe.w...@gmail.com>
Sent: April 15, 2016 1:35 PM
To: users@nifi.apache.org 
Subject: Re: datetime argument to the GetSFTP processor

Ahh - great idea James!

On Fri, Apr 15, 2016 at 1:34 PM, James Wing <jvw...@gmail.com> wrote:
> Have you looked at a combination of ListSFTP -> FetchSFTP?  I believe
> ListSFTP has built-in support for tracking recent files, and it might
> satisfy your use case.  If not, you can certainly filter the listed files by
> the "filename" attribute before calling FetchSFTP.
>
> On Fri, Apr 15, 2016 at 7:40 AM, Ashraf Hasson <ahas...@windmobile.ca>
> wrote:
>>
>> Hi there,
>>
>>
>> I've been trying to use the GetSFTP processor to fetch files that have a
>> 'yyyymmdd' part but the only option I have is to use Java Regular
>> Expression, not sure how to specify today or yesterday's date dynamically.
>>
>>
>> I thought an alternative is to use a locally generated file that contains
>> the datetime string, use a GetFile + UpdateAttribute to pass in a custom
>> attribute to the GetSFTP processor that way, but sounded a bit cumbersome
>> tbh.
>>
>>
>> Any thoughts/hints please?
>>
>>
>> Thanks,
>>
>> Ashraf
>
>

Reply via email to