suppression_list_addresses

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

Overview

Name	suppression_list_addresses
Type	Resource
Id	azure.communication.suppression_list_addresses

Fields

vw_suppression_list_addresses

Name	Datatype	Description
addressId	text	field from the properties object
data_location	text	field from the properties object
domainName	text	field from the properties object
email	text	field from the properties object
emailServiceName	text	field from the properties object
first_name	text	field from the properties object
last_modified	text	field from the properties object
last_name	text	field from the properties object
notes	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
suppressionListName	text	field from the properties object

suppression_list_addresses

Name	Datatype	Description
properties	object	A class that describes the properties of a SuppressionListAddress resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	addressId, domainName, emailServiceName, resourceGroupName, subscriptionId, suppressionListName	Get a SuppressionListAddress.
list	SELECT	domainName, emailServiceName, resourceGroupName, subscriptionId, suppressionListName	Get all the addresses in a suppression list.
create_or_update	INSERT	addressId, domainName, emailServiceName, resourceGroupName, subscriptionId, suppressionListName	Create or update a SuppressionListAddress.
delete	DELETE	addressId, domainName, emailServiceName, resourceGroupName, subscriptionId, suppressionListName	Operation to delete a single address from a suppression list.

SELECT examples

Get all the addresses in a suppression list.

vw_suppression_list_addresses

SELECT
addressId,
data_location,
domainName,
email,
emailServiceName,
first_name,
last_modified,
last_name,
notes,
resourceGroupName,
subscriptionId,
suppressionListName
FROM azure.communication.vw_suppression_list_addresses
WHERE domainName = '{{ domainName }}'
AND emailServiceName = '{{ emailServiceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND suppressionListName = '{{ suppressionListName }}';

suppression_list_addresses

SELECT
properties
FROM azure.communication.suppression_list_addresses
WHERE domainName = '{{ domainName }}'
AND emailServiceName = '{{ emailServiceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND suppressionListName = '{{ suppressionListName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.communication.suppression_list_addresses (
addressId,
domainName,
emailServiceName,
resourceGroupName,
subscriptionId,
suppressionListName,
properties
)
SELECT 
'{{ addressId }}',
'{{ domainName }}',
'{{ emailServiceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ suppressionListName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: email
          value: string
        - name: firstName
          value: string
        - name: lastName
          value: string
        - name: notes
          value: string
        - name: lastModified
          value: string
        - name: dataLocation
          value: string

DELETE example

Deletes the specified suppression_list_addresses resource.

/*+ delete */
DELETE FROM azure.communication.suppression_list_addresses
WHERE addressId = '{{ addressId }}'
AND domainName = '{{ domainName }}'
AND emailServiceName = '{{ emailServiceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND suppressionListName = '{{ suppressionListName }}';