SharePoint File download

[Anonymous]

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

[manodwhb]

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

[Anonymous]

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.

[abhi90]

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.

[Anonymous]

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-t...

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