products

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

Overview

Name	products
Type	Resource
Id	azure.billing.products

Fields

Name	Datatype	Description
properties	object	A product.
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
get	SELECT	billingAccountName, productName	Gets a product by ID. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
list_by_billing_account	SELECT	billingAccountName	Lists the products for a billing account. These don't include products billed based on usage. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Partner Agreement.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	Lists the products for a billing profile. These don't include products billed based on usage. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Partner Agreement.
list_by_customer	SELECT	billingAccountName, customerName	Lists the products for a customer. These don't include products billed based on usage.The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.
update	UPDATE	billingAccountName, productName	Updates the properties of a Product. Currently, auto renew can be updated. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
move	EXEC	billingAccountName, productName, data__destinationInvoiceSectionId	Moves a product's charges to a new invoice section. The new invoice section must belong to the same billing profile as the existing invoice section. This operation is supported only for products that are purchased with a recurring charge and for billing accounts with agreement type Microsoft Customer Agreement.
validate_move_eligibility	EXEC	billingAccountName, productName, data__destinationInvoiceSectionId	Validates if a product's charges can be moved to a new invoice section. This operation is supported only for products that are purchased with a recurring charge and for billing accounts with agreement type Microsoft Customer Agreement.

SELECT examples

Lists the products for a billing account. These don't include products billed based on usage. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Partner Agreement.

SELECT
properties,
tags
FROM azure.billing.products
WHERE billingAccountName = '{{ billingAccountName }}';

UPDATE example

Updates a products resource.

/*+ update */
UPDATE azure.billing.products
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
billingAccountName = '{{ billingAccountName }}'
AND productName = '{{ productName }}';