Skip to content

MngGetCustomersByFilter

Returns a paginated customer list.

email and phone are masked in this list response. Email domain remains visible. Filtering works against full stored values.

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: [["created_time", "desc"]]

Request

{
  "command": "MngGetCustomersByFilter",
  "extID": "1",
  "data": {
    "limit": 50,
    "offset": 0,
    "where": [
      ["email", "like", "example.com"]
    ],
    "orderBy": [
      ["created_time", "desc"]
    ]
  }
}

Response Data

{
  "rows": [
    {
      "customer_id": 1,
      "email": "cl***@example.com",
      "phone": "+35***000",
      "full_name": "John Smith",
      "status": 0
    }
  ],
  "count": 1
}