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!!!
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Σχόλια 0
Συνδεθείτε για να κοινοποιήσετε σχόλιο