tFileFetch and Sharepoint

[_AnonymousUser]

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.

[Anonymous]

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

[_AnonymousUser]

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

[_AnonymousUser]

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

[Anonymous]

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

[Morpheus]

Hi @Moe ,

Can you please share the settings you used for tHttpRequest?

[Anonymous]

Hi,

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

Best regards,