Support of Windows VMs in Azure Retail Price API ?

Question

Hi,

I'm trying to get all the prices ( paygo, reservations and savings plans) for a Windows D8s v5 VM (meterId = 542721a0-bbad-5e5f-9779-951cd22b48f7) in westeurope.

I tried the following query : https://prices.azure.com/api/retail/prices?api-version=2023-01-01-preview&currencyCode=EUR&$filter=armRegionName eq 'northeurope' and meterId eq '542721a0-bbad-5e5f-9779-951cd22b48f7'

Unfortunately it returns only the Consumption (paygo) and DevTest pricing :

{
    "BillingCurrency": "EUR",
    "CustomerEntityId": "Default",
    "CustomerEntityType": "Retail",
    "Items": [
        {
            "currencyCode": "EUR",
            "tierMinimumUnits": 0,
            "retailPrice": 0.757266,
            "unitPrice": 0.757266,
            "armRegionName": "northeurope",
            "location": "EU North",
            "effectiveStartDate": "2021-11-01T00:00:00Z",
            "meterId": "542721a0-bbad-5e5f-9779-951cd22b48f7",
            "meterName": "D8s v5",
            "productId": "DZH318Z08M9T",
            "skuId": "DZH318Z08M9T/0025",
            "productName": "Virtual Machines Dsv5 Series Windows",
            "skuName": "Standard_D8s_v5",
            "serviceName": "Virtual Machines",
            "serviceId": "DZH313Z7MMC8",
            "serviceFamily": "Compute",
            "unitOfMeasure": "1 Hour",
            "type": "Consumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": "Standard_D8s_v5"
        },
        {
            "currencyCode": "EUR",
            "tierMinimumUnits": 0,
            "retailPrice": 0.407173,
            "unitPrice": 0.407173,
            "armRegionName": "northeurope",
            "location": "EU North",
            "effectiveStartDate": "2021-11-01T00:00:00Z",
            "meterId": "542721a0-bbad-5e5f-9779-951cd22b48f7",
            "meterName": "D8s v5",
            "productId": "DZH318Z08M9T",
            "skuId": "DZH318Z08M9T/0025",
            "productName": "Virtual Machines Dsv5 Series Windows",
            "skuName": "Standard_D8s_v5",
            "serviceName": "Virtual Machines",
            "serviceId": "DZH313Z7MMC8",
            "serviceFamily": "Compute",
            "unitOfMeasure": "1 Hour",
            "type": "DevTestConsumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": "Standard_D8s_v5"
        }
    ],
    "NextPageLink": null,
    "Count": 2
}

If I try to search for the prices for the same VM SKU and region , but operating on Linux, i.e we update the meterId to 985742f3-ff1c-5cff-b80d-54698071549d and issue the following query :

https://prices.azure.com/api/retail/prices?api-version=2023-01-01-preview&currencyCode=EUR&$filter=armRegionName eq 'northeurope' and meterId eq '985742f3-ff1c-5cff-b80d-54698071549d'

Then the response is complete and accurate :

{
    "BillingCurrency": "EUR",
    "CustomerEntityId": "Default",
    "CustomerEntityType": "Retail",
    "Items": [
        {
            "currencyCode": "EUR",
            "tierMinimumUnits": 0,
            "retailPrice": 0.407173,
            "unitPrice": 0.407173,
            "armRegionName": "northeurope",
            "location": "EU North",
            "effectiveStartDate": "2021-11-01T00:00:00Z",
            "meterId": "985742f3-ff1c-5cff-b80d-54698071549d",
            "meterName": "D8s v5",
            "productId": "DZH318Z08M9W",
            "skuId": "DZH318Z08M9W/00BK",
            "productName": "Virtual Machines Dsv5 Series",
            "skuName": "Standard_D8s_v5",
            "serviceName": "Virtual Machines",
            "serviceId": "DZH313Z7MMC8",
            "serviceFamily": "Compute",
            "unitOfMeasure": "1 Hour",
            "type": "Consumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": "Standard_D8s_v5",
            "savingsPlan": [
                {
                    "unitPrice": 0.210997,
                    "retailPrice": 0.210997,
                    "term": "3 Years"
                },
                {
                    "unitPrice": 0.306846,
                    "retailPrice": 0.306846,
                    "term": "1 Year"
                }
            ]
        },
        {
            "currencyCode": "EUR",
            "tierMinimumUnits": 0,
            "reservationTerm": "1 Year",
            "retailPrice": 2104.361889,
            "unitPrice": 2104.361889,
            "armRegionName": "northeurope",
            "location": "EU North",
            "effectiveStartDate": "2021-11-01T00:00:00Z",
            "meterId": "985742f3-ff1c-5cff-b80d-54698071549d",
            "meterName": "D8s v5",
            "productId": "DZH318Z08M9W",
            "skuId": "DZH318Z08M9W/02HB",
            "productName": "Virtual Machines Dsv5 Series",
            "skuName": "Standard_D8s_v5",
            "serviceName": "Virtual Machines",
            "serviceId": "DZH313Z7MMC8",
            "serviceFamily": "Compute",
            "unitOfMeasure": "1 Hour",
            "type": "Reservation",
            "isPrimaryMeterRegion": true,
            "armSkuName": "Standard_D8s_v5"
        },
        {
            "currencyCode": "EUR",
            "tierMinimumUnits": 0,
            "reservationTerm": "3 Years",
            "retailPrice": 4066.022927,
            "unitPrice": 4066.022927,
            "armRegionName": "northeurope",
            "location": "EU North",
            "effectiveStartDate": "2021-11-01T00:00:00Z",
            "meterId": "985742f3-ff1c-5cff-b80d-54698071549d",
            "meterName": "D8s v5",
            "productId": "DZH318Z08M9W",
            "skuId": "DZH318Z08M9W/02HC",
            "productName": "Virtual Machines Dsv5 Series",
            "skuName": "Standard_D8s_v5",
            "serviceName": "Virtual Machines",
            "serviceId": "DZH313Z7MMC8",
            "serviceFamily": "Compute",
            "unitOfMeasure": "1 Hour",
            "type": "Reservation",
            "isPrimaryMeterRegion": true,
            "armSkuName": "Standard_D8s_v5"
        }
    ],
    "NextPageLink": null,
    "Count": 3
}

Does it mean that the API does not support Windows based VMs ?

If this is the case, what other programmatic alternatives do we have to get the SP and RI pricing for Windows VMs ?

Thanks in advance