Sharepoint on prem

Hello,
How do we connect to SharePoint on Prem. saw that we have to install data gateway.
How do we handle that and how do we connect it with SharePoint.

@kishore_praveen

Create an azure app and you can connect using microsoft office 365 activities from same environment

Cheers

Hello @Anil_G
We tried the same but we are getting error.
Interactive token - Invalid hostname tenancy
Application Id and secret - scp or role claim error
We tried with online sharepoint site and we are getting the output from the online sharepoint.
But with onprem no result.

@kishore_praveen

Scp role claim error would come if the admin consent is not provided I guess or if delegated permissions are given and client secret is used

cheers

Hello @Anil_G

Yes, but admin consent has been provided. Even we are not able to integrate. The request has been sent for admin consent and he has approved. But it’s throwing an error as forbidden. please close the browser and try again.
Any other suggestions to overcome this.
Sharepoint team is saying gateway might help, but they didn’t about the process.

@kishore_praveen

Did you happen to remove all deegated permissions and only have application while using client secret?

Cheers

@Anil_G

Haven’t tried that, Will the business allow that, because it’s saying without a signed user. Would that be any concern to them.

@kishore_praveen

If delegated is present then client secret way wuld not work…it needs application scope

Even using application scope there can be restrictions applied

For few more options

Or

The other way would be instead of that use integrated windows…which require delegated itself…can remove application permissions instead

Cheerd