Skip to main content

invitations

Creates, updates, deletes, gets or lists an invitations resource.

Overview

Nameinvitations
TypeResource
Idazure.data_share.invitations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource id of the azure resource
namestringName of the azure resource
propertiesobjectProperties on the Invitation
systemDataobjectSystem Data of the Azure resource.
typestringType of the azure resource

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, shareName, invitationNameapi-versionGet an invitation in a share
list_by_shareselectsubscriptionId, resourceGroupName, accountName, shareNameapi-version, $skipToken, $filter, $orderbyList invitations in a share
createinsertsubscriptionId, resourceGroupName, accountName, shareName, invitationNameapi-versionCreate an invitation
deletedeletesubscriptionId, resourceGroupName, accountName, shareName, invitationNameapi-versionDelete an invitation in a share

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
accountNamestringThe name of the share account.
invitationNamestringThe name of the invitation.
resourceGroupNamestringThe resource group name.
shareNamestringThe name of the share.
subscriptionIdstringThe subscription identifier
$filterstringFilters the results using OData syntax.
$orderbystringSorts the results using OData syntax.
$skipTokenstringThe continuation token
api-versionstringThe api version to use.

SELECT examples

Get an invitation in a share

SELECT
id,
name,
properties,
systemData,
type
FROM azure.data_share.invitations
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND shareName = '{{ shareName }}' -- required
AND invitationName = '{{ invitationName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Create an invitation

INSERT INTO azure.data_share.invitations (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
shareName,
invitationName,
api-version
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ shareName }}',
'{{ invitationName }}',
'{{ api-version }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete an invitation in a share

DELETE FROM azure.data_share.invitations
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND shareName = '{{ shareName }}' --required
AND invitationName = '{{ invitationName }}' --required
AND api-version = '{{ api-version }}'
;