how to get Azure Offer ID(Billing Rate card API) using rest api

@ SadiqhAhmed-6187 Currently we are using rate card api to get calculate monthly billing for all subscriptions under tenant. First we hit RateCard Api to get all the rates using GET https://management.azure.com/subscriptions/{subscription-Id}/providers/Microsoft.Commerce/RateCard?api-version={api-version}&$filter=OfferDurableId eq ’{OfferDurableId}’ and Currency eq ’{Currency}’ and Locale eq ’{Locale}’ and RegionInfo eq ’{RegionInfo}’’ and then in response we got json having one of the property as "MeterRates": {
"0": 0.71
},

After this we hit GET https://management.azure.com/subscriptions/{subscription-Id}/providers/Microsoft.Commerce/UsageAggregates?api-version={api-version}&reportedStartTime={dateTimeOffset-value}&reportedEndTime={dateTimeOffset-value}&aggregationGranularity={granularity-value}&showDetails={showdetail-boolean-Value}&continuationToken={token-value} i .e resource usage api to get the usages having granularity as hours. In response we get "quantity": 0.057865 field.

Doc reference for usage api:https://video2.skills-academy.com/en-us/previous-versions/azure/reference/mt219001(v=azure.100)

so we do little math :---MeterRate(which we get from 1st api)*quantity to get the actual billing for that resource.

So our aim is to calculate last 30 days billing for my subscription. so we get hourly usage data by setting granularity to hour in usage request filter for last 30 days and then multiply with rate ...so we have hourly cost of that resource ...store in db this hourly data and the sum all the price calculated for that resource for last 30 days.