Excel Services REST Interface

The figure below is a syntax diagram detailing how to construct URIs for the Excel Services REST API. For more information on using the Excel Service REST interface, take a look at the SharePoint 2010 SDK topics located here. And developer Shahar Prish details even more tips and tricks on working with the service on…


SharePoint 2010 REST Service Syntax Diagram

The figure below is a syntax diagram of the structure of SharePoint Foundation REST service URIs. You can read more about the SharePoint Foundation REST service here. Syntax diagrams are a useful way of illustrating linear data structures. Things like: REST URI composition API signatures JSON, OData, or other XML-based data notation You can find…


Sandboxed Solutions Object Model Hierarchy

Today’s diagram is probably best considered a work in progress. We created the following diagram as a prototype, to see if we could use large-scale static graphics as aids for developers to visualize the SharePoint object model hierarchy and the relationships between classes within it. As an experiment, we took the subset of classes available…


Server Ribbon Architecture in SharePoint 2010

Ribbon customizations, deployed as custom actions, in SharePoint 2010 can be categorized in two ways: filtered and unfiltered. A filtered custom action is one that uses the RegistrationId and RegistrationType attributes, for example to target a specific list. An unfiltered custom action is one that does not use these attributes. Ribbon custom actions are handled…


Excel Services Architecture In SharePoint Server 2010

Excel Services is part of Microsoft SharePoint Server 2010. Excel Services is built on ASP.NET and SharePoint Foundation technologies. Following are the core components in Excel Services: · Excel Web Access · Excel Web Services · User-defined functions (UDFs) · ECMAScript (JavaScript, JScript) · Representational State Transfer (REST) service · Excel Calculation Services The Excel…


SharePoint Business Connectivity Services Dataflow Model

Microsoft Business Connectivity Services (BCS) enables users to read and write data from external systems—through Web services, databases, and Microsoft .NET Framework assemblies—from within Microsoft SharePoint 2010 and Microsoft Office 2010 applications. Both SharePoint 2010 and Office 2010 applications have product features that can use external data directly, both online and offline. Developers can gain…


Client Object Model Request Batching in SharePoint 2010

The request batching process helps to improve performance and reduce network traffic in two ways. First, fewer Web service calls occur between the client and the SharePoint server, which reduces the "chattiness" of the client-server interface. For example, you can perform two list queries in a single request. Second, as a set of operations occur…


Business Connectivity Services High-Level Architecture in SharePoint

Business Connectivity Services (BCS) for SharePoint 2010 builds on the technology of the Business Data Catalog first introduced in SharePoint 2007. It provides the ability to connect SharePoint to external data sources of all kinds, including but not limited to, other database systems, Customer Relationship Management (CRM) systems, ERP systems. BCS provides a developer with…


Web Part Development Options in SharePoint 2010

This diagram demonstrates the project templates and project item templates that you can use when developing Web Parts in Visual Studio. While these templates have the same end result (a cool Web Part running SharePoint), the development experience can vary between working with code or using a designer to build the UI. For more information,…


Solution Packages and the SharePoint Tools Continuum

One major advantage of the SharePoint 2010 development platform is that it provides the ability to save sites as solution packages. A solution package is a deployable, reusable package stored in a .cab file with a .wsp extension. You can create a solution package in the browser, SharePoint Designer 2010, and Microsoft Visual Studio 2010….