Solved

Sharepoint data source 'Authorize OAuth' not working

  • 23 November 2023
  • 3 replies
  • 75 views

Userlevel 2
Badge +1

When configuring the CData Microsoft Sharepoint (23.0.8669) provider for extracting a Sharepoint List, we encounter a problem with the button ‘Authorize OAuth’. We are configuring the data source in ODX Server 20.10.40 and TX version is also 20.10.40.

The following settings are configured:

According to the CData documentation AzureAD should be used as Auth Scheme to leverage OAuth to authenticate, we also use this exact same setting and the same app registration for another data source using the Excel Online provider for which all is ok.

However, when using ‘Authorize OAuth’ with the Sharepoint provided, we get the following error:

What could be causing this? Changing the file or location for OAuth does not matter at all, we have also tried other versions of the provider but they all give this error. Also, changing Initiate OAuth to ‘REFRESH’ does not have an effect.

icon

Best answer by Christian Hauggaard 24 November 2023, 03:12

View original

3 replies

Userlevel 6
Badge +5

Hi @KajEmergo 

I would recommend using Method 2 in the following guide

 

I also got managed to retrieve SP list data using AzureAD auth scheme with the following data source settings:

 

Userlevel 2
Badge +1

Hi @Christian Hauggaard,

This actually made it work! No clue this setting would influence the OAuth flow, the error doesn't really point towards that either. Any idea what this setting does and why it is nog available on the Excel Online connector for example?

 

 

Userlevel 6
Badge +5

@KajEmergo I have asked Cdata about this. The same settings seem to work for the Excel Online connector on my end

 

Reply