topic Re: tFileFetch and Sharepoint in Talend Studio

tFileFetch and Sharepoint

_AnonymousUser — Mon, 04 Nov 2013 21:30:32 GMT

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.

Re: tFileFetch and Sharepoint

Anonymous — Tue, 05 Nov 2013 03:12:35 GMT

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

Re: tFileFetch and Sharepoint

_AnonymousUser — Wed, 27 Jul 2016 15:18:56 GMT

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

Re: tFileFetch and Sharepoint

_AnonymousUser — Thu, 28 Jul 2016 13:58:54 GMT

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

Re: tFileFetch and Sharepoint

Anonymous — Fri, 04 May 2018 06:14:52 GMT

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

Re: tFileFetch and Sharepoint

Morpheus — Wed, 01 May 2019 16:45:23 GMT

Hi @Moe ,

Can you please share the settings you used for tHttpRequest?

Re: tFileFetch and Sharepoint

Anonymous — Tue, 11 Feb 2020 15:40:53 GMT

Hi,

could you be a bit more explicite please ? Like a screenshot of your thttprequest configuration, other subtleties that I miss ..

Best regards,