MngGetDesksByFilter¶
Returns paginated CRM desk records.
Request Parameters¶
| Name | Type | Required | Description |
|---|---|---|---|
limit |
int | Yes | Maximum rows, from 1 to 50000 |
offset |
int | Yes | Pagination offset |
where |
array | No | [[field, operator, value], ...] |
whereNot |
array | No | [[field, value], ...] |
whereIn |
array | No | [[field, [values...]], ...] |
whereNotIn |
array | No | [[field, [values...]], ...] |
whereBetween |
array | No | [[field, [from, to]], ...] |
whereNotBetween |
array | No | [[field, [from, to]], ...] |
orderBy |
array | No | Example: [["sort_index", "asc"]] |
Supported filter fields:
deskbrandnamestatusenablemanager_idsort_indexcreated_timeupdated_time
Request¶
{
"command": "MngGetDesksByFilter",
"extID": "1",
"data": {
"limit": 100,
"offset": 0,
"where": [
["brand", "=", "default"],
["enable", "=", 1]
],
"orderBy": [
["sort_index", "asc"]
]
}
}
Response Data¶
{
"rows": [
{
"desk": "DESK_RETENTION",
"brand": "default",
"name": "Retention",
"status": 0,
"enable": 1,
"manager_id": 10,
"sort_index": 100,
"created_time": 1710000000,
"updated_time": 1710000000
}
],
"count": 1
}