From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

SharePoint File download

Highlighted
Employee

SharePoint File download

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:

 

tFileFecth.PNG

 

 

 

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 article and 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

 

Highlighted
Moderator

Re: SharePoint File download

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

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: SharePoint File download

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.

Highlighted
Eight Stars

Re: SharePoint File download

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.
Highlighted
Four Stars

Re: SharePoint File download

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

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog