transactions
Creates, updates, deletes, gets or lists a transactions resource.
Overview
| Name | transactions |
| Type | Resource |
| Id | azure.billing.transactions |
Fields
| Name | Datatype | Description |
|---|---|---|
properties | object | A transaction. |
tags | object | Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? / |
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
list_by_billing_profile | SELECT | billingAccountName, billingProfileName, periodEndDate, periodStartDate, type | Lists the billed or unbilled transactions by billing profile name for given start and end date. Transactions include purchases, refunds and Azure usage charges. Unbilled transactions are listed under pending invoice Id and do not include tax. Tax is added to the amount once an invoice is generated. |
list_by_customer | SELECT | billingAccountName, billingProfileName, customerName, periodEndDate, periodStartDate, type | Lists the billed or unbilled transactions by customer id for given start date and end date. Transactions include purchases, refunds and Azure usage charges. Unbilled transactions are listed under pending invoice Id and do not include tax. Tax is added to the amount once an invoice is generated. |
transactions_download_by_invoice | EXEC | billingAccountName, invoiceName | Gets a URL to download the transactions document for an invoice. The operation is supported for billing accounts with agreement type Enterprise Agreement. |
SELECT examples
Lists the billed or unbilled transactions by billing profile name for given start and end date. Transactions include purchases, refunds and Azure usage charges. Unbilled transactions are listed under pending invoice Id and do not include tax. Tax is added to the amount once an invoice is generated.
SELECT
properties,
tags
FROM azure.billing.transactions
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND periodEndDate = '{{ periodEndDate }}'
AND periodStartDate = '{{ periodStartDate }}'
AND type = '{{ type }}';