topic Re: tHttpRequest in Talend Studio

tHttpRequest

Anonymous — Mon, 10 Jul 2017 20:51:00 GMT

Hi I'm trying to use the tHttpRequest component to fetch a file from a cloud based sharepoint using TOS 6.3.0.

I've tried various combinations of the URL but am failing to retrieve the file, be grateful for any assistance,

currently the URL looks like this:

"https://xxx.sharepoint.com/Freigegebene%20Dokumente/Forms/AllItems.aspx?id=%2FFreigegebene%20Dokumente%2FTalend%2Fsharepoint%2Etxt&parent=%2FFreigegebene%20Dokumente%2FTalend&p=5"

I am supplying correct credentials and the method is set to GET.

Thanks in advance.

Re: tHttpRequest

cterenzi — Mon, 10 Jul 2017 21:51:48 GMT

What sort of response are you getting?

Re: tHttpRequest

Anonymous — Tue, 11 Jul 2017 12:00:25 GMT

Hi thanks for replying, currently the above URL is giving '403 Forbidden'.

I have tried multiple combinations and think the URL is the problem, as I'm new to this, I'm not sure how to specify correctly.

Grateful for advice.

Re: tHttpRequest

cterenzi — Tue, 11 Jul 2017 14:14:23 GMT

That's an authentication issue. How is your component configured to use credentials?

Re: tHttpRequest

Anonymous — Tue, 11 Jul 2017 14:44:38 GMT

Hi again, the component is configured to accept a username and password which I have supplied and ticked the 'Authentication Required' box.

talend.jpg

Re: tHttpRequest

Anonymous — Thu, 13 Jul 2017 14:36:35 GMT

Hi be very grateful for assistance with this issue, I'm stuck 😞

Re: tHttpRequest

cterenzi — Thu, 13 Jul 2017 16:33:32 GMT

I've only done limited http file retrieval with systems that weren't intended to service web requests, so please don't take my advice as "best practice". What's worked for me is to use a tool like Fiddler to watch web traffic while I log in to a site and retrieve what I need, then examine the POST or GET request sent and try to mimic that with a tFileFetch component. This usually means setting my own POST parameters like so:

I have no idea if this will work with a sharepoint server. Another idea, the tFileFetch component has an Advanced Setting "Enable NTLM Credentials" that may help get you connected.

Another other idea, there is a Talend Exchange component named tSharepointFile available for download. I don't know if it works with later versions of Talend, but it may be worth a try if nothing else works.

Re: tHttpRequest

Anonymous — Fri, 14 Jul 2017 06:38:58 GMT

Thanks very much for the info, I will try all options, However I cannot see the component in 'Exchange' could this be due to the version of TOS I am using 6.3?