Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
![]()
.
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:
.