Skip to main content

catalogs

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

Overview

Namecatalogs
TypeResource
Idazure.sphere.catalogs

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, catalogNameGet a Catalog
list_by_resource_groupselectsubscriptionId, resourceGroupNameList Catalog resources by resource group
list_by_subscriptionselectsubscriptionIdList Catalog resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, catalogNameCreate a Catalog
updateupdatesubscriptionId, resourceGroupName, catalogNameUpdate a Catalog
deletedeletesubscriptionId, resourceGroupName, catalogNameDelete a Catalog
count_devicesexecsubscriptionId, resourceGroupName, catalogNameCounts devices in catalog.
upload_imageexecsubscriptionId, resourceGroupName, catalogNameCreates an image. Use this action when the image ID is unknown.

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

SELECT examples

Get a Catalog

SELECT
location,
properties,
tags
FROM azure.sphere.catalogs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND catalogName = '{{ catalogName }}' -- required
;

INSERT examples

Create a Catalog

INSERT INTO azure.sphere.catalogs (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
catalogName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ catalogName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Update a Catalog

UPDATE azure.sphere.catalogs
SET
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Delete a Catalog

DELETE FROM azure.sphere.catalogs
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
;

Lifecycle Methods

Counts devices in catalog.

EXEC azure.sphere.catalogs.count_devices 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@catalogName='{{ catalogName }}' --required
;