asset_filters

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

Overview

Name	asset_filters
Type	Resource
Id	azure.media_services.asset_filters

Fields

vw_asset_filters

Name	Datatype	Description
accountName	text	field from the properties object
assetName	text	field from the properties object
filterName	text	field from the properties object
first_quality	text	field from the properties object
presentation_time_range	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tracks	text	field from the properties object

asset_filters

Name	Datatype	Description
properties	object	The Media Filter properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, assetName, filterName, resourceGroupName, subscriptionId	Get the details of an Asset Filter associated with the specified Asset.
list	SELECT	accountName, assetName, resourceGroupName, subscriptionId	List Asset Filters associated with the specified Asset.
create_or_update	INSERT	accountName, assetName, filterName, resourceGroupName, subscriptionId	Creates or updates an Asset Filter associated with the specified Asset.
delete	DELETE	accountName, assetName, filterName, resourceGroupName, subscriptionId	Deletes an Asset Filter associated with the specified Asset.
update	UPDATE	accountName, assetName, filterName, resourceGroupName, subscriptionId	Updates an existing Asset Filter associated with the specified Asset.

SELECT examples

List Asset Filters associated with the specified Asset.

vw_asset_filters

SELECT
accountName,
assetName,
filterName,
first_quality,
presentation_time_range,
resourceGroupName,
subscriptionId,
system_data,
tracks
FROM azure.media_services.vw_asset_filters
WHERE accountName = '{{ accountName }}'
AND assetName = '{{ assetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

asset_filters

SELECT
properties,
systemData
FROM azure.media_services.asset_filters
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 asset_filters resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: presentationTimeRange
          value:
            - name: startTimestamp
              value: integer
            - name: endTimestamp
              value: integer
            - name: presentationWindowDuration
              value: integer
            - name: liveBackoffDuration
              value: integer
            - name: timescale
              value: integer
            - name: forceEndTimestamp
              value: boolean
        - name: firstQuality
          value:
            - name: bitrate
              value: integer
        - name: tracks
          value:
            - - name: trackSelections
                value:
                  - - name: property
                      value: string
                    - name: value
                      value: string
                    - name: operation
                      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 asset_filters resource.

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

DELETE example

Deletes the specified asset_filters resource.

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