Query execution is only allowed with IgnoreSafeQueryPropertiesTemplateUrl=true when the user has the UseRemoteAPIs permission

Error Message

I had setup a cloud Hybrid Search environment for one of my customers with SharePoint 2016 and SharePoint Online. It was working fine for past few weeks, until one fine day for almost all the users started getting the error message “Microsoft.SharePoint.Client.ServerException: Query execution is only allowed with IgnoreSafeQueryPropertiesTemplateUrl=true when the user has the UseRemoteAPIs permission” when searched from on-prem environment. Cloud Hybrid and Federated Setup Just to share some background about the environment setup, I had followed the recommended approach for setting up the cloud hybrid environment and all the content was correctly getting indexed in Office 365. The […]

Continue Reading

Integrate Azure Chat Bot with SharePoint

BotWithSP-Featured

In my previous article, I wrote about how can we create an simple Azure chat bot based on one of the default template, Forms Flow, that Azure Bot comes with. That is good to get us started but to make anything useful, we need to extend the bot. In this article I am going to talk about how can we extend the Azure Chat bot with Forms Flow,  we created last time, and Integrate it with SharePoint. This logic can be used to integrate both with SharePoint on-premise (2013 and 2016) and Online. Problem Statement We are going to extend […]

Continue Reading

Azure Application Insights or Google Analytics with SharePoint

GA-vs-AAI

Recently I was encountered with a question about implementing Google Analytics in a SharePoint on-premise environment that triggered a discussion, whether we should choose Google Analytics or look for Azure Application Insights, which is available in Azure stack. Azure was in use already since SharePoint Servers were hosted on Azure VMs and the Application Insight reports look quite impressive. I started to look into more details about what to expect from both of these. Google Analytics Lets take a look at the Google Analytics first. Google analytics is intended for website usage tracking and traffic optimization, has a nice dashboard and is […]

Continue Reading

App Only Policy with Tenant Level Permissions in SharePoint Online

There are various articles explaining what App Only Policies are and how they work with SharePoint Provider Hosted Apps. Two of the good starting points, I found are this msdn blog and this msdn article. The process of setting is App only permission is really simple. All you need to do is change the AppManifest.xml file. <AppPermissionRequests AllowAppOnlyPolicy=”true”> <AppPermissionRequest Scope=”http://sharepoint/content/tenant” Right=”FullControl” /> </AppPermissionRequests> The problem is if you need tenant level permissions for your app, you can’t register the app principal in any of the site collections, like you would do for any other level of permission requirement like Site Collection admin. Steps […]

Continue Reading

Transfer Content Ownership of SharePoint Online Content

Hey Guys, Most of us must have faced a situation in SharePoint world when we had to use Move-SPUser to update SharePoint with users who have moved from one active directory domain to another like if user’s identity has changed from CORPUserID to NewCorpUserID.SP-MoveUser works perfect for most of such scenarios. But there is a related area of content ownership transfer, regd. which not much of the information is available. I am trying to compare these 2, as Move-SPUser command can’t be used in SharePoint online and content ownership transfer can be used even in a scenario when the employee […]

Continue Reading