List Clients (DataTable)

Retrieve a paginated list of clients with advanced filtering, sorting, and field selection.

GET /datatable-clients
Query Parameters
Parameter Type Description Example
range integer Items per page (default: 25) ?range=50
page integer Page number (0-indexed) ?page=2
sort string Sort field and direction ?sort=-updated
filter[status] string Client status ?filter[status]=approved
global_search string Search across multiple fields ?global_search=john
Example Requests
GET /api/v1.0/datatable-clients?range=25&sort=-updated
GET /api/v1.0/datatable-clients?filter[status]=approved&filter[country]=US&sort=-updated&range=25
GET /api/v1.0/datatable-clients?filter[uuid][value][0]=abc123&filter[uuid][value][1]=def456&filter[uuid][operator]=IN
Response
{
  "data": [
    {
      "id": "123",
      "uuid": "abc-def-123",
      "first_name": "John",
      "last_name": "Doe",
      "email": "john.doe@example.com",
      "status": { "id": "approved", "label": "Approved" },
      "balance": { "value": 1250.50, "formatted": "$1,250.50" },
      "updated": "2025-10-15T14:30:00Z"
    }
  ],
  "count": 342
}
Back to API Home