Skip to content
  1. Extras
  2. GoogleSheets
  3. Export
  4. Clients

Clients (msClient)

Export fields

All standard user fields supported with user_ prefix. E.g. user_email, user_fullname

Export example

Export fields: id,user_id,user_username,user_email

Table result:

Table result

System events

Class gsUser fires these events:

php
<?php
switch ($modx->event->name) {
  // fetches the list of clients
  case 'gsOnBeforeGetClients':
    // $query - selection query
    // $range - sheet name, where data will be exported
    break;
  case 'gsOnGetClients':
    // $users - array of clients with all fields
    // $range - sheet name
    break;
}