As I have explained in one of my earlier post that, there are 2 REST APIs to retrieve items from SharePoint: –
- Items – GET request and,
- GetItems – POST request. CAML query in the body.
In this post, I’ll be discussing about the latter.
Read More »
This was the error I got while trying to directly connect to a SQL Server database, from within a SharePoint web part, using the option, Windows Authentication.
Login failed for user ‘NT Authority\IUSR’
The solution is to allow login for IUSR. Here are the steps to do it: –
Read More »
I had a SharePoint hosted app. In this app, I was querying a List’s item using SharePoint REST API.
While I had no issues querying items based on a specific query, surprisingly, for certain columns, I was not getting any values. Following is my code snippet that was trying out initially:
This post is about directly applying aggregations on a SharePoint List, without specifying any grouping condition. If you want to group SharePoint List data before applying aggregation then, refer to this post, SharePoint Group By.
I must admit that this turned out to be little tricky than what I had imagined. The situation was fairly simple. I had a SharePoint List. I had applied couple of Totals functions, Standard Deviation & Variance, on one of its Number field in two separate custom views. I just wanted to retrieve those values from client side. That’s it! My initial assessment was there must be some function/property that I can easily query from the client. As it seemed initially, there’s no direct way of doing that. Fine, just another day at the office for a SharePoint developer 😉
So to access a hidden SharePoint List, navigate to:
The solution was to set the revert to self option of the BCS service to true. To do that, run the following in the Management Shell.
I received this error when I was trying to restore a SharePoint 2013 SiteCollection using the Restore-SPSite command. The backup, a .bak file, was created using the Backup-SPSite command in the management shell. Following is the screenshot of the error message:
After little bit of digging, I figured out that the database backup doesn’t seem to be compatible with my latest web application. The issue in fact, also occurred when I tried to restore the db within the same web application whose one of the SiteCollection was backed in the file!
Read More »