{
"offset": 0,
"limit": 10,
"order": {
"column1" : "ASC",
"column2" : "DESC"
},
"filter": [CRITERIA_LIST],
}
{
"column": "column_name",
"operator": "LIKE",
"value": "filter_falue",
}
Operator field supports opertaors similar to sql:
- < - less than
-
- more than
- = - equals
- <> - not equals
- LIKE - match pattern
- NOT LIKE - not match pattern