PowerPivot Application Pool Crashes on Data Refresh

Posted on Leave a commentPosted in Article, SharePoint 2013

When troubleshooting SharePoint, you often have to dig several levels deep to discover the root of an issue. Recently one of my clients was running into an issue where the IIS application pool that was associated with their PowerPivot service application was crashing regularly at a specific time (within a minute or two) every day. Before looking into it we immediately suspected something was up with a scheduled data refresh, just given the timing of […]

Unencoded Cookie Value Breaks SharePoint Modern Pages

Posted on Leave a commentPosted in SharePoint Online

Today I discovered an interesting issue with the new SharePoint Modern Library views on Office 365. One of my clients for whom I had built an application that loads some content within an iframe element on the site was suddenly no longer able to get the Modern Library pages to render correctly – they would simply show up as a blank page. At first, we thought maybe something with our code was failing and causing […]

Working with Folders and Files using the SharePoint REST Service and Windows PowerShell

Posted on Leave a commentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In the previous article, Working with Lists and List Items Using the SharePoint REST Service and Windows PowerShell, I showed the PowerShell equivalents to the examples in the Working with lists and list items with REST MSDN article. In this article I want to look at the examples in the next MSDN article in that series, […]

Working with Lists and List Items using the SharePoint REST Service and Windows PowerShell

Posted on Leave a commentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In the previous article, Using a Custom Windows PowerShell Function to Make SharePoint REST Service Calls, I detailed a custom utility function, Invoke-SPORestMethod, that can be used to make RESTful calls against a SharePoint REST Service endpoint. In this article I want to cover some common examples that illustrate how you can use the function to […]

Using a Custom Windows PowerShell Function to Make SharePoint REST Service Calls

Posted on 2 CommentsPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In the article, Using the SharePoint REST Service with Windows PowerShell, I detailed how to use Windows PowerShell to make simple RESTful calls against your SharePoint Online Site Collection. In this article I want to build upon the example that I showed by abstracting out all of the various settings into a common utility function that […]

Using the SharePoint REST Service with Windows PowerShell

Posted on Leave a commentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In a previous article, Connecting to SharePoint Online using the SharePoint CSOM API with Windows PowerShell and the related CSOM articles that followed it, I discussed how you can use Windows PowerShell to inspect and manage SharePoint Online Site Collections, Sites, Lists and List Items using the managed .NET objects provided as part of the SharePoint […]

Completing Basic Operations using the SharePoint CSOM API and Windows PowerShell

Posted on Leave a commentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. As you start working with and exploring the CSOM API with Windows PowerShell, you’re likely to be doing some searches looking for examples of how to use it. One of the more popular examples you’ll likely stumble upon is an MSDN article, How to: Complete basic operations using SharePoint 2013 client library code. In this article […]

Loading Specific Values Using Lambda Expressions and the SharePoint CSOM API with Windows PowerShell

Posted on Leave a commentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In the article, Using the SharePoint CSOM API with SharePoint Online and Windows PowerShell, I explained that when you call the ClientContext object’s Load method that only a subset of properties are typically loaded, usually most of the simple types, and that you’ll need to make another call to the Load method to get additional properties. […]

Using the SharePoint CSOM API with SharePoint Online and Windows PowerShell

Posted on 1 CommentPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. In the Connecting to SharePoint Online using the SharePoint CSOM API with Windows PowerShell article you learned how to get started using the SharePoint CSOM API to connect to your SharePoint Online Site Collection with Windows PowerShell. That article introduced a utility function named Connect-SPOSite. In this article you’ll learn how to actually work with the […]

Connecting to SharePoint Online using the SharePoint CSOM API with Windows PowerShell

Posted on 2 CommentsPosted in Article, ITUnity, PowerShell Scripting, SharePoint Online

Update 10/25/2017: This article originally appeared on ITUnity.com but as that site has been decommissioned I’ve republished it here. As a developer working with earlier versions of SharePoint, specifically SharePoint 2007 and earlier, your options for working with SharePoint from off-server client applications was pretty limited. You had some SOAP-based web services that you could call, which are still available today, but you were somewhat limited with what you could do with those services, and […]