extensions

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

Overview

Name	extensions
Type	Resource
Id	azure_extras.ag_food_platform.extensions

Fields

vw_extensions

Name	Datatype	Description
additional_api_properties	text	field from the properties object
dataManagerForAgricultureResourceName	text	field from the properties object
e_tag	text	field from the properties object
extensionId	text	field from the properties object
extension_api_docs_link	text	field from the properties object
extension_auth_link	text	field from the properties object
extension_category	text	field from the properties object
extension_id	text	field from the properties object
installed_extension_version	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

extensions

Name	Datatype	Description
eTag	string	The ETag value to implement optimistic concurrency.
properties	object	Extension resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataManagerForAgricultureResourceName, extensionId, resourceGroupName, subscriptionId	Get installed extension details by extension id.
list_by_data_manager_for_agriculture	SELECT	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Get installed extensions details.
create_or_update	INSERT	dataManagerForAgricultureResourceName, extensionId, resourceGroupName, subscriptionId	Install or Update extension. Additional Api Properties are merged patch and if the extension is updated to a new version then the obsolete entries will be auto deleted from Additional Api Properties.
delete	DELETE	dataManagerForAgricultureResourceName, extensionId, resourceGroupName, subscriptionId	Uninstall extension.

SELECT examples

Get installed extensions details.

vw_extensions

SELECT
additional_api_properties,
dataManagerForAgricultureResourceName,
e_tag,
extensionId,
extension_api_docs_link,
extension_auth_link,
extension_category,
extension_id,
installed_extension_version,
resourceGroupName,
subscriptionId,
system_data
FROM azure_extras.ag_food_platform.vw_extensions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

extensions

SELECT
eTag,
properties,
systemData
FROM azure_extras.ag_food_platform.extensions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.ag_food_platform.extensions (
dataManagerForAgricultureResourceName,
extensionId,
resourceGroupName,
subscriptionId,
extensionVersion,
additionalApiProperties
)
SELECT 
'{{ dataManagerForAgricultureResourceName }}',
'{{ extensionId }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ extensionVersion }}',
'{{ additionalApiProperties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: extensionVersion
      value: string
    - name: additionalApiProperties
      value: object

DELETE example

Deletes the specified extensions resource.

/*+ delete */
DELETE FROM azure_extras.ag_food_platform.extensions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND extensionId = '{{ extensionId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';