SSIS Components for DigitalOcean

Build 20.0.7587

DomainRecords

Retrieve Domain Records in DigitalOcean.

View Specific Information

Select

To get a listing of all records configured for a domain, Digital Ocean requires that DomainName should be specified in WHERE clause with "=" operator. To retrieve a specific domain record DomainName AND Id should be specified. All other filters are supported client side.

SELECT * FROM DomainRecords WHERE DomainName='www.example.com'

SELECT * FROM DomainRecords WHERE DomainName='www.example.com' AND Id=47943337

If a DomainName is not specified, the CData SSIS Components for DigitalOcean will internally append the filter:

WHERE DomainName IN (SELECT Domains.Name FROM Domains)

It is recommended to always specify at least one DomainName in the criteria to provide the best performance available.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case you must specify at least DomainName. The DigitalOcean API requires that queries contain this filter.

Columns

Name Type References Description
Id [KEY] Integer A unique identifier for each domain record.
DomainName String

Domains.Name

The domain name for this record.
Type String The type of the DNS record. For example: A, CNAME, TXT, etc. Required to insert for all record types.
Name String The host name, alias, or service being defined by the record. Required to insert for domain record type: A, AAAA, CAA, CNAME, TXT, SRV
Data String Variable data depending on record type. For example, the 'data' value for an A record would be the IPv4 address to which the domain will be mapped. For a CAA record, it would contain the domain name of the CA being granted permission to issue certificates.Required to insert for domain record type: A, AAAA, CAA, CNAME, MX, TXT, SRV, NS.
Priority Integer The priority for SRV and MX records. Required to insert for domain record type: MX, SRV
Port Integer The port for SRV records. Required to insert for domain record type: SRV
Ttl Integer This value is the time to live for the record, in seconds. This defines the time frame that clients can cache queried information before a refresh should be requested.
Weight Integer The weight for SRV records. Required to insert for domain record type: SRV
Flags Integer An unsigned integer between 0-255 used for CAA records. Required to insert for domain record type: CAA
Tag String The parameter tag for CAA records. Valid values are 'issue', 'wildissue', or 'iodef'. Required to insert for domain record type: CAA

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587