Transcript Building Cloud-hosted apps for SharePoint with PHP and node.JS

• All components
• Wrapper deployed to
deployed to SharePoint
SharePoint
• Client side code
• Components deployed
• App Web created for
to Azure (automatically)
app
• Server and client side
code
PHP /
Node
• Wrapper deployed to
SharePoint
• Components deployed
to host (manually)
• Server and client side
code
PHP /
Node
Any host
What technologies can you use?
Data
• SQL, mySQL, Oracle, CSV, Access, FoxPro, DB2,
SQLite
Server code
• C#, VB.NET, PHP, CGI, Java, Perl, Ruby, Node.js
User interface code
• HTML4/5, JavaScript, jQuery, Silverlight, Flash,
AJAX
Anything!
Data Sources
Services
• Databases
• Services
• Queues
• Subscriptions
• Notifications
• Notifications
• Subscriptions
• Email
• Workflow
Jobs
• Long running
• Automated
Web Pages
• jQuery
• jQuery Plug-ins
• CSS
App
permission
name
SharePoint
permission name
Read
Reader
Write
Contributor
Manage
Designer
FullControl
Full Control
All or
nothing
Scope
BCS
List *
Search
Site Collection *
Taxonomy
Web *
Workflow
Pertains To
Read access to BCS data sources
A SharePoint list
The SharePoint Search Service
A SharePoint Site Collection
The SharePoint Taxonomy Service
A SharePoint Web Site
The Windows Azure Workflow Service
https://mySPSite.sharepo
1
https://mySPSite.sharepo
2
1
https://mySPSite.sharepo
2
1
3
https://mySPSite.sharepo
Developer Site
2
1
4
POST https://hosting server/
…
SPAppToken=tbAgAiOiJKV1
QiLCJhbGciOiJIUzI1NiJ9.e…
3
https://mySPSite.sharepo
Developer Site
2
1
4
5
3
https://mySPSite.sharepo
Developer Site
6
2
1
4
5
3
https://mySPSite.sharepo
Developer Site
7
6
2
1
4
5
3
https://mySPSite.sharepo
Developer Site
7
6
2
3
1
4
5
8
https://mySPSite.sharepo
Developer Site
7
6
2
3
1
4
5
8
9
https://mySPSite.sharepo
Developer Site
7
6
2
3
1
4
8
9
5
10
Print Report
Email Report
Refresh
JWT
Get the token from ACS
Invoke SharePoint REST queries and operations
http://www.windowsazure.com/en-us/develop/nodejs/
<IFRAME
src=“http://domainB.com/page.php”>
Provider hosted ECM app
REST queries to a SharePoint
Document Library
</IFRAME>
•
SharePoint Document Libraries
SharePoint Server
http://domainA.com
•
•
•
•
List Documents In A Document
Library
Upload Documents
Check Out Documents
Edit Document Metadata
Check In Documents
Provider-hosted ECM app
http://domainB.com/page.php
North
Finance
Home
South
Departments
Part A
East
Autohosted / Provider-hosted
app
Parts Inventory List
List Item Event Receiver
West
Part B
Part C
Part D
Cloud hosted app
Windows
Azure Web
Site
(node.js)
Windows Azure
SQL Database
<IFRAME>
Autohosted BI app
</IFRAME>
6
Windows
Azure Web
Site
7
Azure Service
3 Topics /
Bus
Subscriptions
2
8
4
3
1
Parts Inventory List
Remote Event Receiver
Windows Azure
SQL Database
5
Windows
Azure
Worker Role
SharePoint Server
http://domainA.com/sites/<1..N>
Cloud hosted BI app
http://domainB.com/page.php