topic Re: tFileFetch + Sharepoint: authorization failed in Talend Studio

tFileFetch + Sharepoint: authorization failed

Anonymous — Tue, 28 Jul 2015 16:06:58 GMT

I'm unable to use the tFileFetch to download a file from Sharepoint 2010 library.
I've tried to use different environments (Windows 7 x64 with AD login, Windows 2008 x64 with AD login and Windows 2008 x86 with local login) to achieve the task. I've tried the TOS 5.6.2 and 6.0.0.

Error message in the console:
: org.apache.commons.httpclient.auth.AuthChallengeProcessor - ntlm authentication scheme selected
Exception in component tFileFetch_1
java.lang.Exception: Method failed: HTTP/1.1 401 Unauthorized
    at em_esb.sharepoint_read_file_0_1.Sharepoint_read_file.tFileFetch_1Process(Sharepoint_read_file.java:345)
: org.apache.commons.httpclient.HttpMethodDirector - Failure authenticating with NTLM <any realm>@portal:80
    at em_esb.sharepoint_read_file_0_1.Sharepoint_read_file.runJobInTOS(Sharepoint_read_file.java:667)
    at em_esb.sharepoint_read_file_0_1.Sharepoint_read_file.main(Sharepoint_read_file.java:524)
UPDATE: added missing screenshoot with the basic settings tab of used tFileFetch component.

ScreenShots:

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Thu, 30 Jul 2015 09:56:28 GMT

Have anybody successfully used the tFileFetch with NTLM authentication?

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Thu, 30 Jul 2015 10:05:58 GMT

When posting initial question, I've uploaded wrong screenshot (screenshot of the "Basic settings" tab was missed). I've just corrected it - please see initial post.

Re: tFileFetch + Sharepoint: authorization failed

Jcs19 — Thu, 30 Jul 2015 10:37:06 GMT

Hi,
I can download a file from a Sharepoint with tHttpRequest
I've tried with tFileFetch but I didn't succeed
Download the file manually (save the request you sent). Copy the request into the tHttpRequest
My http request was really long , looks like "https://wired......./owssvr.dll?XMLDATA=1&List={99ACA314-FFFB-4256-A17A-3BFC5971824F}&View={6E33A57B-8930-49B6-8B49-310428F973B0}&RowLimit=0&RootFolder=%2fcommunities%2feu%2fluxembourgcentral%2fAdmin%2fLists%2fClient"
Get the request with your browser developper tool or wireshark
Then instead of using NTML Domain, tick Need authentication, your user name should be "DOMAIN_NAME\\USER_NAME"
Yes double \\

Or you can try to put ntlmauth.dll into the bin folder of Java (I think its for Windows Authentificate for MSSQL but you can try...)

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Thu, 30 Jul 2015 10:46:40 GMT

Jcs19, thanks a lot for your recipe! I'll try it.

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Thu, 30 Jul 2015 16:53:49 GMT

Okay, I've just managed to download a file from the Sharepoint 2010 using the tHttpRequest - authentication is working.
Next question - how to upload a file to the Sharepoint using the tHttpRequest?

Re: tFileFetch + Sharepoint: authorization failed

Jcs19 — Thu, 30 Jul 2015 18:06:31 GMT

Okay, I've just managed to download a file from the Sharepoint 2010 using the tHttpRequest - authentication is working.
Next question - how to upload a file to the Sharepoint using the tHttpRequest?

same as downloading, upload a file manually, get the request with its parameters and put it all in tHttpRequest (change parameter if needed)

Re: tFileFetch + Sharepoint: authorization failed

abhi90 — Wed, 18 Apr 2018 06:35:06 GMT

Hi @Jcs19,
Can u please post your JobDesign? Or can u send me the Job? We are trying to download upload file to SharePoint Microsoft of Office365 for last 1month.

Re: tFileFetch + Sharepoint: authorization failed

Jcs19 — Wed, 18 Apr 2018 21:54:38 GMT

Sorry, I don't have access to my job design anymore because I don't work
for the same company (this post is 2.5 years old)

All i can suggest you is to record the network with your browser while you
download the file and try to put the same parameters/cookies into
tHttpRequest

Or maybe someone made a custom component for sharepoint? i don't know

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Fri, 04 May 2018 06:11:09 GMT

Hi ,

I am trying to fetch the file from sharepoint using tHttpsRequest component but facing the below issue:

Can you please help me here?

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR]: newone.testsharepoint_0_1.testsharepoint - tHttpRequest_1 - sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Re: tFileFetch + Sharepoint: authorization failed

Anonymous — Thu, 25 Jun 2020 21:26:29 GMT

Hi everyone!

First of all, forgive my English

I've tried to download a file from a Sharepoint with tHttpRequest but it was unsuccessful.

So, using tFileFetch I could download the Excel successfully.

Below are the steps I took:

1 - Open the folder where is located the file you want to download;

2 - Press F12, open tab "Network" (Google Chrome);

3 - Download the file manually;

4 - First select the line that contains "document" in tab "Type" and copy the main URL:

Paste it in your notepad. Note that the URL is encrypted.

5 - Rigth-button click on the same line and follow the highlighted spots as bellow:

Paste it in your notepad again. You will see some informations such as encrypted URL and the Headers (lines started with "-H"):

6 - After that, you just need to configure the tFileCatch:

So, hope this helps.