Generic properties

For instance, to query all entities with a certain Title:

GET http://<HOSTNAME>/api/entities/query?query=String('Title')=='title'

You can also search for an empty string:

/api/entities/query?query=String('Title')==""

This can be used for multi-language queries as well:

/api/entities/query?query=String('Title', 'en-US')==""

For instance, to query all entities with a certain IntProperty:

GET http://<HOSTNAME>/api/entities/query?query=Int('IntProperty')==1

For instance, to query all entities with a certain LongProperty:

GET http://<HOSTNAME>/api/entities/query?query=Long('LongProperty')==5000000000

For instance, to query all entities with a certain DecimalProperty:

GET http://<HOSTNAME>/api/entities/query?query=Decimal('DecimalProperty')==1.5

For instance, to query all entities with a certain FloatProperty:

GET http://<HOSTNAME>/api/entities/query?query=Float('FloatProperty')==1.5

For instance, to query all entities created after a certain date:

GET http://<HOSTNAME>/api/entities/query?query=DateTime('CreatedOn') gte 20141213

The DateTime representation follows the international standard ISO8601 covering the exchange of date and time-related data.

There are two formats available via the REST API itself: YYYYMMDD and YYYYMMDDTHHMMSS.

The following formats are available via the Querying API:

Booleans do not support any operators, but can be negated.

For instance, to query all draft entities:

GET http://<hostname>/api/entities/query?query=Bool('IsDraft')

To use multilanguage properties when querying entities, specify the culture to filter on.

For instance, to fetch all the M.Brand entities with the fruitful Brandlabel, in en-US:

GET http://<HOSTNAME>/api/entities/query?query=Definition.Name == "M.Brand" AND String("BrandLabel", "en-US") == "Fruitful"