Azure billing data API

Question

I had created some virtual machine on Azure. Is there any APIs, PowerShell scripts or any other way to get the following information in my ASP.NET application report page.

Billing data for individual virtual machine.
Usages data for individual virtual machine.

Thanks

Any other way to automate the download billing excel process by C# or PowerShell? — Vinay Rajput, Nov 11 '13 at 10:46
Do you know if the Excel sheet covers only the current period (month) or the entire history of payment details for a subscription? — Drux, Nov 27 '14 at 22:07

score 5 · Answer 1 · answered Jul 01 '15 at 21:03

5

Azure now provides a way for customers to retrieve their usage and pricing details using the new Azure billing APIs: https://weblogs.asp.net/scottgu/new-azure-billing-apis-available

answered Jul 01 '15 at 21:03

Moinak Bandyopadhyay

126
1
3

score 1 · Accepted Answer · answered Nov 08 '13 at 09:56

1

Windows Azure does not provide an API for billing/cost metering at the moment. Amazon provides CloudWatch for this.

Windows Azure Pack (for on-premises/SP cloud using Hyper-V) does have an API for cost metering.

The API is one of the most requested features by customers. See this link http://feedback.windowsazure.com/forums/170030-billing/suggestions/1143971-billing-usage-api#comments

I guess Microsoft is working on an API. So at the moment your only option is downloading the CSV. Microsoft recently added a feature which allows to receive email alerts when the monthly costs or total costs reach a customer set threshold.

answered Nov 08 '13 at 09:56

user2968368

67
1

Any other way to automate the download billing excel process by C# or PowerShell? – Vinay Rajput Nov 11 '13 at 10:47
1

Microsoft has released APIs for EA Accounts recently, but not yet for individual\non-EA subscriptions. – Sri Kanth Sep 18 '14 at 18:27
Hi Sri Kanth, do you have link to that API? – hupseb Apr 02 '15 at 10:42

score 1 · Answer 3 · answered Jul 08 '15 at 19:36

The Azure Usage API can be called by customers and partners to get granular Azure resource usage data (hourly and daily buckets), and the response from this REST API is JSON.

Here are some more helpful links:

High-level article on Azure Billing APIs

Azure Usage API MSDN reference

Azure Billing API code samples on Github

If you have any other questions, please feel free to email me at mobandyo@microsoft.com.

score 0 · Answer 4 · answered Nov 08 '13 at 07:41

0

I'm waiting for the same features in Azure API. I have reported feature request on github for exporting usage statistics as JSON. Azure team is probably working on it. If there is some possibility to get billing data for individual VM, please write us here about this feature.

answered Nov 08 '13 at 07:41

Michał Smereczyński

329
1
2

I got a link related to billing information http://blogs.technet.com/b/systemcenter/archive/2013/07/28/creating-usage-analytics-reports-using-excel-and-performance-point-dashboards.aspx can we try something like that for Azure billing. – Vinay Rajput Nov 08 '13 at 07:48
Hmm, looks interesting. If I remember corectly, there is some possibility to download CSV file with actual billing data. But I don't remember where I saw this feature... If it is possible, there is simple way to parse this data. BUT it is true if I remember correctly :D – Michał Smereczyński Nov 08 '13 at 08:04
We can download CSV, Excel and PDF from the portal directly from Subscription=>Billing tab. But how can we automate this process by our program.? – Vinay Rajput Nov 08 '13 at 09:03
Any other way to automate the download billing excel process by C# or PowerShell? – Vinay Rajput Nov 11 '13 at 10:47

score 0 · Answer 5 · answered Aug 12 '15 at 20:24

0

In order to retrieve your Azure resource usage data, there is also a new powershell commandlet that you can avail of: get-UsageAggregates.

Example: Switch-AzureMode -Name AzureResourceManager

    Add-AzureAccount 

    Select-AzureSubscription "YOUR-AZURE-SUB-NAME"

    $agggregate = get-UsageAggregates -ReportedStartTime "5/2/2015" -ReportedEndTime "5/5/2015"

answered Aug 12 '15 at 20:24

Moinak Bandyopadhyay

126
1
3

Is there a cmdlet for getting the ratecard info? – GordonBy Dec 23 '15 at 16:35

Azure billing data API

5 Answers5