topic Re: tFileFetch to connect on sharepoint Office 365 in Talend Studio

tFileFetch to connect on sharepoint Office 365

Anonymous — Mon, 22 Jul 2019 10:03:05 GMT

Hi all,

I'm trying to get files located into a SharePoint (365) folder.

So i use tFileFetch componant by filling : url (of my SharePoint folder), destination target, unactivate POST method and authentification use and pwd.

But I have this error : "java.net.ConnectException: Connection timed out: connect".

If I use chrome and fill same url + connect with same account, I can access to files located in my SharePoint site

That's why I don't understand what I miss in tFileFetch componant

Do you have any ideas?

Thank you

Re: tFileFetch to connect on sharepoint Office 365

Anonymous — Mon, 22 Jul 2019 15:06:45 GMT

Hi,

The connection to the SharePoint is managed through REST API calls and it will not work like the normal file paths. In the chrome, you are either having a single sign on facility to SharePoint or you are providing the user id and password at the beginning of your session. This detail will go to SharePoint as webservice calls and it will establish the connection for you.

So if you have to connect to SharePoint, you will have to write custom routine code or API calls to make the similar connection and extract the data.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tFileFetch to connect on sharepoint Office 365

Anonymous — Mon, 29 Jul 2019 07:24:33 GMT

ok thank you for your reply

pity we have to go through custom