Using OData Data Sources in SharePoint 2013 ... - Hunter Pankey

fortnecessityusefulSoftware and s/w Development

Dec 14, 2013 (3 years and 8 months ago)

119 views

Using OData Data Sources in
SharePoint 2013 Solutions

Hunter Pankey

@
thehunterpankey

http://hunterpankey.com

What is OData?


Protocol for interacting with
RESTful

services


Microsoft Open Specifications
Promise


Operates over HTTP


Returns ATOM or JSON

What are
RESTful

services?


Focuses on resources


Relatively simple to use


Four principles


Use HTTP
methods appropriately


Be
stateless


Expose
data in a directory structure


Transfer either XML or JSON

SOAP vs. REST

SOAP

REST

Data Formatting: XML

Data Formatting:

XML or
JSON

Transports: Pretty

much
anything

Transports: HTTP

Supports

stateful

operations

Completely Stateless

Allows

for caching results

REST URL Examples


http://odata.netflix.com/Catalog/Titles and


http
://odata.netflix.com/Catalog/Titles?$filter=
Name%20eq%20'Bad%20News%20Bears'





OData Principles


Metadata


Data


Querying


Editing


Operations


Vocabularies

Data Model


Entities


Entity sets


Relationships

Data Model


Complex types


Entity key


Properties


Declared properties


Open entity types/dynamic
properties


Operations/Functions/Actions

Data model


Structural elements


Row types


Resources


Annotations/Vocabularies


Service Model


Metadata document


Service document


OData Providers


SharePoint itself


Azure, Azure Marketplace


SQL Reporting Services


Dynamics CRM


Many public feeds


Netflix


eBay


Twitpic


Windows Live

OData Players

BCS Overview


Similarities to ORMs


External Content Types


Connectors


SharePoint Interface

BCS Overview


Metadata store


Secure Store Services


External Lists


New for SharePoint 2013


Performance


Model
g
eneration


SharePoint 2013 apps

BCS Stereotypes

Stereotype

HTTP Verb

Example

Finder

Get

http://odata.netflix.com/Catalog/Titles

Specific Finder

Get

http://odata.netflix.com/Catalog/Titles?$filt
er=Name%20eq%20'Bad%20News%20Bears
'

Creator

Post

http://odata.netflix.com/Catalog/Titles

Updater

Put

http://odata.netflix.com/Catalog/Titles?$filt
er=Name%20eq%20'Bad%20News%20Bears
'

Deleter

Delete

http://odata.netflix.com/Catalog/Titles?$filt
er=Name%20eq%20'Bad%20News%20Bears
'


Association Navigator

Get

http://odata.netflix.com/Catalog/Genres('Ho
rror')/Titles

External Lists


Overview


Data source


Improvements in SharePoint 2013


Export/offline access

Remote Event Receivers


New in SharePoint 2013


Added BDC stereotypes


New Functionality

Demo Time!!!