Skip to main content

accounts

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

Overview

Nameaccounts
TypeResource
Idazure.autonomous_dev_platform.accounts

Fields

The following fields are returned by SELECT queries:

The ADP account properties were retrieved successfully

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectList of account properties
systemDataobjectThe system meta data relating to this resource
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountNameGets the properties of an ADP account
list_by_resource_groupselectsubscriptionId, resourceGroupNameList all ADP accounts available under the resource group
listselectsubscriptionIdList all ADP accounts available under the subscription
create_or_updateinsertsubscriptionId, resourceGroupName, accountNameCreates or updates an ADP account
updateupdatesubscriptionId, resourceGroupName, accountNameUpdates the properties of an existing ADP account
deletedeletesubscriptionId, resourceGroupName, accountNameDeletes an ADP account
check_name_availabilityexecsubscriptionId, name, typeChecks that the account name is valid and is not already in use

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
accountNamestringThe name of the ADP account
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the properties of an ADP account

SELECT
location,
properties,
systemData,
tags
FROM azure.autonomous_dev_platform.accounts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

INSERT examples

Creates or updates an ADP account

INSERT INTO azure.autonomous_dev_platform.accounts (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
accountName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}'
RETURNING
location,
properties,
systemData,
tags
;

UPDATE examples

Updates the properties of an existing ADP account

UPDATE azure.autonomous_dev_platform.accounts
SET
data__properties = '{{ properties }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
RETURNING
location,
properties,
systemData,
tags;

DELETE examples

Deletes an ADP account

DELETE FROM azure.autonomous_dev_platform.accounts
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
;

Lifecycle Methods

Checks that the account name is valid and is not already in use

EXEC azure.autonomous_dev_platform.accounts.check_name_availability 
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;