You can translate the question and the replies:

Struggling to connect to SharePoint List via RSS (Unable to establish connection: Circular redirect to xxx)

Hello, I'm attempting to create a data source to a SharePoint list in Denodo Design Studio for a requirement in my project. However, I am struggling to establish a connection using either method, both OData and RSS. Reading through the requirements for OData, it looks like I'm required to create and register an app in Azure. With my company's domain and my credentials I currently lack the permission to do so in Azure. So, my current assumption is that I must use RSS to create a connection to SharePoint. For my example, I created a dummy test site in our SharePoint domain and have a list I created within that site. In Design Studio, I've created an XML data source, used a data route of HTTP Client, and have plugged in my RSS url for the SharePoint list. I'm not entirely sure what authentication I should be using, I've tried basic with both pass-through checked and unchecked. I am using the same credentials that I used on my company's SharePoint to create the site and list. But, it keeps returning this error to me: Unable to establish connection: Circular redirect to 'https://login.microsoftonline.com:443/18a59a81-eea8-4c30-948a-d8824cdc2580/oauth2/authorize'. I'm not sure what the actual issue is - Am I using an incorrect RSS url, wrong authentication, some security setup incorrectly on my SharePoint site/list? I should also note that our SharePoint domain is not sharepoint.com/sites but - ourcompanyname.com/sites. If that makes a difference... Any help would be greatly appreciated! Screenshot link to error - http://ibb.co/0mRVkDK

1 Answer

Hi, In general the error “*Unable to establish connection: Circular redirect*” occurs when the redirect URL is updated incorrectly while registering the external application in the Sharepoint server. Based on this error “*Unable to establish connection: Circular redirect to ‘https://login.microsoftonline.com:443/18a59a81-eea8-4c30-948a-d8824cdc2580/oauth2/authorize*”, I believe that Sharepoint server uses Oauth authentication but in the data source configuration “Basic authentication” is used and as a result Denodo is not able to communicate with the Sharepoint server. Inorder to troubleshoot this scenario, you could follow the below steps * Ensure that Denodo is registered as an external application in the SharePoint server. * As per the error sharepoint expects Oauth authentication, identify the authentication mechanism used by the Sharepoint and change the authentication mechanism of the datasource accordingly. * If the Sharepoint is configured to use the Oauth mechanism then make sure that the redirect url updated in the Sharepoint points to Denodo Server. For instance you could specify the redirect url as “*https://<host>:<port>/oauth/2.0/redirectURL.jsp*” To register Denodo as an external application in Sharepoint server, you could follow “Step 1 and Step 2” in the Knowledge Base article [How to connect Denodo to Sharepoint Online using OData with OAuth authentication](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication) and “Connecting through RSS” section in [Microsoft SharePoint as data source](https://community.denodo.com/kb/en/view/document/Microsoft%20SharePoint%20as%20data%20source#Connecting%20through%20RSS) to create Sharepoint datasource using RSS mechanism. Hope this helps!
Denodo Team
03-03-2022 07:34:28 -0500
You must sign in to add an answer. If you do not have an account, you can register here