Azure Costs: Exporting data via API

Azure Costs now offers direct API access to integrate the processed and aggregated data directly in 3rd party applications like Qlik or Tableau. This option allows customers on an enterprise plan or higher to render or analyse the Azure Costs data in existing BI solutions.

Exporting data via API is very simple. Just follow the steps below:

  1. Register an application as trustee to control which data can be access from the 3rd party application in the team management view.

    ApiCredentials

  2. The application contains a client_id and a client_secret which can be used for the oAuth2 client credentials flow. Just issue a new security token at least every hour from the Azure Costs STS. We recommend to issue a token whenever you start a new transaction to ensure that permission changes are affective.

    curl -X POST -d “client_id={{YOUR CLIENT ID}}&client_secret={{YOUR CLIENT SECERT}}&grant_type=client_credentials” https://azure-costs.com/sts/issue/oauth/token

  3. Export the required report from the export api which returns the data in JSON format. Every single object describes one service including the quantity, costs and other meta information. The required teamId, contract number can be extracted from the URL of the Azure Costs dashboard

    curl -H “Authorization: Bearer {{ISSUED TOKEN}}” https:/api.azure-costs.com/api/v1/teams/{{teamId}}/contracts/{{contractId}}/reports/{{Year}}-{{Month}}/export?cache={{DATE-OF-THE-DAY}}

Interested in the new feature?
Try the new feature today by simply logging into your Azure Costs account. The feature is part of any enterprise plan.

Any questions, wishes or ideas? Try our feedback portal or drop a mail to help@azure-costs.com.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s