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

 

Forteen Stars

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/accept the solution when a replay is helpful.
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.

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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch