topic Re: How Does One Set Up a SharePoint Connection? in Data & Schema Discussions

How Does One Set Up a SharePoint Connection?

gnwamvannatta — Fri, 10 Jun 2022 19:59:00 GMT

I'm struggling to set up a connection to my SharePoint site. I'm using OAuth with SharePoint Online. I have set up the client_id and secret. The domain field is pretty self-explanatory, but I'm not sure what to input for "Site Name." I've tried all of the reasonable options, but nothing has worked and I can't find anything to explain what that field wants from me.

The documentation is relatively sparse.

https://docs.incorta.com/cloud/references-connectors-microsoft-sharepoint/

Here is the error message:

INC_03070502: Failed to Connect to [REDACTED] due to [Post request to get the bearer token failed] with properties [[authenticationType, oauth], [domain, REDACTED.sharepoint.com], [clientId, REDACTED], [siteName, ????]]

Re: How Does One Set Up a SharePoint Connection?

Jono — Fri, 10 Jun 2022 20:18:52 GMT

I'm having similar trouble with the Sharepoint connector in Incorta. Tech Support is trying to find a solution.

Below is the error I get:

[com.incorta.webapi.AbstractServlet.writeError]
ERROR: [08:57:37] [gcanalytics_dev | 117164 | POST/service/connector/testConnectionBySpec] com.incorta.api.exceptions.DataException: INC_03070502: Failed to Connect to [DCD] due to [null] with properties [[authenticationType, basic], [user, hgo\srvIncorta_p], [loginUrl...('CDP%20Manual%20Court%20Log')/items]]

Re: How Does One Set Up a SharePoint Connection?

JoeM — Fri, 10 Jun 2022 20:32:16 GMT

@gnwamvannatta , @Jono - let me see if I can get the right person to answer this question for you. Thanks for your question!

Re: How Does One Set Up a SharePoint Connection?

vittalkini — Sat, 11 Jun 2022 00:21:28 GMT

@gnwamvannatta - You need to create a Site in Sharepoint or can use an existing site. Under that site you need to create an App and register it. Below link can help you to register an app.

https://piyushksingh.com/2018/12/26/register-app-in-sharepoint/

Use the client id and client secret in Incorta which is used during the app registration. Sitename should be the one where app is registered

Re: How Does One Set Up a SharePoint Connection?

gnwamvannatta — Mon, 13 Jun 2022 21:02:28 GMT

@vittalkini I completed the app creation and registration.

When you say the sitename should be the one where the app is registered, what do you mean by that?

I have tried everything that would seem reasonable to put in that field, but nothing works.

ex.) If "testing.sharepoint.com/sites/thisisthesitename/" was the sharepoint site url, I tried

thisisthesitename
testing.sharepoint.com/sites/thisisthesitename/
testing
testing.sharepoint.com
testing.sharepoint.com/thisisthesitename
testing.sharepoint.com/sites/thisisthesitename

I also tried the app name created in SharePoint to no avail. Do you know what value should exist there?

Re: How Does One Set Up a SharePoint Connection?

dylanwan — Mon, 13 Jun 2022 22:46:13 GMT

Here is the step by step instruction about creating a site in Microsoft Online and connect it from Incorta.

Hope it help.

Re: How Does One Set Up a SharePoint Connection?

gnwamvannatta — Fri, 24 Jun 2022 14:12:53 GMT

I believe this is the solution, thank you @dylanwan.

Unfortunately, it did not work for me. I believe the issue is that our Incorta front-end is on our intranet, which doesn't have a signed SSL cert. Hopefully this works for others, however.