Use HTTP_ACCEPT: application/json to get JSON only.
Selecting columns
By default, only one or several default columns are displayed (e.g., the type). To select more columns, use the select parameter:
http://sr/dlexdb/kern/cc0/filter/?select=COL1[,COL2...]
If using select, the default columns are discarded
unless you include them manually.
The default column selection is subject to change. Don't rely on it in your application!
Sorting
http://sr/dlexdb/kern/cc0/filter/?orderby=[-]COL
The default sort order is subject to change. Don't rely on it in your application!
Limit and offset
http://sr/dlexdb/kern/cc0/filter/?top=N&skip=M
Filtering
http://sr/dlexdb/kern/cc0/filter/?COL__OP=VALUE
All query parameters of the form COL__OP (two underscores), where COL is a column name and OP is an operator, will be interpreted as filter conditions.
Operators are:
eq | equals (for numbers or strings, case-sensitive) |
eqi | equals (for strings, case-insensitive) |
re | regular expression match (for strings, case-sensitive) |
rei | regular expression match (for strings, case-insensitive) |
ge | greater or equal (for numbers) |
le | less or equal (for numbers) |
Multiple filters on the same field using the same
operator are not allowed. One of them would be chosen
randomly while the others are discarded.
Case-insensitive string fields can be queried with either the eq or the eqi operator without difference.
