# GroupMembers ## Documentation The members of the groups, one request per group. - Catalog: `Smartsheet` - Schema: `Users` - Primary Keys: `group_id, user_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `GroupMembers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `email` | `varchar2` | | ☐ | The e-mail address of the member. | | `first_name` | `varchar2` | | ☐ | The first name of the member. | | `group_id` | `int64` | | ☑ | The group. | | `last_name` | `varchar2` | | ☐ | The last name of the member. | | `name` | `varchar2` | | ☐ | The name of the member. | | `user_id` | `int64` | | ☑ | The member. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `group_id` | [[Users-Groups\|Users.Groups]] | `group_id` | Declared by the connector, not enforced by the platform | | `user_id` | [[Users-Users\|Users.Users]] | `user_id` | In words only: Holds for a member who is a user of the organisation. |