Read, add, and remove members in groups within your Smartsheet account.

Table-specific Information

SELECT

Retrieve all members in a specific group.

SELECT * FROM Info_GroupMembers WHERE GroupId = '2035256120371076'

INSERT

You can add a member to a group by providing the GroupId and Email columns as shown in the following example query:

INSERT INTO Info_GroupMembers (GroupId, Email) VALUES ('2035256120371076', '[email protected]')

DELETE

You can remove a member from a group by specifying the GroupId and Id columns in the criteria as shown in the following example query:

DELETE FROM Info_GroupMembers WHERE GroupId = '2035256120371076' AND UserId = '4417793262151556'

Columns

Name	Type	ReadOnly	References	Description
UserId [KEY]	String	True	Info_Users.Id	The unique identifier of the user.
GroupId [KEY]	String	False	Info_Groups.Id	The unique identifier of the group.
Email	String	False		The email address of the user.
FirstName	String	True		The first name of the user.
LastName	String	True		The last name of the user.
Name	String	True		The full name of the user.