topic How to trigger a job automatically when User drops file on FTP Server (BOX) in Talend Studio

How to trigger a job automatically when User drops file on FTP Server (BOX)

sr11 — Fri, 10 May 2019 16:03:07 GMT

I have a requirement wherein the job has to get triggered and process the file as and when a User drops a File on BOX(FTP Location).

TAC File Trigger does not work for this.

How can I set the job to continually poll the FTP location and then get the files to local and process the same?

Any inputs?

Thanks in advance

Re: How to trigger a job automatically when User drops file on FTP Server (BOX)

Anonymous — Sat, 11 May 2019 17:34:11 GMT

The way I would attempt this is to use the BOX API to see if you can get it to call a webhook when a new file arrives. Use that webhook to call the Talend metaservlet API to trigger the job. I have not done this (and do not know the BOX API), but I suspect this approach is the one you want.

Re: How to trigger a job automatically when User drops file on FTP Server (BOX)

sr11 — Fri, 17 May 2019 19:24:33 GMT

Thank you very much for the reply. I do see that Webhooks option is available with Talend Cloud.

Would like to know if this is do-able in Talend v 6.1 and, if yes - can you pl layout / suggest how the design should be

Appreciate your assistance on the same

Thank you

Re: How to trigger a job automatically when User drops file on FTP Server (BOX)

Anonymous — Sat, 18 May 2019 12:14:33 GMT

I'm not very familiar with the Box API. However I have been able to find out that Box supports webhooks. So what I was suggesting was to create a web service using Talend ESB. This would be called by the Box API when the trigger criteria are met. You could then use the Talend Service to trigger your job to pick up and process the file. To do this, you can make use of the Talend metaservlet API. This API allows you to control the TAC.