Azure Retail Pricing API returning only spot pricing

Question

Hello,

I am trying to get retail prices for different SKUs from Azure retail prices API and it returns ONLY SPOT and RESERVATION pricing, but I need Consumption.
I have tested multiple regions and multiple SKUs, the same SKUs doesn't work no matter what region I chose, but some of the SKUs are returning results.
Below is an example of an SKU that does NOT work:

This is the request:

https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'Virtual Machines' and armRegionName eq 'eastus' and currencyCode eq 'USD' and armSkuName eq 'Standard_D4s_v3'

This is the response:

{
"BillingCurrency": "USD",
"CustomerEntityId": "Default",
"CustomerEntityType": "Retail",
"Items": [
{
"currencyCode": "USD",
"tierMinimumUnits": 0.0,
"reservationTerm": "1 Year",
"retailPrice": 1003.0,
"unitPrice": 1003.0,
"armRegionName": "eastus",
"location": "US East",
"effectiveStartDate": "2017-12-15T00:00:00Z",
"meterId": "3da19ca3-6007-4a29-89ea-cab10c2010ed",
"meterName": "D4s v3",
"productId": "DZH318Z0BQ50",
"skuId": "DZH318Z0BQ50/00C6",
"productName": "Virtual Machines DSv3 Series",
"skuName": "D4s v3",
"serviceName": "Virtual Machines",
"serviceId": "DZH313Z7MMC8",
"serviceFamily": "Compute",
"unitOfMeasure": "1 Hour",
"type": "Reservation",
"isPrimaryMeterRegion": false,
"armSkuName": "Standard_D4s_v3"
},
{
"currencyCode": "USD",
"tierMinimumUnits": 0.0,
"reservationTerm": "3 Years",
"retailPrice": 1937.0,
"unitPrice": 1937.0,
"armRegionName": "eastus",
"location": "US East",
"effectiveStartDate": "2017-12-15T00:00:00Z",
"meterId": "3da19ca3-6007-4a29-89ea-cab10c2010ed",
"meterName": "D4s v3",
"productId": "DZH318Z0BQ50",
"skuId": "DZH318Z0BQ50/00C5",
"productName": "Virtual Machines DSv3 Series",
"skuName": "D4s v3",
"serviceName": "Virtual Machines",
"serviceId": "DZH313Z7MMC8",
"serviceFamily": "Compute",
"unitOfMeasure": "1 Hour",
"type": "Reservation",
"isPrimaryMeterRegion": false,
"armSkuName": "Standard_D4s_v3"
},
{
"currencyCode": "USD",
"tierMinimumUnits": 0.0,
"retailPrice": 0.086592,
"unitPrice": 0.086592,
"armRegionName": "eastus",
"location": "US East",
"effectiveStartDate": "2021-09-01T00:00:00Z",
"meterId": "8f3c1969-fecf-5891-9c8e-2e195552bdac",
"meterName": "D4s v3 Spot",
"productId": "DZH318Z0BPWD",
"skuId": "DZH318Z0BPWD/014W",
"productName": "Virtual Machines DSv3 Series Windows",
"skuName": "D4s v3 Spot",
"serviceName": "Virtual Machines",
"serviceId": "DZH313Z7MMC8",
"serviceFamily": "Compute",
"unitOfMeasure": "1 Hour",
"type": "DevTestConsumption",
"isPrimaryMeterRegion": true,
"armSkuName": "Standard_D4s_v3"
},
{
"currencyCode": "USD",
"tierMinimumUnits": 0.0,
"retailPrice": 0.216538,
"unitPrice": 0.216538,
"armRegionName": "eastus",
"location": "US East",
"effectiveStartDate": "2021-09-01T00:00:00Z",
"meterId": "8f3c1969-fecf-5891-9c8e-2e195552bdac",
"meterName": "D4s v3 Spot",
"productId": "DZH318Z0BPWD",
"skuId": "DZH318Z0BPWD/014W",
"productName": "Virtual Machines DSv3 Series Windows",
"skuName": "D4s v3 Spot",
"serviceName": "Virtual Machines",
"serviceId": "DZH313Z7MMC8",
"serviceFamily": "Compute",
"unitOfMeasure": "1 Hour",
"type": "Consumption",
"isPrimaryMeterRegion": true,
"armSkuName": "Standard_D4s_v3"
},
{
"currencyCode": "USD",
"tierMinimumUnits": 0.0,
"retailPrice": 0.086592,
"unitPrice": 0.086592,
"armRegionName": "eastus",
"location": "US East",
"effectiveStartDate": "2021-09-01T00:00:00Z",
"meterId": "cf64c470-a287-5429-8dd7-756a877824a0",
"meterName": "D4s v3 Spot",
"productId": "DZH318Z0BQ50",
"skuId": "DZH318Z0BQ50/0230",
"productName": "Virtual Machines DSv3 Series",
"skuName": "D4s v3 Spot",
"serviceName": "Virtual Machines",
"serviceId": "DZH313Z7MMC8",
"serviceFamily": "Compute",
"unitOfMeasure": "1 Hour",
"type": "Consumption",
"isPrimaryMeterRegion": true,
"armSkuName": "Standard_D4s_v3"
}
],
"NextPageLink": null,
"Count": 5
}

Answer 1

@Daniel Pana Welcome to Microsoft Q & A Community Forum. I have tested from my end and I could see results related to SKU you have mentioned and also its part of your results as well. I would suggest you to recheck and share if you are noticing any disparity for other SKU's.