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: firstname.lastname@example.org 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