topic Sharepoint Online Integration in Talend Studio

Sharepoint Online Integration

Anonymous — Wed, 04 Feb 2015 10:08:50 GMT

I am wondering if anyone succeeded in integrating with Sharepoint Online using Talend.
We have explored several possibilities without success.
As fas as I understand the soap services are no longer supported and do not work for sharepoint online ( I saw different posts on this forum refering to the soap service integration with sharepoint, but i belive this is an on premise installation.)
That leaves the REST API's, but we get authorisation error (403) when we try to connect to sharepoint online using the tRest - components.
Did anyone manage to execute a REST API for sharepoint online using Talend? If yes, could you share some pointers on how to configure the REST components or sharepoint user settings.
Thanks.
Frank

Re: Sharepoint Online Integration

Anonymous — Thu, 05 Feb 2015 09:32:16 GMT

Hi,
Have you already tried to use tSoap component to make webservice call with sharepoint?
Best regards
Sabrina

Re: Sharepoint Online Integration

Anonymous — Thu, 05 Feb 2015 14:01:09 GMT

Yes we have, but without success.
We get an error as well, see screenprints. Also probably related to authentication.
It seems Sharepoint online uses claim based authentication, so you need to retrieve a fedAuth cookie and pass this to the service call.
That is why I am wondering if anyone managed to connect to sharepoint online.

Re: Sharepoint Online Integration

Anonymous — Sat, 14 Apr 2018 19:35:29 GMT

Any help please on this topic ?

Re: Sharepoint Online Integration

EngieNL — Thu, 05 Dec 2019 09:38:29 GMT

Does anybody have progress on connecting Talend and Sharepoint Online?