Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileFetch + Sharepoint: authorization failed

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:
0683p000009MBCy.png 0683p000009MB05.png 0683p000009MBD3.png
Labels (3)
10 Replies
Anonymous
Not applicable
Author

Hi everyone!

 

First of all, forgive my English

Smiley Happy


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:

0683p000009MaUy.png

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: 

 

0683p000009MaVH.png

 

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

0683p000009MaVM.png

 

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

0683p000009MaVR.png

 

0683p000009MaM1.png

 

So, hope this helps.