Unable to download file from sharepoint using tFileFetch or tHttpRequest

Seven Stars

Unable to download file from sharepoint using tFileFetch or tHttpRequest

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
tFileFetch_1.JPG

 

 

 

tFileFetch_2.JPG

 

 

 

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
tHttpRequest-01.JPG

Seven Stars

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

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.

 

Nine Stars

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

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?

--
Please give Kudos and mark topics as solved where appropriate.
Seven Stars

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

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

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

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.

One Star

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

Hi,

 

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

 

Thanks

 

Mat

Seven Stars

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

I was able to get it done by using tSOAP component

Four Stars

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

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog