Retrieve Domain Records in DigitalOcean.
View Specific Information
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.
|Id [KEY]||Integer||A unique identifier for each domain record.|
|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|