topic SharePoint File download in Talend Studio

SharePoint File download

Anonymous — Mon, 23 Apr 2018 12:38:12 GMT

Hello

I am trying to develop a job that downloads a file from sharePoint using the 'tFileFecth' component and when I run this I get:

Starting job sharePoint at 11:59 23/04/2018.

[statistics] connecting to socket on port 3967
[statistics] connected
Exception in component tFileFetch_1 (sharePoint)
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN
    at sample_jobs.sharepoint_0_1.sharePoint.tFileFetch_1Process(sharePoint.java:569)
    at sample_jobs.sharepoint_0_1.sharePoint.runJobInTOS(sharePoint.java:925)
    at sample_jobs.sharepoint_0_1.sharePoint.main(sharePoint.java:751)
[FATAL]: sample_jobs.sharepoint_0_1.sharePoint - tFileFetch_1 Method failed: HTTP/1.1 403 FORBIDDEN
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN
    at sample_jobs.sharepoint_0_1.sharePoint.tFileFetch_1Process(sharePoint.java:569)
    at sample_jobs.sharepoint_0_1.sharePoint.runJobInTOS(sharePoint.java:925)
    at sample_jobs.sharepoint_0_1.sharePoint.main(sharePoint.java:751)
[statistics] disconnected
Job sharePoint ended at 11:59 23/04/2018. [exit code=1]

when I followed the steps in this articleand copied the URL from the 'Share' button, I got this error...

Starting job sharePoint at 12:36 23/04/2018.

[statistics] connecting to socket on port 3698
[statistics] connected
Exception in component tFileFetch_1 (sharePoint)
java.lang.Exception: Method failed: HTTP/1.1 301 Moved Permanently
	at sample_jobs.sharepoint_0_1.sharePoint.tFileFetch_1Process(sharePoint.java:569)
	at sample_jobs.sharepoint_0_1.sharePoint.runJobInTOS(sharePoint.java:925)
	at sample_jobs.sharepoint_0_1.sharePoint.main(sharePoint.java:751)
[FATAL]: sample_jobs.sharepoint_0_1.sharePoint - tFileFetch_1 Method failed: HTTP/1.1 301 Moved Permanently
java.lang.Exception: Method failed: HTTP/1.1 301 Moved Permanently
	at sample_jobs.sharepoint_0_1.sharePoint.tFileFetch_1Process(sharePoint.java:569)
	at sample_jobs.sharepoint_0_1.sharePoint.runJobInTOS(sharePoint.java:925)
	at sample_jobs.sharepoint_0_1.sharePoint.main(sharePoint.java:751)
[statistics] disconnected
Job sharePoint ended at 12:36 23/04/2018. [exit code=1]

I have not been able to find any useful help and material on this.

Let me know

Thanks

Re: SharePoint File download

manodwhb — Mon, 23 Apr 2018 12:54:55 GMT

Since you are accessing secure https server right,you need to authentication? do you enabled Need authentication in Advanced settings of tFileFetch?

Re: SharePoint File download

Anonymous — Mon, 23 Apr 2018 13:02:49 GMT

I did, but has made no difference. Still got the same error. BTW - I copied and pasted the URL on a different browser app (i.e. MS Edge) using inPrivate mode, so this is not using any saved session cookies etc and I was able to view the files without being prompted for authentication.

Re: SharePoint File download

abhi90 — Mon, 23 Apr 2018 20:12:13 GMT

It is very difficult to download or upload file from Sharepoint using Talend. We are trying for last 1 months. U will find i posted questions already.

Re: SharePoint File download

Anonymous — Tue, 11 Feb 2020 15:36:31 GMT

I agree with Abhi90,

I spend the last 2 days trying every solutions I find the web, with tfilefetch, thttprequest, a custom component tsharepoint which seems deprecated, and at the end I still have a 403 (good credentials, url taken from the copy button of the shared file on sharepoint, or taken for the http request of my browser, etc).

It is way too complicated and not well supported. The official solution :

https://community.talend.com/t5/Migration-Configuration-and/While-accessing-a-file-from-Sharepoint-the-tHttpRequest/ta-p/43696

end up with "Pay a support licence 'cause we have a solution, but not for free" ....