topic Extract the most recent file from SFTP in Talend Studio

Extract the most recent file from SFTP

Anonymous — Sat, 16 Nov 2024 05:20:49 GMT

Hi everyone.
I am trying to build a job in open studio that extract the most recent file from a SFTP
Example:

global_act_201907031230.xls

global_act_201906031230.xls

global_act_201907031430.xls

...

I am getting the path and using it to sort the files based on the date, but I have a problem when I use this path in my tFTPGET component.

This is a print screen of my job.

In my Tmap I get the date using a substring and I convert it in a number format, then I get the correct file_path in my TLogRow but the tFTPGet component is not working correctly.

TY in advance!

Re: Extract the most recent file from SFTP

Anonymous — Tue, 09 Jul 2019 14:54:46 GMT

Hi,

The job is saying that its having Null pointer exception at tFTPGet component. I would recommend you to print all the variables used in tFTPGet and see whether you are getting right data. Also do you want to iteratively do the tFTPGet process or are you sure you want to use main flow to connect to tFTPGet?

Please check the details and if the error persists, could you please provide more details for above areas.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂