Azure Sql database price mismatch with portal and retail price api

Question

Hello Azure Team,
Hope you are doing well!!

I need your help regarding price list information of SQL database, I need per hour price, storage data for DTU based database and Vcore based database(Through API), I am using retail price API-"https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'SQL Database'&location='US East" for getting SQL database price information and I am getting correct price for DTU based databases all combinations listed below

-Basic
-Standard all combination(S0,S1,S2,S3,S4,S6,S7,S9,S12)
-Premium all combination(P1,P2,P4,P6,P11,P15)

When I try to search price information in API response for Vcore based databases (Genaral Purpose, Business critical and Hyperscale) then I am not able to get correct price information for each combination listed below

• General Purpose
  GEN5----> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80
  DC-Series----> Vcore -2,4,6,8
  Fsv2-Series--> Vcore -8,10,12,14,16,18,20,24,32,36,72
• Business Critical
  GEN5---> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80
  Fsv2-Series--> Vcore -8,10,12,14,16,18,20,24,32,64,128
• Hyperscale
  GEN5----> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80

Example- When I am searcing for "SQL Database Single/Elastic Pool General Purpose - Compute Gen5" '2 Vcore' combination of GEN5 series of General Purpose database then I am gettig UnitPrice 0.304434/hour but on portal it is $0.51/hour for "US East" region
Here is response for 2vcore-
{
"currencyCode"=>"USD",
"tierMinimumUnits"=>0.0,
"retailPrice"=>0.304434,
"unitPrice"=>0.304434,
"armRegionName"=>"eastus",
"location"=>"US East",
"effectiveStartDate"=>"2018-07-15T00:00:00Z",
"meterId"=>"d0fc12d4-91ca-4689-bf8f-9ccdf1b0a619",
"meterName"=>"vCore",
"productId"=>"DZH318Z0BPXL",
"skuId"=>"DZH318Z0BPXL/00BT",
"productName"=>"SQL Database Single/Elastic Pool General Purpose - Compute Gen5",
"skuName"=>"2 vCore",
"serviceName"=>"SQL Database",
"serviceId"=>"DZH3180HX10K",
"serviceFamily"=>"Databases",
"unitOfMeasure"=>"1 Hour",
"type"=>"Consumption",
"isPrimaryMeterRegion"=>false,
"armSkuName"=>"SQLDB_GP_Compute_Gen5_2"
}
I am verifying the cost from this link - https://azure.microsoft.com/en-in/pricing/details/azure-sql-database/single/

Please Let me know How can I get correct /hours price information of each type of database( Vcore) in selected region using this API or any other API

Note- I am using "US East" Region in API and I need SQL database price information to all available combinations in selected regions, I have listed above 'Us East' available database combination for each type of database.

Answer 1

@Saheb Seikh Thank you for reaching out. We apologize for the delayed response.

If you are using an MSDN subscription or your subscription has an offer code applied, you may see a price that is different from the retail price.

Unfortunately, we will not be able to access your subscription from the Q&A forum.
Please reach out to Azure support so that an engineer can check your subscription details and help you accordingly.

You can create the support request as "Billing" issue

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.