SharePoint File download

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads