Mindconnect API – Filtering¶
General¶
All endpoints with the parameter filter
support basic filtering.
Wildcards are not supported. Timestamps must be in ISO-8601 format as follows: YYYY-MM-DDTHH:mm:ss.sssZ
, e.g.: 2018-10-04T07:58:49.369Z
.
When a filter has no matches, the response will be empty.
Filter functions¶
Function eq
(equals)¶
{
"agentId": "3b27818ea09a46b48c7eb3fbd878349f"
}
or
{
"agentId": {
"eq": "3b27818ea09a46b48c7eb3fbd878349f"
}
}
Function in
¶
The function in
is very similar to equals
, but instead matching to one value, it checks an array of values, and matches for any of them.
{
"agentId": {
"in": {
"value": ["3b27818ea09a46b48c7eb3fbd878349f", "9b27818ea09a46b48c7eb3fbd878349f"]
}
}
}
or
{
"agentId": {
"in": ["3b27818ea09a46b48c7eb3fbd878349f", "9b27818ea09a46b48c7eb3fbd878349f"]
}
}
Function endsWith
¶
{
"message": {
"endsWith": "Successful."
}
}
Function startsWith
¶
{
"message": {
"startsWith": "Dropped"
}
}
Function contains
¶
{
"message": {
"contains": "Timeseries"
}
}
Function before
¶
{
"timestamp": {
"before": "2018-01-01T00:00:00.00Z"
}
}
Function after
¶
{
"timestamp": {
"after": "2018-01-01T00:00:00.00Z"
}
}
Function between
¶
Checks if the value of the field is between the given range
Parentheses for inclusive date: [] Parentheses for exclusive date: ()
{
"timestamp": {
"between": "[2018-01-01T00:00:00.00Z, 2018-01-31T00:00:00.00Z)"
}
}
Filter operations¶
Operation not
¶
{
"not": {
"message": {
"startsWith": "Accepted"
}
}
}
or
{
"not": {
"message":"Accepted"
}
}
Operation or
¶
{
"message": {
"or": [
{"eq": "Data is Accepted"},
{"endsWith": "Accepted"}
]
}
}
or
{
"or": {
"message": {
"eq": null
},
"agentId": {
"startsWith": "3b27818ea09a46b48c7eb3fbd878349f"
}
}
}
Operation and
¶
{
"agentId":"3b27818ea09a46b48c7eb3fbd878349f",
"message": null
}
or
{
"and":{
"message": {
"eq": null
},
"agentId": {
"startsWith": "3b27818ea09a46b48c7eb3fbd878349f"
}
}
}
Last update: June 15, 2023
Except where otherwise noted, content on this site is licensed under the Development License Agreement.