Clarification on Mapping Subscription Data with /subscribedskus API Response

Hi @Saqib Rajput ,

You’re seeing expected behavior. The /v1/customers/{tenantId}/subscribedskus endpoint exposes tenant‑level (pooled) license information per product SKU. It doesn’t include or map back to individual subscriptionId values because seat usage isn’t tracked per subscription—only at the SKU pool level.

I think you would have to scrape the data and merge them yourself:

1. Load the two endpoint responses into two tables:
   • Subscribed SKU pool: Get a list of available licenses
   • Subscriptions: Get all of a customer's subscriptions
2. Join on productSkuId (subscribedskus.productSku.id = subscriptions.productSkuId) and aggregate.

Conceptual

SELECT

  pool.productSkuId,

  pool.skuPartNumber,

  SUM(sub.quantity) AS totalPurchasedSeats,

  pool.activeUnits,

  pool.availableUnits

FROM SubscribedSkuPool pool

JOIN Subscriptions sub

  ON sub.productSkuId = pool.productSkuId

GROUP BY

  pool.productSkuId,

  pool.skuPartNumber,

  pool.activeUnits,

  pool.availableUnits;

If this approach doesn't work out for you, please consider reaching out to partner center support https://learn.microsoft.com/en-us/partner-center/support/report-problems-with-partner-center

Hope this helps.