How connect Talend Open Studio with a Sharepoint list

Anonymous — Tue, 22 Sep 2015 16:52:40 GMT

Greetings,
I have a problem to get a SharePoint list from a Job in Talend through REST API. I tried to access the list using: Trest, TrestClient, Thttprequest and the results were "403 bad request"
So far I have no problem with my credential for accessing the list using directly "getbytitle". In consequence, I confirm my credentials are working That Properly.
My question is... if necessary an additional permission to access to SharePoint Online from Talend. With my credentials I access the list without problem on the site name123.sharepoint.com (how I mentioned before), but when trying to access through these components (Trest, Thttprequest, TrestClient) on Talend it shows me a 403 Bad Request or 403 forbidden.
Following are the three connection cases with different components, please if you have something to help in the solution I appreciate greatly.

server: name123.sharepointonline.com (SharePoint Online Office 365)
My User: nombre@name123.com
my list: "('My List ') / items"

CASE 1 . Using tRest:

routine for convert user : password

When the username/password has been encoded successfully, then the tRest Component is invoked using the global variable which was previously generated with java routine

Execution Result:
403 Bad Request.

CASE 2. Using ThttpRequest:

Execution Result:
403 Bad Request.

CASE 3. Using TRestClient:

.

Re: How connect Talend Open Studio with a Sharepoint list

Anonymous — Thu, 24 Sep 2015 12:55:25 GMT

any suggestion?

Re: How connect Talend Open Studio with a Sharepoint list

Anonymous — Sun, 15 Apr 2018 09:36:49 GMT

any update for this post ?

Re: How connect Talend Open Studio with a Sharepoint list

Anonymous — Tue, 17 Apr 2018 10:58:50 GMT

Hello ,

We have replied to your another topic:https://community.talend.com/t5/Design-and-Development/Talend-Integration-with-Online-Sharepoint/m-p/116779#M73857.

Could you please have a look at it?

Best regards

Sabrina

topic Re: How connect Talend Open Studio with a Sharepoint list in Talend Studio

How connect Talend Open Studio with a Sharepoint list

Re: How connect Talend Open Studio with a Sharepoint list

Re: How connect Talend Open Studio with a Sharepoint list

Re: How connect Talend Open Studio with a Sharepoint list