Forum Discussion

Vaibhav Ukandrao Gadre's avatar
Vaibhav Ukandrao Gadre
Copper Contributor
Feb 22, 2019

office rest API to find office online license details for user

Hello,

 

We are building an app which has Microsoft office login through oauth 2.0 where user can login and if user valid office online user we will authorize user to access our app.

In this scenario, once user is logged in and we will receive access token and consent from him to access his office resources details.

What I want to know is there any rest API which I can call to verify that user is having valid office online license and can use office online products such as Microsoft online Excel etc.

 

 

Thanks,

Vaibhav

 

developer
microsoft 365 apps
office 365

3 Replies

  • Shantha Kumar's avatar
    Shantha Kumar
    Brass Contributor
    Feb 22, 2019
    Try the below Microsoft Graph URL,
    https://graph.microsoft.com/v1.0/me/licenseDetails/
    https://graph.microsoft.com/v1.0/users/{userid}/licenseDetails/

    Ref:
    https://docs.microsoft.com/en-us/graph/api/user-list-licensedetails?view=graph-rest-1.0
    • Vaibhav Ukandrao Gadre's avatar
      Vaibhav Ukandrao Gadre
      Copper Contributor
      Feb 24, 2019

      Thanks for the reply, Shantha.

       

      I got license details from the API you mentioned. But I want to know which service plans refers to office online subscription with online excel as I want to verify it by code

      Please can you guide me where I can know more about this license details api response.

      • wilsonolarte's avatar
        wilsonolarte
        Copper Contributor
        Nov 09, 2023
        hi. you can search in: https://download.microsoft.com/download/e/3/e/e3e9faf2-f28b-490a-9ada-c6089a1fc5b0/Product%20names%20and%20service%20plan%20identifiers%20for%20licensing.csv and the json of sku of the tenat. In this first file, you can see the column GUID and the second file, you can see the column skuid.