SSIS Components for DigitalOcean

Build 20.0.7587

Droplets

Retrieve Droplets in DigitalOcean.

View Specific Information

Select

Digital Ocean supports only Id and TagName columns with "=" operator as filter criteria for this view.

SELECT * FROM Droplets WHERE Id=99585958

SELECT * FROM Droplets WHERE TagName='tag1'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Id [KEY] Integer A unique identifier for each Droplet instance. This is automatically generated upon Droplet creation.
Name String The human-readable name set for the Droplet instance.
Memory Integer Memory of the Droplet in megabytes.
Vcpus Integer The number of virtual CPUs.
Disk Integer The size of the Droplet's disk in gigabytes.
Locked Boolean A boolean value indicating whether the Droplet has been locked, preventing actions by users.
Status String A status string indicating the state of the Droplet instance. This may be 'new', 'active', 'off', or 'archive'.
BackupIds String An array of backup IDs of any backups that have been taken of the Droplet instance. Droplet backups are enabled at the time of the instance creation.
SnapshotIds String An array of snapshot IDs of any snapshots created from the Droplet instance.
Features String An array of features enabled on the Droplet.
RegionSlug String

Regions.Slug

The slug of the region where the Droplet instance is deployed in.
ImageId Long

Images.Id

The id of base image used to create the Droplet instance.
SizeSlug String

Sizes.Slug

The unique slug identifier for the size of this Droplet.
KernelId Integer The id of current kernel.
KernelName String The display name of the current kernel.
KernelVersion String A standard kernel version string representing the version, patch, and release information.
NextBackupWindow String The details of the Droplet's backups feature, if backups are configured for the Droplet. This object contains keys for the start and end times of the window during which the backup will start.
Tags String An array of Tags the Droplet has been tagged with.
VolumeIds String A flat array including the unique identifier for each Block Storage volume attached to the Droplet.
CreatedAt Datetime The date and time value that represent when the Droplet was created.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TagName String Tag name used to query the table.

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