wopi_Open_session6

Office Online and WOPI Tom Jebo Sr Escalation Engineer Microsoft Corporation

Agenda• Office Online and Office Web Apps Overview• WOPI Protocol Overview• Example• Resources

Office Online

Office Online• Office files from anywhere• Common Office features• Co-Authoring in real time• Free options

Naming Office Online = Office Web Apps Office Web Apps (OWA) != Outlook Web App (OWA)5

http://www.office.com

Office Online DeliveryConsumer Cloud Public Cloud Private Cloud

Updates for 2015/2016 Publish to Power BI Power Query Archiving & De-clutteringEnhancements

Working with others

Office Online

Office Online Interoperability13

How Office Online WorksHost Frame App Frame Web Application Open Platform Interface

[MS-WOPI] Web Application Open Platform Interface Protocol • Describes the communication between the Office Web App Server (WOPI Client) and a WOPI Server (SharePoint, OneDrive, etc.) • Defines a set of operations that enables a client to access and change files stored on a server • REST-based protocol (HTTP or HTTPS transport) • Open Specification available on MSDN • Client: renders files and provides editing functionality for files stored on the server • Server: hosts files and provides host page for navigating to client editing and viewing UI

Example flow: Viewing a fileBrowser or App Document Host Office Online Serverhttps://msdn.microsoft.com/en-us/library/hh641756(v=office.12).aspx

WOPI Interoperability• “Open from URL” – How do you store your Office documents?• Develop your own WOPI host Microsoft Document HostsWeb Browser (or App) Office Online Server 3rd Party Document Hosts

op/generate.aspx

Word web app test

WOPI Host BasicsStep 1: Implement WOPI using [MS-WOPI] (http://wopi.readthedocs.org can help)Step 2: Discovery http://<officeonlineserver>/hosting/discoveryStep 3: Build a host page Using action URLs from step 2

REST Endpoints for WOPI server• http://server/<...>/wopi*/files/<id> - information • CheckFileInfo • PutRelativeFile • Lock/Unlock • ExecuteCellStorageRequest/ExecuteCellStorageRelativeRequest • DeleteFile, etc…• http://server/<...>/wopi*/files/<id>/contents - contents • GetFile and PutFileThese are the only two that most WOPI hosts/servers will need toimplement.

<action name=\"view\" ext=\"docx\" default=\"true\" urlsrc=\"http://jeebs5vm1/wv/wordviewerframe.as px?<ui=UI_LLCC&><rs=DC_LLCC&><showpagestats=PE RFSTATS&>\"/> [MS-WOPI] 4.1 Accessing Discovery XML1.Parse and replace Placeholder values with appropriate values (or discard them)2.Append a WOPISrc value to the URI as a query string parameter i.e.: http://server/<...>/wopi/files/(file_id)

The WOPI flow SharePointHost Frame WOPI Source App Frame Office Online Server  WOPI Source  Access Token

Coauthoring and Multiple EditingOffice Online Server 2016: Lock/Unlock CheckFileInfo permits editing PutFile (frequency)Previous versions of Office Web Apps Server: CheckFileInfo: SupportsCobalt Implement [MS-FSSHTTP*] in WOPI host http://wopi.readthedocs.org/en/latest/scenarios/coauth.html#coauth

Implementation SampleWhere to start if you’re lost?https://github.com/Microsoft/Office-Online-Test-Tools-and-Documentation/tree/master/samplesC# based web handler using IHttpHandler interfaceSample host page with app frameSimple accesstoken implementation, no real authenticationSimple file system exampleGreat start to understanding a WOPI host’s role

Message Analyzer Screenshots and Demo <<screen shot of MA with WOPI parsed traffic showing OOXML get file contents>>

Message Analyzer • Message Analyzer is a great tool to help facilitate your protocol development • New parsers for WOPI and FSSHTTP • Office Online leverages the existing OOXML file format and renders into a browser-friendly design29

SummaryOffice Online:• Provides the ability to work and share Office files from anywhere with an internet connection, from almost any device.• Is an open technology• Provides easy interoperability• Integrate your own document library or file server with Office Online

Availability & Resources• Office Web App Server (and Office Online) are free • Download Center: http://www.microsoft.com/en- us/download/details.aspx?id=35489 • Viewing is always free • Editing may have associated cost• [MS-WOPI] is available on MSDN • MSDN Library: http://msdn.microsoft.com/en- us/library/hh622722(v=office.12).aspx • Regular updates• Office Online integration • http://wopi.readthedocs.org/en/latest/• Support: [email protected]

Questions?Thank You