topic Re: Download Share Point file from Talend "tFileFetch" component in Talend Studio

Download Share Point file from Talend "tFileFetch" component

KNH — Tue, 11 Feb 2025 07:03:17 GMT

Hi,

I am using "tFileFetch" component to download Share Point files from Talend. I received below error message.

"Starting job tfilefetch_sharepoint at 14:52 11/02/2025.
[statistics] connecting to socket on port 3661
[statistics] connected
Exception in component tFileFetch_1 (tfilefetch_sharepoint)
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.tFileFetch_1Process(tfilefetch_sharepoint.java:523)
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.runJobInTOS(tfilefetch_sharepoint.java:1224)
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.main(tfilefetch_sharepoint.java:922)
[FATAL] 14:52:49 dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint- tFileFetch_1 Method failed: HTTP/1.1 403 FORBIDDEN
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.tFileFetch_1Process(tfilefetch_sharepoint.java:523) [classes/:?]
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.runJobInTOS(tfilefetch_sharepoint.java:1224) [classes/:?]
at dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint.main(tfilefetch_sharepoint.java:922) [classes/:?]
[statistics] disconnected"

Here is my configuration setting.

Can you please advise how to solve this issues?

Thanks you so much in advance.

Re: Download Share Point file from Talend "tFileFetch" component

Dave_Simo — Tue, 11 Feb 2025 08:50:51 GMT

Hello,

https://community.qlik.com/t5/Design-and-Development/Extracting-data-from-Sharepoint-tfilefetch/td-p/2247105

You can try like in this link

Best Regards

Re: Download Share Point file from Talend "tFileFetch" component

KNH — Tue, 11 Feb 2025 08:57:51 GMT

Hi @Dave_Simo ,

Thanks you so much for your reply. It doesn't provide solution in that link. It only say that we can download file using tFileFetch and tHttpRequest component.

Re: Download Share Point file from Talend "tFileFetch" component

Dave_Simo — Tue, 11 Feb 2025 09:09:27 GMT

Hello,

This one should be better.

https://community.qlik.com/t5/Official-Support-Articles/Talend-Studio-How-to-download-a-file-from-SharePoint-using/ta-p/2151044

Best Regards,

Re: Download Share Point file from Talend "tFileFetch" component

KNH — Wed, 12 Feb 2025 02:11:09 GMT

Hi @Dave_Simo ,

Thanks you so much for your reply. I tried same method like the below link which you provided me.

https://community.qlik.com/t5/Official-Support-Articles/Talend-Studio-How-to-download-a-file-from-Sh...

To get URL link from share point folder. I used 2 methods.

Method 1.

Method 2

Both method doesn't work for me. It gives me same error.

It gives me same error as below.

"[FATAL] 09:55:11 dashboard_test.tfilefetch_sharepoint_0_1.tfilefetch_sharepoint- tFileFetch_2 Method failed: HTTP/1.1 403 FORBIDDEN
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN"

Could it be lacks of authentication or permissions? I got fully access right for that share point folder. Should I try tHttpRequest component.

I tested below scenario from Talend documents library. It works properly.

https://help.qlik.com/talend/en-US/components/8.0/internet/tfilefetch-tfileinputdelimited-tlogrow-tlogrow-fetching-data-through-http-standard-component-this

Re: Download Share Point file from Talend "tFileFetch" component

KNH — Wed, 12 Feb 2025 03:14:01 GMT

I am not able post to reply the discussion and always disappearing my reply. someone deleting my post?

Re: Download Share Point file from Talend "tFileFetch" component

KNH — Wed, 12 Feb 2025 05:37:04 GMT

Hi @Dave_Simo ,

Thanks you so much for your reply. I tried the same method like below link that you provided me. I got same error as before.

https://community.qlik.com/t5/Official-Support-Articles/Talend-Studio-How-to-download-a-file-from-Sh...

Here is error message for your reference.

"Exception in component tFileFetch_2 (tfilefetch_sharepoint)
java.lang.Exception: Method failed: HTTP/1.1 403 FORBIDDEN"

Could it be authentication or permissions issues? I got full access right to Share Point file.

Thanks again.

Re: Download Share Point file from Talend "tFileFetch" component

Dave_Simo — Wed, 12 Feb 2025 08:17:07 GMT

Hello @KNH ,

This one should be better because it shows an example design of the job to use to download a file from SharePoint.

https://community.qlik.com/t5/Design-and-Development/How-to-upload-download-files-to-from-a-SharePoint-using/td-p/2308387

Best Regards

Re: Download Share Point file from Talend "tFileFetch" component

KNH — Mon, 17 Feb 2025 07:05:02 GMT

Hi @Dave_Simo ,

Thanks you so much for all the solutions you provided.

Below are the some points that I figured it out after I tried few difference way.

1. tFetchFile component is not applicable for SharePoint Online (Office 355) and it is required to used tHttpRequest or tRest component. I am using SharePoint Online and it requires OAuth 2.0, App Permissions, or Modern Authentication, while tFetchFile may not be able to handle this level of authentication.

2. The tFetchFile component is primarily used in Talend for fetching files from various sources, such as FTP, HTTP, or local file systems. However, it is not specifically designed for SharePoint Online (Office 365).

3. SharePoint Online (Office 355) needs token-based authentication.

5. To connect SharePoint API, We can use either "SharePoint REST API" or "Microsoft Graph API".

6. If you are only working with SharePoint Online, then using the SharePoint REST API with tHttpRequest is the simplest and most efficient way. However, if your Talend project needs to expand beyond SharePoint (e.g., integrating OneDrive or Teams), then Microsoft Graph API is the better long-term choice.