...
| In Query | Meaning | Valid for <type> | |||
|---|---|---|---|---|---|
eq | = | f | |||
lte | <= | f | |||
lt | < | f | |||
gte | >= | f | |||
gt | > | f | |||
like | SQL LIKE operator | f | |||
ilike | SQL ILIKE operator | f | |||
| isNullisnull | SQL is null operator | f / fa | NotNull | SQL is not null operator(not) null operator value: "true","t","1" (= is Null) or "false","f","0" (= is not Null) | f / fa |
| contains | array field contains all of the values | fa | |||
| containedby | array field is contained by by the list of values | fa | |||
| overlap | array field and list of values overlap | fa |
If no operator is given the default default eq operator operator will be used for fields and contains for arrays.
Examples
"data" is a database field of type JSON, you can even query into the JSON structure.
Please note that these fields are not indexed. For performance reasons always limit the result set e.g. by setting a date range.
| Code Block | ||
|---|---|---|
| ||
# Query JSON field "data.mbus.Id" for a number &f:data.mbus.Id=eq:130567728 # Query JSON field "data.mbus.IdString" for a string &f:data.mbus.IdString=eq:"10130567728" |
To filter a date range, the same filter can be applied multiple times with different operators
| Code Block | ||
|---|---|---|
| ||
&f:createdAt=gt:2000-01-01T02:37:00%2B01:00?f:createdAt=lt:2000-01-02T02:37:00%2B01:00 |
Usage recommendations
- Set the gzip encoding header to reduce network traffic:
Accept-Encoding:gzip
- Use pagination with page sizes smaller than 10.000 entries
...
| Description | Method | Header | URL | URL Path Params | URL Query Params | Request Payload | Return |
|---|---|---|---|---|---|---|---|
| Downlink creation | POST |
| /api/devices/{devId}/downlikdownlink |
|
| The Body contains the downlink content. See also: Downlinks |
|
| Device creation | POST |
| /api/devices | - | - | deviceInput as JSON { "name": "Gateway_1", "addr": "FFFFFFFFFFFFFFFF", "description": "3.OG Wohnung Müller", "deviceTypeId": 2, "initialConfig": null, "location": null, "serial": "1337", "tags": ["Müller", "MbusGw", "3.OG"], "certEnforcesDtls": false } |
|
| User creation | POST |
| /api/organisation/user | - | - | userInput as JSON : |
|
...