Sharepoint Connector - GetClient returned Unauthorized error

I am new to Sharepoint integration and I am following these step to retrieve the list from Sharepoint:

https://www.codeproject.com/Articles/1257486/Integrating-SharePoint-with-OutSystems


However, when I consume the service, I am getting following error:


Question 1: Is there any additional setting/configuration required at sharepoint site to have this work?


Question 2: I need to create a schedule job/process in Outsystem to pull one of the Sharepoint list's item every x hour. Others than using the method documented inside the link shared, is there any other method can be use?




Thank you!

Hi,

1. GetClient is used to get the TenantId and ClientResporseId for SharePoint, please read the section "Retrieve the Tenant ID" carefully, below is what is mentioned and check the forge component for how the response is used.

The test value is ‘bearer’, and that’s what is passed by the calling Server Action. This does not authorize the request, but simply returns the Bearer realm and client_id as part of the WWW-Authenticate header

2. Check the documentation https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest, you need to create new API to access list.

Regards.

Prasad Rao wrote:

Hi,

1. GetClient is used to get the TenantId and ClientResporseId for SharePoint, please read the section "Retrieve the Tenant ID" carefully, below is what is mentioned and check the forge component for how the response is used.

The test value is ‘bearer’, and that’s what is passed by the calling Server Action. This does not authorize the request, but simply returns the Bearer realm and client_id as part of the WWW-Authenticate header

2. Check the documentation https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest, you need to create new API to access list.

Regards.

Thank you!

I am finally able to get the access token - and further call the sharepoint to retrieve the list.

However, when i try to retrieve the items inside the list, I am consistently getting empty data. Here's the sample test data via Postman:


Data

Is there any additional permission/setting required in order to access the list item?