Feature Requests and Feedback
-
Get all members of a group including nested group members
Currently in Microsoft Graph, the groups/{id}/members ONLY returns the DIRECT members of the specified group. This is a request for an API that would return all members including nested group members (also known as transitive down closure).
47 votesThis has been shipped into the beta endpoint (https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/group_list_transitivemembers) ^JT
-
Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64
We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.
With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.
144 votesHello! the API is in preview now! Make sure to have the latest insiders fast and use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec
Here is a sample code snippet using the API
https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a
key line of code context.workbook.worksheets.addFromBase64(mybase64)
send an xlsx (base64 encoded)
please use it and send us feedback!
-
Expose the entire email MIME stream (whole mail ContentBytes) in Outlook Mail REST API
Sending REST request to Outlook Mail endpoint for messages brings back email message object with properties such as: Subject, From, To, Body but it doesn't expose the MIME stream for the whole email. Actually this is required to save the entire email maybe as eml file locally or somewhere.
EWS exposes this option but unfortunately is hard limited to 1MB response (for JavaScript APIs).hope this option will be available soon within the REST response
Thank you,
392 votesThis feature is currently being tested in private beta. Please reach out to outlookapibeta@microsoft.com if you are interested in reviewing and providing feedback!
-
Make O365 user identity available in Word Add In
Authenticated O365 users shall not be prompted to login again when they want to use Word Add-In. At the moment any Word Add In secured using O365 directory need to prompt users to enter their credential again despite that they have logged in to O365.
The goal is to provide a better user experience with this single sign on.76 votesWe’re happy to announce that single sign-on is now in preview. You can find more information here:
https://docs.microsoft.com/en-us/office/dev/add-ins/develop/sso-in-office-add-insThanks!
Office Extensibility Team -
Page Setup API
I would like to be able to access the page layout properties of the document so that I can set the print area.
13 votespagelayout object is in preview! pelase try it and send us feedback.
Check out https://aka.ms/excelapiopenspec
https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/pagelayout.md
-
Special Cells method
In Excel API, I can't choose cells based if they have formulas or values.
In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.
Please, support this for Excel JavaScript API, because currently, I'm looping all the worksheet's used range rectangle to get the values, and my loops spend a lot of time skipping blank cells.
33 votes -
Retrieve SharePoint Social.Following Microsoft Graph
It would be great to get SharePoint people and content following information through Microsoft Graph.
49 votesAt Ignite 2018, we announced in beta the following documents api In Preview (https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/drive_list_following). We are currently working on following sites api too. ^JT
-
9 votes
This In Preview now as mentioned in the change log. https://developer.microsoft.com/en-us/graph/docs/concepts/changelog#november-2018 ^JT
-
Add a webhook resource subscription for Groups to notify of membership changes
When a member is added or removed from a group, or when membership is requested, make a call to a webhook that can receive the userid, and the action: add, remove, 'request to join', etc.
We have a lot of processes that hinge upon membership in a group. Instead of constantly polling the group and doing membership comparisons, this would make changes more real-time.
12 votesThis is actually available in the /beta end point. We are looking to provide more detail on when this will be published in /v1.0. This is documented here https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/resources/webhooks ^JT
-
Return Deep Links to Teams Channels
The beta Graph Groups API returns a list of Teams Channels created for that group. Please add a field with a deep link to open that channel directly in the Teams client.
1 voteThe webUrl property is now in the service in beta for channel resource object. Please provide any feedback as you use this here.
-
API to create Teams for Classes
Add API calls to let developers create Teams for Classes. Also add API calls to allow developers to connect to the "Assignment" tabs - to be able to export averaged grades... etc.
Also - please clarify what is deprecated and what is relevant in the documentation. It is very difficult to figure out what is still being supported and what is not. (I.e. Microsoft Classroom vs Microsoft Teams for Education).
I found Office 365 REST API for Schools/Teachers... but I am not finding anything that can access the new framework in teams.
Please help!
6 votesThe create a team through a template is now available in /beta here https://docs.microsoft.com/en-us/graph/api/team-post?view=graph-rest-beta
Details on how to use this are documented here https://docs.microsoft.com/en-us/MicrosoftTeams/get-started-with-teams-templates
-
Microsoft Graph API user fax number
add facsimileTelephoneNumber parameter to user object to have an ability to read the fax number of the user.
It works already by Azure Graph, but not by Microsoft graph
81 votesIn November, this was shipped in /beta as documented on the changelog https://developer.microsoft.com/en-us/graph/docs/concepts/changelog#october-2018 ^JT
-
Add Abitility to create pivot Table via Office Javascript API
In the current version of the office javascript api I can see that the setSelectedDataAsync method allow only inserting text, matrix and table into excel spreadsheet.
I would like to see the javascript api enhanced and allow inserting pivot Table also. In this way I can use pivot Table helpers (such as slicer, fields list ....) and also refresh pivot table programmatically.
87 votesHappy to report that some of the functionalities are already in the product (all the basics for creating Pivots!) and some in preview (i.e. advanced filtering, calculated fields) .
please see the details here.https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-pivottables
-
Add User Defined function support to the Apps for Office Excel APIs
Add User Defined function support to the Apps for Office Excel APIs so that users can enter formulas in excel. User Defined Functions are one of the most powerful features of Excel (and some competitor spreadsheets products now available in the web). They are critical for us to make our Apps for Office product as powerful as our legacy on premise product.
328 votesCustom functions are officially in Preview! Try them! more info in https://aka.ms/customfunctions
-
Expose Office API via Swagger.
OK this is a radical idea from listening to @mkristensen talk about VS.NET tooling and how they are looking at supporting Swagger 2.0 to provide code generation for RESTful APIs in VSNET.
http://devchat.tv/adventures-in-angular/019-aia-microsoft-tooling-with-mads-kristensen
I looked up Swagger and their online documentation editor, and browser and here's an example
http://petstore.swagger.wordnik.com/#!/pet/updatePet
Which is surprisingly similar to Office 365's
http://msdn.microsoft.com/en-us/library/office/dn600182(v=office.15).aspx
I think Office 365 documentation on MSDN should still be the primary resource. Any future tie in to API-Sandbox would be awesome.
But if VSNET starts to support auto-codegen (like the old days with WSDL/Soap Services) from Swagger documentation, then I can also…
46 votesWe currently have our open API (Swagger) descriptions available on https://github.com/microsoftgraph/microsoft-graph-openapi
We are working on having these available live on graph.microsoft.com API itself like $metadata. ^JT -
Create REST methods for bulk object retrieval
For reporting purposes we would like to have REST methods to retrieve metadata about objects in bulk. Right now we have to retrieve the list of objects first, then get metadata about each of them. This is definitely a very inefficient way to build reports. Essentially, would like a REST method that allows to query for the following objects AND specify fields we want to see in the query results, such as created and last modified dates, author, number of items (in a list), size, permissions, etc. We believe that having such REST methods for Sites, Lists and libraries, and…
17 votesFor creating dashboards, we have a new product feature called Microsoft Graph data connect. This currently is In Preview and supports entities such as mail, calendar, contacts, users. In future it will support other entities available on the graph. You can read more about data connect here https://developer.microsoft.com/en-us/graph/blogs/microsoft-graph-ignite-2018/ ^JT
- Don't see your idea?