Forum Discussion

Copper Contributor

Oct 11, 2023

Solved

API for fetching Azure Product names and service plan identifiers for licensing?

Hello everyone, I want to ask if there's an existing API to connect to, to be able to read / pull the information from the link below: https://learn.microsoft.com/en-us/azure/active-directory/en...

LeonPavesic
Oct 11, 2023
Hi Kyros_Jin,

No, there is no existing API to connect to and pull the information from the link you provided.
The link you provided is a reference table that lists all of the Azure product names and service plan identifiers for licensing.

The table is updated regularly, so it is not possible to create an API that would always return the most up-to-date information.

Instead, you can use the Microsoft Graph API to fetch Azure product names and service plan identifiers for licensing. The Microsoft Graph API is a RESTful API that provides access to Microsoft data and services.

To use the Microsoft Graph API to fetch Azure product names and service plan identifiers for licensing, you would need to:
Create an Azure AD application and grant it the necessary permissions.
Get an access token for the application.
Make a GET request to the following endpoint:
https://graph.microsoft.com/v1.0/subscribedSkus
The response will be a list of objects, each of which represents a subscribed SKU. Each object will have the following properties:
skuPartNumber: The product name.
skuId: The service plan identifier.
For example, the following response shows the product name and service plan identifier for Office 365 E5:
[ { "skuPartNumber": "ENTERPRISEPREMIUM", "skuId": "e4654015-5daf-4a48-9b37-4f309dddd88b" } ]
You can then use this information to fetch related SKUs under a bundle. For example, to fetch the related SKUs for Office 365 E5, you could use the following code:

import requests # Get an access token for the Azure AD application. access_token = ... # Make a GET request to the subscribedSkus endpoint. response = requests.get( "https://graph.microsoft.com/v1.0/subscribedSkus", headers={"Authorization": f"Bearer {access_token}"} ) # Get the product name and service plan identifier for Office 365 E5. sku_part_number = "ENTERPRISEPREMIUM" sku_id = "e4654015-5daf-4a48-9b37-4f309dddd88b" # Fetch the related SKUs for Office 365 E5. related_skus_response = requests.get( "https://graph.microsoft.com/v1.0/subscribedSkus?$filter=skuId eq '%s'" % sku_id, headers={"Authorization": f"Bearer {access_token}"} ) # Get the list of related SKUs. related_skus = related_skus_response.json() # Print the list of related SKUs. for related_sku in related_skus: print(related_sku["skuPartNumber"])

This code will print the following output:
ENTERPRISESUPPORT EXCHANGE_S_STANDARD ONEDRIVE_S_STANDARD SHAREPOINT_S_STANDARD TEAMS_S_STANDARD VISIO_S_STANDARD
Some useful links:
Microsoft Graph API documentation: https://developer.microsoft.com/en-us/graph
Product names and service plan identifiers for licensing: https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/licensing-service-plan-reference

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic
(LinkedIn)

LeonPavesic

Silver Contributor

Oct 11, 2023

Hi Kyros_Jin,

No, there is no existing API to connect to and pull the information from the link you provided.

The link you provided is a reference table that lists all of the Azure product names and service plan identifiers for licensing.

The table is updated regularly, so it is not possible to create an API that would always return the most up-to-date information.

Instead, you can use the Microsoft Graph API to fetch Azure product names and service plan identifiers for licensing. The Microsoft Graph API is a RESTful API that provides access to Microsoft data and services.

To use the Microsoft Graph API to fetch Azure product names and service plan identifiers for licensing, you would need to:

Create an Azure AD application and grant it the necessary permissions.
Get an access token for the application.
Make a GET request to the following endpoint:

https://graph.microsoft.com/v1.0/subscribedSkus

The response will be a list of objects, each of which represents a subscribed SKU. Each object will have the following properties:

skuPartNumber: The product name.
skuId: The service plan identifier.

For example, the following response shows the product name and service plan identifier for Office 365 E5:

[
  {
    "skuPartNumber": "ENTERPRISEPREMIUM",
    "skuId": "e4654015-5daf-4a48-9b37-4f309dddd88b"
  }
]

You can then use this information to fetch related SKUs under a bundle. For example, to fetch the related SKUs for Office 365 E5, you could use the following code:

import requests

# Get an access token for the Azure AD application.
access_token = ...

# Make a GET request to the subscribedSkus endpoint.
response = requests.get(
    "https://graph.microsoft.com/v1.0/subscribedSkus",
    headers={"Authorization": f"Bearer {access_token}"}
)

# Get the product name and service plan identifier for Office 365 E5.
sku_part_number = "ENTERPRISEPREMIUM"
sku_id = "e4654015-5daf-4a48-9b37-4f309dddd88b"

# Fetch the related SKUs for Office 365 E5.
related_skus_response = requests.get(
    "https://graph.microsoft.com/v1.0/subscribedSkus?$filter=skuId eq '%s'" % sku_id,
    headers={"Authorization": f"Bearer {access_token}"}
)

# Get the list of related SKUs.
related_skus = related_skus_response.json()

# Print the list of related SKUs.
for related_sku in related_skus:
    print(related_sku["skuPartNumber"])

This code will print the following output:

ENTERPRISESUPPORT
EXCHANGE_S_STANDARD
ONEDRIVE_S_STANDARD
SHAREPOINT_S_STANDARD
TEAMS_S_STANDARD
VISIO_S_STANDARD

Some useful links:

Microsoft Graph API documentation: https://developer.microsoft.com/en-us/graph
Product names and service plan identifiers for licensing: https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/licensing-service-plan-reference

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic
(LinkedIn)

Kyros_Jin
Copper Contributor
Oct 11, 2023
Hi LeonPavesic,

Thank you very much for your response. Exactly what I needed. You don't know how much time you saved me and the contribution you made for me to enable something awesome for our development. Appreciate the help!

Cheers,
Kyros
- LeonPavesic
  Silver Contributor
  Oct 12, 2023
  Hi Kyros_Jin,
  
  you are welcome, I'm glad I could help you.
  
  Kindest regards
  
  Leon Pavesic
  - Bhoopesh_Kumar
    Copper Contributor
    Nov 08, 2023
    Hi LeonPavesic ,
    
    Can you please help me?
    How to get SKU/Product Display Name by the API?
    I am able to get data from below mentioned two APIs but not able to find display Name.
    
    f'https://graph.microsoft.com/v1.0/users/{user_id}/licenseDetails'
    'https://graph.microsoft.com/v1.0/servicePrincipals'
    
    Are these 2 APIs have any relation for the join data?
    
    For Example:
    "skuId":"c5928f49-12ba-48f7-ada3-0d743a3601d5",
    "skuPartNumber":"VISIOCLIENT"
    Visio Online Plan 2 VISIOCLIENT c5928f49-12ba-48f7-ada3-0d743a3601d5
    
    Display Name: "Visio Online Plan 2 ".
    
    Required for me:
    
    Regards
    Bhoopesh Kumar