Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

October 2015

What’s in that patch? SharePoint 2013 – Sep 2015 CU

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at http://sharepointupdates.com/

If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb

 

Whats in that patch – SharePoint 2013 – Sep 2015 CU.PDF

Connect to WebAPI from Excel

Recently I coded a WebAPI endpoint to support a JavaScript application.   A power user asked “How can I view this data with Excel”?    Given how the default format is JSON we didn’t see an immediate option.

However, with a little homework we found a way to set XML before JSON and give a default XML format that is compatible with Excel data connections.

Check out the below 5 minute video and code snippet to see how.

Cheers!  

shades_smile

 

Code

//default XML 
config.Formatters.Clear();
config.Formatters.Add(new System.Net.Http.Formatting.XmlMediaTypeFormatter());
config.Formatters.Add(new System.Net.Http.Formatting.JsonMediaTypeFormatter());

 

Video

WebAPI data connection to Excel from Jeff Jones on Vimeo

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲