Skip to main content

mqs

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

Overview

Namemqs
TypeResource
Idazure.iot_mq.mqs

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectExtended Location
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, mqNameGet a MqResource
list_by_resource_groupselectsubscriptionId, resourceGroupNameList MqResource resources by resource group
list_by_subscriptionselectsubscriptionIdList MqResource resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, mqName, data__extendedLocationCreate a MqResource
updateupdatesubscriptionId, resourceGroupName, mqNameUpdate a MqResource
deletedeletesubscriptionId, resourceGroupName, mqNameDelete a MqResource

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

SELECT examples

Get a MqResource

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.iot_mq.mqs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND mqName = '{{ mqName }}' -- required
;

INSERT examples

Create a MqResource

INSERT INTO azure.iot_mq.mqs (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
mqName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ mqName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

UPDATE examples

Update a MqResource

UPDATE azure.iot_mq.mqs
SET
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

Delete a MqResource

DELETE FROM azure.iot_mq.mqs
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
;