Reference Guide

Comparator Description Applicable data
types
Example
lte
Less than or equal.
Returns true when the expression on the left
of =eq is less than or equal to the
expression on the right.
All
?
modify_time=lte.2018-05-07T17:
56:28.859+00:00
True if the value of modify_time is
2018-05-07T17:56:28.859+00:00 or
earlier.
neq
Not equal.
Returns true when the expression on the left
of =eq is not equal to the expression on the
right.
All
?role_id=neq.3
True if the value of role_id is anything
other than Operator.
ilike
Case-insensitive substring match.
Returns true when the expression on the left
of =eq, including its case, matches the
expression on the right. Use * for a
wildcard.
String
?name=ilike.User*
True if the value of name starts with
User.
in
One of a list of values.
Returns true when the expression on the left
of =eq matches any value in the comma-
separated list on the right.
All
?role_id=in.
(operator,administrator,servic
e)
True if the value of role_id is
Operator, Administrator, or VM
Administrator.
is
Checks for exact equality to null, true, or
false values.
null (All), true,
false (Boolean)
?description=is.null
cs
Contains. List of any type
?supported_speeds=cs.
{1_Gbps,10_Gbps}
True if the speeds array contains 1 Gbps
and 10 Gbps.
cd
Contained in. List of any type
?server_addresses=cd.
{"1.2.3.4","5.6.7.8"}
True if the values in the server addresses
list are all either 1.2.3.4 or 5.6.7.8.
not
Negates the operator that follows. All
?resource_type=not.in.
(Operator,Administrator,VM
Administrator)
True if the value of role_id is not
Operator, Administrator, or VM
Administrator.
and
All the conditions in the parentheses that
follow must be true in order for the request
to evaluate as true.
NOTE: The default for multiple filters is
to AND them, so the use of and is
optional unless you are using both and
and or in the filter expression.
All
?
and=(size.gt.50,performance_po
licy_id.eq.default_high)
True if the value of size is greater than
50 MB and the value of
performance_policy is High.
or
At least one of the conditions in the
parentheses that follow must be true in
order for the request to evaluate as true.
All
?
or=(size.gt.50,performance_pol
icy_id.eq.default_high)
Querying a resource 29