One Star

How connect Talend Open Studio with a Sharepoint list

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:


.
3 REPLIES
One Star

Re: How connect Talend Open Studio with a Sharepoint list

any suggestion?
Five Stars

Re: How connect Talend Open Studio with a Sharepoint list

any update for this post ?

Moderator

Re: How connect Talend Open Studio with a Sharepoint list

Hello ezo2018,

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

Could you please have a look at it?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.