Skip to main content

accounts

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

Overview

Nameaccounts
TypeResource
Idazure.device_update.accounts

Fields

The following fields are returned by SELECT queries:

Account details.

NameDatatypeDescription
identityobjectThe type of identity used for the resource.
locationstringThe geo-location where the resource lives
propertiesobjectDevice Update account properties.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, subscriptionId, accountNameReturns account details for the given account name.
list_by_resource_groupselectresourceGroupName, subscriptionIdReturns list of Accounts.
list_by_subscriptionselectsubscriptionIdReturns list of Accounts.
createinsertresourceGroupName, subscriptionId, accountNameCreates or updates Account.
updateupdateresourceGroupName, subscriptionId, accountNameUpdates account's patchable properties
deletedeleteresourceGroupName, subscriptionId, accountNameDeletes account.

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

SELECT examples

Returns account details for the given account name.

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

INSERT examples

Creates or updates Account.

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

UPDATE examples

Updates account's patchable properties

UPDATE azure.device_update.accounts
SET
data__identity = '{{ identity }}',
data__location = '{{ location }}',
data__tags = '{{ tags }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND accountName = '{{ accountName }}' --required
RETURNING
identity,
location,
properties,
tags;

DELETE examples

Deletes account.

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