The Azure function and the code is not part of this story, this covers how to access the files stored in Office 365 with Microsoft Graph.įirst, I had to solve, how to access data stored in a SPO site and how to use that file with the Excel REST API. In my scenario I wanted to write data from another cloud service through an Azure function into an existing Excel file stored in a SharePoint site. There are endless use cases and reasons to use data with Excel. So, in many use cases, having data stored in an Excel file often is a very pragmatic and a very quick way to access data easily. Microsoft Excel is very useful for data in tables, charts and extensive calculations, but can work as small and simple data source (for example in PowerApps) as well. Since all samples I found just use the personal OneDrive for Business (OFB) file storage, I wanted to document how to access files that are stored in a SharePoint Online site (SPO) as well. Additionally, you can directly work with Excel files through the Graph Excel API. Amongst many other features, you can work with OneDrive and SharePoint files with the Graph REST API. The Microsoft Graph API is the new unified endpoint for developers accessing data from an Office 365 tenant.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |