tFileFetch and Sharepoint

One Star

tFileFetch and Sharepoint

Hi All,
I am trying to use tFileFetch to retrieve a document from Sharepoint but get the following error:
Exception in component tFileFetch_2
java.lang.NullPointerException
The URI I am using is:
"http://<sitename>/sites/COP/Expected%20Rates/Cooper%20Oil%20Expected%20Rates%20-%20November%2013%20Final.xlsx"
I need to have "Enable NTLM Credentials" and "Need authentication" box ticked otherwise I get the "Unauthorized" exception message.
Anyone else having issues using Talend to fetch files from Sharepoint? If it helps, I have tried both Sharepoint 2003 and 2010.
Moderator

Re: tFileFetch and Sharepoint

Hi,
Exception in component tFileFetch_2
java.lang.NullPointerException

Did you use two tfilefetch components in your job? Please us your job workflow screenshot so that we can see if there is any wrong setting or missing.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Not applicable

Re: tFileFetch and Sharepoint

Hi,
I have the same issue.
I ran a job with a component tFilefetch and get this error message:
: talend_mdm_aop.test_sharepoint_0_1.TEST_SHAREPOINT - tFileFetch_1 Method failed: HTTP/1.1 401 Unauthorized
Exception in component tFileFetch_1
java.lang.Exception: Method failed: HTTP/1.1 401 Unauthorized
at talend_mdm_aop.test_sharepoint_0_1.TEST_SHAREPOINT.tFileFetch_1Process(TEST_SHAREPOINT.java:802)
at talend_mdm_aop.test_sharepoint_0_1.TEST_SHAREPOINT.runJobInTOS(TEST_SHAREPOINT.java:4864)
at talend_mdm_aop.test_sharepoint_0_1.TEST_SHAREPOINT.main(TEST_SHAREPOINT.java:4607)
In tab "Advanced settings" of component tFileFetch:
-I flagged "Need authentication" check box and enter a user name and a password
-I flagged "NTLM credential" check box and entre a domain name. If I don't do that I have error message below:
: org.apache.commons.httpclient.HttpMethodDirector - Credentials cannot be used for NTLM authentication: org.apache.commons.httpclient.UsernamePasswordCredentials
Here are screen shots of my job configuration:

Regards.
Eric
Not applicable

Re: tFileFetch and Sharepoint

As a workaround, I ended up using tHttpREquest component. It works fine.
Four Stars

Re: tFileFetch and Sharepoint

Hi ,

 

I am using tHttpsRequest component to download a file from sharepoint ,but faicing below error. Can you please help me understand the solution ?

 

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