How to retrieve SQL Database price with SQL Licence, using the azure retail prices

Question

Hello,
I'm trying to retrive the SQL Database prices using the Azure Retail Prices API, but I'm not finding the SQL license price, i'm finding only the "hardware" price

Example using powershell:

$url = "https://prices.azure.com/api/retail/prices?currencyCode='BRL'&`$filter=serviceName eq 'SQL Database' and armRegionName eq 'eastus2' and meterName eq 'vCore'"

Anyone knows how to retrieve, in Azure SQL Database, the SQL Licence price in API?

In Azure Calculator we can find the SQL Licence

Thanks in advance

Answer 1

Hi Pedro,

Please try using below URL:

https://prices.azure.com/api/retail/prices?currencyCode='BRL'&$filter=serviceName eq 'SQL Database' and armRegionName eq 'Global' and meterName eq 'vCore' and priceType eq 'Consumption'

Output from above:

{
    "BillingCurrency": "BRL",
    "CustomerEntityId": "Default",
    "CustomerEntityType": "Retail",
    "Items": [
        {
            "currencyCode": "BRL",
            "tierMinimumUnits": 0.0,
            "retailPrice": 0.4989,
            "unitPrice": 0.4989,
            "armRegionName": "Global",
            "location": "Global",
            "effectiveStartDate": "2019-07-01T00:00:00Z",
            "meterId": "5fb02b75-1418-4fd0-8c07-dd5949d007dd",
            "meterName": "vCore",
            "productId": "DZH318Z0BXVM",
            "skuId": "DZH318Z0BXVM/001B",
            "productName": "SQL Database SingleDB/Elastic Pool Hyperscale - SQL License",
            "skuName": "vCore",
            "serviceName": "SQL Database",
            "serviceId": "DZH3180HX10K",
            "serviceFamily": "Databases",
            "unitOfMeasure": "1 Hour",
            "type": "Consumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": ""
        },
        {
            "currencyCode": "BRL",
            "tierMinimumUnits": 0.0,
            "retailPrice": 0.4989,
            "unitPrice": 0.4989,
            "armRegionName": "Global",
            "location": "Global",
            "effectiveStartDate": "2018-07-15T00:00:00Z",
            "meterId": "6f344f4b-7c91-4026-915a-a1b597793be1",
            "meterName": "vCore",
            "productId": "DZH318Z0BQDL",
            "skuId": "DZH318Z0BQDL/001H",
            "productName": "SQL Database Single/Elastic Pool General Purpose - SQL License",
            "skuName": "vCore",
            "serviceName": "SQL Database",
            "serviceId": "DZH3180HX10K",
            "serviceFamily": "Databases",
            "unitOfMeasure": "1 Hour",
            "type": "Consumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": ""
        },
        {
            "currencyCode": "BRL",
            "tierMinimumUnits": 0.0,
            "retailPrice": 1.8714,
            "unitPrice": 1.8714,
            "armRegionName": "Global",
            "location": "Global",
            "effectiveStartDate": "2018-07-15T00:00:00Z",
            "meterId": "e9889554-fb00-4e00-bb08-21788c9d0dc8",
            "meterName": "vCore",
            "productId": "DZH318Z0BQDK",
            "skuId": "DZH318Z0BQDK/001K",
            "productName": "SQL Database Single/Elastic Pool Business Critical - SQL License",
            "skuName": "vCore",
            "serviceName": "SQL Database",
            "serviceId": "DZH3180HX10K",
            "serviceFamily": "Databases",
            "unitOfMeasure": "1 Hour",
            "type": "Consumption",
            "isPrimaryMeterRegion": true,
            "armSkuName": ""
        }
    ],
    "NextPageLink": null,
    "Count": 3
}

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP