Azure Retail Pricesheet Api is broken

Question

Seems like there is change in api we can do pagination by 1000 now but Pagination is not working.

Azure Retail Prices API stopped responding the NextPageLink property to help with paginating through all the items.

Steps to reproduce:

1. GET https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'Virtual Machines'
2. Check the NextPageLink property

Expected:

It contains the link to the next page, e.g. https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'Virtual Machines'&$skip=1000

Actual:

It's empty.

Workaround:

Generating the link yourself. Instead of getting the next page link from the response, check the returned item count. If it's 1000, then increment the skip counter and request again.

The behavior of NextPageLink is documented: https://learn.microsoft.com/en-us/rest/api/cost-management/retail-prices/azure-retail-prices#api-response-pagination

We noticed it being empty today (2023-09-07).

Furthermore, this happens with both the default and the preview API versions.

Answer 1

Anurag singh kuhswaha There was some changes introduced to the Azure Retail API recently to increase the number of items returned per page. We observed some throttling causing this issue - occasionally API returns empty items when the throttling happening. We have taken the counter steps to overcome the throttling and it should not be an issue anymore.

If in case the throttling happens, you will be notified 429 status with a re-try time instead of giving empty response in future. Product team is working on fixing this issue.