Unable to download file from sharepoint using tFileFetch or tHttpRequest

[Morpheus]

Hi Experts,

tFileFetch, tHttpRequest, Sharepoint

I am trying to download a file from an intranet sharepoint url. I tried with both tFileFetch and tHttpRequest components. Both are failing. Appreciate any pointers to get this issue resolved.

tFileFetch

Fails with "Exception in component tFileFetch_1
java.lang.Exception: Method failed: HTTP/1.1 401 Unauthorized"

Below is the component configuration

tHttpRequest

Fails with "tHttpRequest_1 Request failed:400 Bad Request
Exception in component tHttpRequest_1
java.lang.RuntimeException: Request failed:400 Bad Request"

Below is the component configuration

[Morpheus]

Hi @xdshi ,

Appreciate if you can give us some pointers related to this issue. Tried various options as per to existing forum posts. Nothing worked and hence asking.

[nfz11]

Are you sure your authentication credentials are correct and that the server uses basic HTTP authentication?  Can you get the download to work in a browser or Postman with those values?  Why are you doing a POST, seems it should be a GET?

[Morpheus]

It does work in the browser. I tried with both get and post. Still the same
error message.

[hasmus]

Are there any solutions in the meantime? I came across the same problem. An attempt was made to retrieve a file via https from SharePoint. Help on this would be very nice.

[Anonymous]

Hi,

Did you find a solution ? I have exactly the same problem...

Thanks

Mat

[Morpheus]

I was able to get it done by using tSOAP component

[Anonymous]

Hi chanaka, 

could you please be more explicite. 

I see how to use tfilefletch ou thttprequest, although I have a 403 like so many people trying to acces Sharepoint with Talend. I also tried to used a custom component tSharepointFile released on Talend Exchange back in 2009, but the component seems deprecated with Talend 7.2 (I try to contact the developper but the email is not working) ...

I am really stuck, like a lot of people I read in blogs etc. Would be very much appreciated

Best regards