Retrieve Load Balancers in DigitalOcean.
View Specific Information
Digital Ocean supports only Id column with "=" operator as filter criteria for this view.
SELECT * FROM Loadbalancers WHERE Id='ae120e99-bb8a-4879-a6cd-10612ba7ae82'
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||A unique ID that can be used to identify and reference a Load Balancer.|
|Name||String||A human-readable name for a Load Balancer instance.|
|Ip||String||An attribute containing the public-facing IP address of the Load Balancer.|
|Algorithm||String||The load balancing algorithm used to determine which backend Droplet will be selected by a client. It must be either 'round_robin' or 'least_connections'.|
|Status||String||A status string indicating the current state of the Load Balancer. This can be 'new', 'active', or 'errored'.|
|The region slug where the Load Balancer instance is located.|
|CreatedAt||Datetime||The date and time value that represents when the Load Balancer was created.|
|HealthCheckProtocol||String||The protocol used for health checks sent to the backend Droplets. The possible values are 'http' or 'tcp'.|
|HealthCheckPort||Integer||An integer representing the port on the backend Droplets on which the health check will attempt a connection.|
|HealthCheckPath||String||The path on the backend Droplets to which the Load Balancer instance will send a request.|
|HealthCheckIntervalSeconds||Integer||The number of seconds between two consecutive health checks.|
|HealthCheckResponseTimeoutSeconds||Integer||The number of seconds between two consecutive health checks.|
|HealthCheckUnhealthyThreshold||Integer||The number of times a health check must fail for a backend Droplet to be marked 'unhealthy' and be removed from the pool.|
|HealthCheckHealthyThreshold||Integer||The number of times a health check must pass for a backend Droplet to be marked 'healthy' and be re-added to the pool.|
|StickySessionsType||String||An attribute indicating how and if requests from a client will be persistently served by the same backend Droplet. The possible values are 'cookies' or 'none'.|
|StickySessionsCookieName||String||The name of the cookie sent to the client. This attribute is only returned when using 'cookies' for the sticky session's type.|
|StickySessionsCookieTtlSeconds||String||The number of seconds until the cookie set by the Load Balancer expires. This attribute is only returned when using 'cookies' for the sticky session's type.|
|Tag||String||The name of a Droplet tag corresponding to Droplets assigned to the Load Balancer.|
|DropletIds||String||An array containing the IDs of the Droplets assigned to the Load Balancer.|
|RedirectHttpToHttps||Boolean||A boolean value indicating whether HTTP requests to the Load Balancer on port 80 will be redirected to HTTPS on port 443.|