invoice_sections

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

Overview

Name	invoice_sections
Type	Resource
Id	azure.billing.invoice_sections

Fields

vw_invoice_sections

Name	Datatype	Description
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
display_name	text	field from the properties object
invoiceSectionName	text	field from the properties object
provisioning_state	text	field from the properties object
reason_code	text	field from the properties object
state	text	field from the properties object
system_id	text	field from the properties object
tags	text	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 < > % & \ ? /
target_cloud	text	field from the properties object

invoice_sections

Name	Datatype	Description
properties	object	An invoice section.
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, billingProfileName, invoiceSectionName	Gets an invoice section by its ID. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	Lists the invoice sections that a user has access to. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
create_or_update	INSERT	billingAccountName, billingProfileName, invoiceSectionName	Creates or updates an invoice section. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
delete	DELETE	billingAccountName, billingProfileName, invoiceSectionName	Deletes an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.
validate_delete_eligibility	EXEC	billingAccountName, billingProfileName, invoiceSectionName	Validates if the invoice section can be deleted. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.

SELECT examples

Lists the invoice sections that a user has access to. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.

vw_invoice_sections

SELECT
billingAccountName,
billingProfileName,
display_name,
invoiceSectionName,
provisioning_state,
reason_code,
state,
system_id,
tags,
target_cloud
FROM azure.billing.vw_invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}';

invoice_sections

SELECT
properties,
tags
FROM azure.billing.invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}';

INSERT example

Use the following StackQL query and manifest file to create a new invoice_sections resource.

All Properties

/*+ create */
INSERT INTO azure.billing.invoice_sections (
billingAccountName,
billingProfileName,
invoiceSectionName,
tags,
properties
)
SELECT 
'{{ billingAccountName }}',
'{{ billingProfileName }}',
'{{ invoiceSectionName }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: displayName
          value: string
        - name: state
          value: string
        - name: reasonCode
          value: string
        - name: systemId
          value: string
        - name: targetCloud
          value: string
        - name: tags
          value: object

DELETE example

Deletes the specified invoice_sections resource.

/*+ delete */
DELETE FROM azure.billing.invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';