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…


Understanding Business Connectivity Services

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…


What Is Included in Business Connectivity Services?

Microsoft Business Connectivity Services (BCS) is included in Microsoft SharePoint Foundation 2010, Microsoft SharePoint Server 2010, and Microsoft Office 2010 applications. However, the feature set and the capabilities differ in each application. The diagram below shows the differences in the feature sets of Business Connectivity Services, SharePoint Server 2010, and Office 2010. For more information…


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…