API-V2 REST Querystring-Parameter

skip

[Number]

Start-Index (0-based)

take

[Number]

Number of elements to be selected

totalcount

true / false

If the value “true” is specified, the response contains the header “X-TotalCount” with the total number of results (Skip / Take is ignored)

fields

List of properties

The selected properties of the object are queried

sort

List of properties
Prefix “+” for “-” for ascending / descending

The list is sorted based on the selected properties (Before pagination)

filter

[Property] [Operator] [Value]

The list is filtered based on the selected filters

and(xxx,yyy)

Link several filters “and”

or(xxx,yyy)

Link several filters “or”

eq

Check whether the property value is equal to the value

!eq

Checks whether the property value is not equal to the value

contains

Checks whether the value is contained i the property value

!contains

Checks whether the value is not contained in the property value

starts_with

Checks whether the property value begins with the value

!starts_with

Checks whether the property value does not start with the value

ends_with

Checks whether the property value ends with the value

!ends_with

Checks whether the property value does not end wit the value

like

checks whether the property value corresponds to the pattern

Wildcards:
*: Any number (0-n) Any character
?: Any character

!like

Checks whether the property value does not match the pattern

Wildcards:
*: Any number (0-n) Any character
?: Any character

gt

Checks whether the property value is greater than the value

ge

Checks whether the property value is greater than or equal to the value

lt

Checks whether the property value is less than the value

le

Checks whether the property value is less than or equal to the value

match

Checks whether the property value corresponds to the regex value

!match

Checks whether the property value does not match the regex value

isnull (alt. is_null)

Checks whether the property value is null. Exception will be thrown when checking on non-nullable field

innotnull (alt. is_not_null)

Checks whether the property value is not null. Exception will be thrown when checking on non-nullable field