record_sets

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

Overview

Name	record_sets
Type	Resource
Id	azure.dns.record_sets

Fields

vw_record_sets

Name	Datatype	Description
id	text	The ID of the record set.
name	text	The name of the record set.
a_records	text	field from the properties object
aaaa_records	text	field from the properties object
caa_records	text	field from the properties object
cname_record	text	field from the properties object
ds_records	text	field from the properties object
etag	text	The etag of the record set.
fqdn	text	field from the properties object
metadata	text	field from the properties object
mx_records	text	field from the properties object
naptr_records	text	field from the properties object
ns_records	text	field from the properties object
provisioning_state	text	field from the properties object
ptr_records	text	field from the properties object
recordType	text	field from the properties object
relativeRecordSetName	text	field from the properties object
resourceGroupName	text	field from the properties object
soa_record	text	field from the properties object
srv_records	text	field from the properties object
subscriptionId	text	field from the properties object
target_resource	text	field from the properties object
tlsa_records	text	field from the properties object
traffic_management_profile	text	field from the properties object
ttl	text	field from the properties object
txt_records	text	field from the properties object
type	text	The type of the record set.
zoneName	text	field from the properties object

record_sets

Name	Datatype	Description
id	string	The ID of the record set.
name	string	The name of the record set.
etag	string	The etag of the record set.
properties	object	Represents the properties of the records in the record set.
type	string	The type of the record set.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	recordType, relativeRecordSetName, resourceGroupName, subscriptionId, zoneName	Gets a record set.
list_by_dns_zone	SELECT	resourceGroupName, subscriptionId, zoneName	Lists all record sets in a DNS zone.
list_by_type	SELECT	recordType, resourceGroupName, subscriptionId, zoneName	Lists the record sets of a specified type in a DNS zone.
create_or_update	INSERT	recordType, relativeRecordSetName, resourceGroupName, subscriptionId, zoneName	Creates or updates a record set within a DNS zone. Record sets of type SOA can be updated but not created (they are created when the DNS zone is created).
delete	DELETE	recordType, relativeRecordSetName, resourceGroupName, subscriptionId, zoneName	Deletes a record set from a DNS zone. This operation cannot be undone. Record sets of type SOA cannot be deleted (they are deleted when the DNS zone is deleted).
update	UPDATE	recordType, relativeRecordSetName, resourceGroupName, subscriptionId, zoneName	Updates a record set within a DNS zone.

SELECT examples

Lists all record sets in a DNS zone.

vw_record_sets

SELECT
id,
name,
a_records,
aaaa_records,
caa_records,
cname_record,
ds_records,
etag,
fqdn,
metadata,
mx_records,
naptr_records,
ns_records,
provisioning_state,
ptr_records,
recordType,
relativeRecordSetName,
resourceGroupName,
soa_record,
srv_records,
subscriptionId,
target_resource,
tlsa_records,
traffic_management_profile,
ttl,
txt_records,
type,
zoneName
FROM azure.dns.vw_record_sets
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND zoneName = '{{ zoneName }}';

record_sets

SELECT
id,
name,
etag,
properties,
type
FROM azure.dns.record_sets
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND zoneName = '{{ zoneName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dns.record_sets (
recordType,
relativeRecordSetName,
resourceGroupName,
subscriptionId,
zoneName,
etag,
properties
)
SELECT 
'{{ recordType }}',
'{{ relativeRecordSetName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ zoneName }}',
'{{ etag }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string
    - name: properties
      value:
        - name: metadata
          value: object
        - name: TTL
          value: integer
        - name: fqdn
          value: string
        - name: provisioningState
          value: string
        - name: targetResource
          value:
            - name: id
              value: string
        - name: ARecords
          value:
            - - name: ipv4Address
                value: string
        - name: AAAARecords
          value:
            - - name: ipv6Address
                value: string
        - name: MXRecords
          value:
            - - name: preference
                value: integer
              - name: exchange
                value: string
        - name: NSRecords
          value:
            - - name: nsdname
                value: string
        - name: PTRRecords
          value:
            - - name: ptrdname
                value: string
        - name: SRVRecords
          value:
            - - name: priority
                value: integer
              - name: weight
                value: integer
              - name: port
                value: integer
              - name: target
                value: string
        - name: TXTRecords
          value:
            - - name: value
                value:
                  - string
        - name: CNAMERecord
          value:
            - name: cname
              value: string
        - name: SOARecord
          value:
            - name: host
              value: string
            - name: email
              value: string
            - name: serialNumber
              value: integer
            - name: refreshTime
              value: integer
            - name: retryTime
              value: integer
            - name: expireTime
              value: integer
            - name: minimumTTL
              value: integer
        - name: caaRecords
          value:
            - - name: flags
                value: integer
              - name: tag
                value: string
              - name: value
                value: string
        - name: DSRecords
          value:
            - - name: keyTag
                value: integer
              - name: algorithm
                value: []
              - name: digest
                value:
                  - name: algorithmType
                    value: []
                  - name: value
                    value: string
        - name: TLSARecords
          value:
            - - name: usage
                value: integer
              - name: selector
                value: integer
              - name: matchingType
                value: integer
              - name: certAssociationData
                value: string
        - name: NAPTRRecords
          value:
            - - name: order
                value: integer
              - name: preference
                value: integer
              - name: flags
                value: string
              - name: services
                value: string
              - name: regexp
                value: string
              - name: replacement
                value: string

UPDATE example

Updates a record_sets resource.

/*+ update */
UPDATE azure.dns.record_sets
SET 
etag = '{{ etag }}',
properties = '{{ properties }}'
WHERE 
recordType = '{{ recordType }}'
AND relativeRecordSetName = '{{ relativeRecordSetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND zoneName = '{{ zoneName }}';

DELETE example

Deletes the specified record_sets resource.

/*+ delete */
DELETE FROM azure.dns.record_sets
WHERE recordType = '{{ recordType }}'
AND relativeRecordSetName = '{{ relativeRecordSetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND zoneName = '{{ zoneName }}';