Skip to main content

mediaservices

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

Overview

Namemediaservices
TypeResource
Idazure.media_services.mediaservices

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
identityobjectThe Managed Identity for the Media Services account.
locationstringThe geo-location where the resource lives
propertiesobjectThe resource properties.
systemDataobjectThe system metadata relating to this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountNameapi-versionGet the details of a Media Services account
listselectsubscriptionId, resourceGroupNameapi-versionList Media Services accounts in the resource group
list_by_subscriptionselectsubscriptionIdapi-versionList Media Services accounts in the subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, accountNameapi-versionCreates or updates a Media Services account
updateupdatesubscriptionId, resourceGroupName, accountNameapi-versionUpdates an existing Media Services account
deletedeletesubscriptionId, resourceGroupName, accountNameapi-versionDeletes a Media Services account
sync_storage_keysexecsubscriptionId, resourceGroupName, accountNameapi-versionSynchronizes storage account keys for a storage account associated with the Media Service 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
accountNamestringThe Media Services account name.
resourceGroupNamestringThe name of the resource group within the Azure subscription.
subscriptionIdstringThe unique identifier for a Microsoft Azure subscription.
api-versionstringThe version of the API to be used with the client request.

SELECT examples

Get the details of a Media Services account

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure.media_services.mediaservices
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creates or updates a Media Services account

INSERT INTO azure.media_services.mediaservices (
data__tags,
data__location,
data__properties,
data__identity,
subscriptionId,
resourceGroupName,
accountName,
api-version
)
SELECT
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ identity }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ api-version }}'
RETURNING
identity,
location,
properties,
systemData,
tags
;

UPDATE examples

Updates an existing Media Services account

UPDATE azure.media_services.mediaservices
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}',
data__identity = '{{ identity }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND api-version = '{{ api-version}}'
RETURNING
identity,
location,
properties,
systemData,
tags;

DELETE examples

Deletes a Media Services account

DELETE FROM azure.media_services.mediaservices
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND api-version = '{{ api-version }}'
;

Lifecycle Methods

Synchronizes storage account keys for a storage account associated with the Media Service account.

EXEC azure.media_services.mediaservices.sync_storage_keys 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@accountName='{{ accountName }}' --required,
@api-version='{{ api-version }}'
@@json=
'{
"id": "{{ id }}"
}'
;