role_assignments_by_invoice_sections

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

Overview

Name	role_assignments_by_invoice_sections
Type	Resource
Id	azure.billing.role_assignments_by_invoice_sections

Fields

vw_role_assignments_by_invoice_sections

Name	Datatype	Description
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
billingRoleAssignmentName	text	field from the properties object
billing_account_display_name	text	field from the properties object
billing_account_id	text	field from the properties object
billing_profile_display_name	text	field from the properties object
billing_profile_id	text	field from the properties object
billing_request_id	text	field from the properties object
created_by_principal_id	text	field from the properties object
created_by_principal_puid	text	field from the properties object
created_by_principal_tenant_id	text	field from the properties object
created_by_user_email_address	text	field from the properties object
created_on	text	field from the properties object
customer_display_name	text	field from the properties object
customer_id	text	field from the properties object
invoiceSectionName	text	field from the properties object
invoice_section_display_name	text	field from the properties object
invoice_section_id	text	field from the properties object
modified_by_principal_id	text	field from the properties object
modified_by_principal_puid	text	field from the properties object
modified_by_principal_tenant_id	text	field from the properties object
modified_by_user_email_address	text	field from the properties object
modified_on	text	field from the properties object
principal_display_name	text	field from the properties object
principal_id	text	field from the properties object
principal_puid	text	field from the properties object
principal_tenant_id	text	field from the properties object
principal_tenant_name	text	field from the properties object
principal_type	text	field from the properties object
provisioning_state	text	field from the properties object
role_definition_id	text	field from the properties object
scope	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 < > % & \ ? /
user_authentication_type	text	field from the properties object
user_email_address	text	field from the properties object

role_assignments_by_invoice_sections

Name	Datatype	Description
properties	object	The properties of the billing role assignment.
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, billingRoleAssignmentName, invoiceSectionName	Gets a role assignment for the caller on an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.
list	SELECT	billingAccountName, billingProfileName, invoiceSectionName	Lists the role assignments for the caller on an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.
create	INSERT	billingAccountName, billingProfileName, invoiceSectionName, data__roleDefinitionId	Adds a role assignment on an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.
delete	DELETE	billingAccountName, billingProfileName, billingRoleAssignmentName, invoiceSectionName	Deletes a role assignment on an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.

SELECT examples

Lists the role assignments for the caller on an invoice section. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement.

vw_role_assignments_by_invoice_sections

SELECT
billingAccountName,
billingProfileName,
billingRoleAssignmentName,
billing_account_display_name,
billing_account_id,
billing_profile_display_name,
billing_profile_id,
billing_request_id,
created_by_principal_id,
created_by_principal_puid,
created_by_principal_tenant_id,
created_by_user_email_address,
created_on,
customer_display_name,
customer_id,
invoiceSectionName,
invoice_section_display_name,
invoice_section_id,
modified_by_principal_id,
modified_by_principal_puid,
modified_by_principal_tenant_id,
modified_by_user_email_address,
modified_on,
principal_display_name,
principal_id,
principal_puid,
principal_tenant_id,
principal_tenant_name,
principal_type,
provisioning_state,
role_definition_id,
scope,
tags,
user_authentication_type,
user_email_address
FROM azure.billing.vw_role_assignments_by_invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';

role_assignments_by_invoice_sections

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.billing.role_assignments_by_invoice_sections (
billingAccountName,
billingProfileName,
invoiceSectionName,
data__roleDefinitionId,
principalPuid,
principalId,
principalTenantId,
roleDefinitionId,
scope,
userAuthenticationType,
userEmailAddress
)
SELECT 
'{{ billingAccountName }}',
'{{ billingProfileName }}',
'{{ invoiceSectionName }}',
'{{ data__roleDefinitionId }}',
'{{ principalPuid }}',
'{{ principalId }}',
'{{ principalTenantId }}',
'{{ roleDefinitionId }}',
'{{ scope }}',
'{{ userAuthenticationType }}',
'{{ userEmailAddress }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: provisioningState
      value: string
    - name: createdOn
      value: string
    - name: createdByPrincipalTenantId
      value: string
    - name: createdByPrincipalId
      value: string
    - name: createdByPrincipalPuid
      value: string
    - name: createdByUserEmailAddress
      value: string
    - name: modifiedOn
      value: string
    - name: modifiedByPrincipalPuid
      value: string
    - name: modifiedByUserEmailAddress
      value: string
    - name: modifiedByPrincipalId
      value: string
    - name: modifiedByPrincipalTenantId
      value: string
    - name: principalPuid
      value: string
    - name: principalId
      value: string
    - name: principalTenantId
      value: string
    - name: roleDefinitionId
      value: string
    - name: scope
      value: string
    - name: userAuthenticationType
      value: string
    - name: userEmailAddress
      value: string
    - name: principalTenantName
      value: string
    - name: principalDisplayName
      value: string
    - name: principalType
      value: string
    - name: billingRequestId
      value: string
    - name: billingAccountId
      value: string
    - name: billingAccountDisplayName
      value: string
    - name: billingProfileId
      value: string
    - name: billingProfileDisplayName
      value: string
    - name: invoiceSectionId
      value: string
    - name: invoiceSectionDisplayName
      value: string
    - name: customerId
      value: string
    - name: customerDisplayName
      value: string

DELETE example

Deletes the specified role_assignments_by_invoice_sections resource.

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