accounts

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

Overview

Name	accounts
Type	Resource
Id	azure_extras.power_platform.accounts

Fields

vw_accounts

Name	Datatype	Description
description	text	field from the properties object
accountName	text	field from the properties object
location	text	The geo-location where the resource lives
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
system_id	text	field from the properties object
tags	text	Resource tags.

accounts

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The properties that define configuration for the account.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Get information about an account.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Retrieve a list of accounts within a given resource group.
list_by_subscription	SELECT	subscriptionId	Retrieve a list of accounts within a subscription.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId	Creates an account.
delete	DELETE	accountName, resourceGroupName, subscriptionId	Delete an account.
update	UPDATE	accountName, resourceGroupName, subscriptionId	Updates an account.

SELECT examples

Retrieve a list of accounts within a subscription.

vw_accounts

SELECT
description,
accountName,
location,
resourceGroupName,
subscriptionId,
system_data,
system_id,
tags
FROM azure_extras.power_platform.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
location,
properties,
systemData,
tags
FROM azure_extras.power_platform.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.power_platform.accounts (
accountName,
resourceGroupName,
subscriptionId,
tags,
location,
properties,
systemData
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: systemId
          value: string
        - name: description
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure_extras.power_platform.accounts
SET 
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}',
systemData = '{{ systemData }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure_extras.power_platform.accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';