Transcript Agenda What is Mobile Services? Structured Storage Powered by SQL Database Same DB – Multiple Mobile Services Data management in Windows Azure Portal SQL Portal,

Agenda
What is Mobile Services?
Structured Storage
Powered by SQL Database
Same DB – Multiple Mobile Services
Data management in
Windows Azure Portal
SQL Portal, SQL Management Studio
REST API
CLI Tools
The REST API
https://Mobileservice.azure-mobile.net/tables/*
Action
HTTP Verb
URL Suffix
Create
POST
/TodoItem
Read
GET
/TodoItem?$filter=id%3D42
Update
PATCH
/TodoItem/id
Delete
DELETE
/TodoItem/id
JSON to SQL Type Mappings
JSON Value
T-SQL Type
Numeric values (integer,
decimal, floating point)
Boolean
DateTime
String
Float(53)
Bit
DateTimeOffset(3)
Nvarchar(max)
Server Side Scripts
Customizing logic on the server
Node Modules
Extensibility through numerous included modules
Auth*
Push Notification Lifecycle Overview
Push Notifications
Custom API
Non-table based scripts
Accessible from
Get
Post
Put
Patch
Delete
Same permissions as tables
Using the Scheduler
Execute scripts on a schedule
Execute scripts on demand
Frequency and length of execution based off of
service level
Ideal for backend data processing
Diagnostics, Logging, Scale
Service Scale
Free
500K API calls per subscription per month
Standard
1.5M API calls per unit per month
Premium
15M API calls per unit per month
Mobile Services Tiers
Usage
Restrictions
API Calls
Scale
Scheduled
Jobs
SQL Database
(required)
Free
Standard
Premium
Up to 10 services,
Up to 500 Active Devices*
N/A
N/A
500K
(per subscription)
1.5M
(per unit)
15M
(per unit)
N/A
Up to 6
Standard units
Up to 10
Enterprise units
Limited
Included
Included
20MB Included,
Standard rates apply
for more capacity
20MB Included,
Standard rates apply
for more capacity
20MB Included,
Standard rates apply
for more capacity
General Availability
99.9%
Windows Azure Mobile Services
Resources
Get a Windows Azure Free Trial Account
http://www.windowsazure.com
Videos, Tutorials, and More
http://www.windowsazure.com/mobile
Source code on GitHub
https://github.com/WindowsAzure/azure-mobile-services
Contact Details
[email protected]
Feature Requests
http://channel9.msdn.com/Events/TechEd/Australia/2013
http://www.microsoftvirtualacademy.com/
http://technet.microsoft.com/en-au/
http://msdn.microsoft.com/en-au/
•
Sign up for a Free Azure Trial:
http://www.windowsazure.com/en-us/pricing/free-trial/
•
Activate your Azure MSDN Benefits:
http://msdn.microsoft.com/dn369243
API Authorization
Everyone
App Key
Admin
403 on
deny
S
E
C
U
R
I
T
Y
APP Key?
R
E
S
T
Master
Key?
A
P
I
S
C
R
I
P
T
S
Authenticated Users
APP
S
E
C
U
R
I
T
Y
Valid
User ID
+
Token
R
E
S
T
A
P
I
S
C
R
I
P
T
S
OAuth Authentication Flow