tracks

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

Overview

Name	tracks
Type	Resource
Id	azure.media_services.tracks

Fields

vw_tracks

Name	Datatype	Description
accountName	text	field from the properties object
assetName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
track	text	field from the properties object
trackName	text	field from the properties object

tracks

Name	Datatype	Description
properties	object	Properties of a video, audio or text track in the asset.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, assetName, resourceGroupName, subscriptionId, trackName	Get the details of a Track in the Asset
list	SELECT	accountName, assetName, resourceGroupName, subscriptionId	Lists the Tracks in the asset
create_or_update	INSERT	accountName, assetName, resourceGroupName, subscriptionId, trackName	Create or update a Track in the asset
delete	DELETE	accountName, assetName, resourceGroupName, subscriptionId, trackName	Deletes a Track in the asset
update	UPDATE	accountName, assetName, resourceGroupName, subscriptionId, trackName	Updates an existing Track in the asset

SELECT examples

Lists the Tracks in the asset

vw_tracks

SELECT
accountName,
assetName,
provisioning_state,
resourceGroupName,
subscriptionId,
track,
trackName
FROM azure.media_services.vw_tracks
WHERE accountName = '{{ accountName }}'
AND assetName = '{{ assetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

tracks

SELECT
properties
FROM azure.media_services.tracks
WHERE accountName = '{{ accountName }}'
AND assetName = '{{ assetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.media_services.tracks (
accountName,
assetName,
resourceGroupName,
subscriptionId,
trackName,
properties
)
SELECT 
'{{ accountName }}',
'{{ assetName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ trackName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: track
          value:
            - name: '@odata.type'
              value: string
        - name: provisioningState
          value: string

UPDATE example

Updates a tracks resource.

/*+ update */
UPDATE azure.media_services.tracks
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND assetName = '{{ assetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trackName = '{{ trackName }}';

DELETE example

Deletes the specified tracks resource.

/*+ delete */
DELETE FROM azure.media_services.tracks
WHERE accountName = '{{ accountName }}'
AND assetName = '{{ assetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trackName = '{{ trackName }}';