How to open documents with Office365 in my web application?

Question

We have a cloud audit application. When performing an audit, the user usually downloads a lot of documents. Currently, to view documents, he must download them. The business requirement is that when you click on a document, it should open directly on another browser tab using Office 365, like dropbox / onedrive. The user should be able to view, edit, save it on the server (without downloading) and close it. How to achieve this in our application?

Our webapp is built using ReactJS, NodeJS and MongoDB. Whenever a user loads a document, it is saved in the AWS S3 bucket.

I went through the Microsoft Graphics APIs and OneDrive RestAPI. It seems like the only solution is to use the OneDrive API to save files to OneDrive instead of S3. And then this should allow you to use Office365 applications. This is the right decision? Did I miss something?

Is there any other solution?

Answer 1

While the easiest solution is to actually store documents on OneDrive, there is another way. You can sign up for the Microsoft Cloud Storage Partners program and implement the WOPI protocol in your service. This allows Office Online users / editors to integrate directly with your service data.

Answer 2

To achieve a working solution, you need to use aws and O365 api. Try the following steps (PS: I have not tried this, but I saved the edited documents from Office 365 to AWS)

• Read the downloaded document from AWS using the AWS api and upload it to the office doc using the office doc api.
• Edit the document using office documents api.
• Save document back to S3