Skip to main content

subscriptions_by_invoice_sections

Creates, updates, deletes, gets or lists a subscriptions_by_invoice_sections resource.

Overview

Namesubscriptions_by_invoice_sections
TypeResource
Idazure.billing.subscriptions_by_invoice_sections

Fields

The following fields are returned by SELECT queries:

The list of billing subscriptions.

NameDatatypeDescription
propertiesobjectThe properties of a(n) BillingSubscription
tagsobjectDictionary 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

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectbillingAccountName, billingProfileName, invoiceSectionNameincludeDeleted, expand, filter, orderBy, top, skip, count, searchLists the subscriptions that are billed to an invoice section. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
billingAccountNamestringThe ID that uniquely identifies a billing account.
billingProfileNamestringThe ID that uniquely identifies a billing profile.
invoiceSectionNamestringThe ID that uniquely identifies an invoice section.
countbooleanThe count query option allows clients to request a count of the matching resources included with the resources in the response.
expandstringCan be used to expand Reseller, ConsumptionCostCenter, LastMonthCharges and MonthToDateCharges
filterstringThe filter query option allows clients to filter a collection of resources that are addressed by a request URL.
includeDeletedbooleanCan be used to get deleted billing subscriptions.
orderBystringThe orderby query option allows clients to request resources in a particular order.
skipinteger (int64)The skip query option requests the number of items in the queried collection that are to be skipped and not included in the result.
topinteger (int64)The top query option requests the number of items in the queried collection to be included in the result. The maximum supported value for top is 50.

SELECT examples

Lists the subscriptions that are billed to an invoice section. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.

SELECT
properties,
tags
FROM azure.billing.subscriptions_by_invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}' -- required
AND billingProfileName = '{{ billingProfileName }}' -- required
AND invoiceSectionName = '{{ invoiceSectionName }}' -- required
AND includeDeleted = '{{ includeDeleted }}'
AND expand = '{{ expand }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
AND top = '{{ top }}'
AND skip = '{{ skip }}'
AND count = '{{ count }}'
AND search = '{{ search }}'
;