Retrieve volumes in DigitalOcean.
View Specific Information
Digital Ocean supports filtering Volumes by specifying Id column with "=" operator in WHERE clause. Digital Ocean also supports filtering by specifying Name AND RegionSlug in WHERE clause.
SELECT * FROM Volumes WHERE Id='3d43f410-52fa-11e8-ab02-0242ac11500d' SELECT * FROM Volumes WHERE Name='volume-tor1-01' AND RegionSlug='tor1'
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.
|Id [KEY]||String||The unique identifier for the Block Storage volume.|
|Name||String||A human-readable name for the Block Storage volume. Must be lowercase and be composed only of numbers, letters and '-', up to a limit of 64 characters.|
|Description||String||An optional free-form text field to describe a Block Storage volume.|
|A human-readable string that is used as a unique identifier for each region.|
|DropletIds||String||An array containing the IDs of the Droplets the volume is attached to. Note that at this time, a volume can only be attached to a single Droplet.|
|SizeGigabytes||Double||The size of the Block Storage volume in Gigabytes.|
|CreatedAt||Datetime||The date and time value that represents when the Block Storage volume was created.|
|FilesystemType||String||The type of filesystem currently in-use on the volume.|
|FilesystemLabel||String||The label currently applied to the filesystem.|
|Tags||String||An array of Tags the volume has been tagged with.|