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.

   

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.