topic Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest in Talend Studio

Unable to download file from sharepoint using tFileFetch or tHttpRequest

Morpheus — Wed, 01 May 2019 17:12:52 GMT

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

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

Morpheus — Wed, 01 May 2019 20:43:01 GMT

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.

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

nfz11 — Thu, 02 May 2019 01:01:27 GMT

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?

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

Morpheus — Thu, 02 May 2019 03:52:20 GMT

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

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

hasmus — Thu, 09 May 2019 14:38:03 GMT

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.

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

Anonymous — Thu, 26 Sep 2019 12:34:16 GMT

Hi,

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

Thanks

Mat

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

Morpheus — Tue, 26 Nov 2019 17:34:09 GMT

I was able to get it done by using tSOAP component

Re: Unable to download file from sharepoint using tFileFetch or tHttpRequest

Anonymous — Tue, 11 Feb 2020 15:18:32 GMT

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