Groups
Create, update, delete, and query Groups from SharePoint.
Table Specific Information
Insert
The Name, DefaultLogin, and OwnerLogin columns are required to insert to this table.
To use the UserName pseudo column, you must set the value to the LoginName of the user. You can obtain the LoginName by querying the Users table.
Columns
| Name | Type | ReadOnly | Description |
| Name# [KEY] | String | False |
The name of the group. |
| Description# | String | False |
A description of the group. |
| OwnerLogin# | String | False |
The user name of the owner of the group. This value should be in the format DOMAIN\\username. |
| OwnerType# | String | False |
The type of owner. User or group. |
| DefaultLogin# | String | False |
The user name of the default user for the group. This value should be in the format DOMAIN\\username. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UserName | String |
The logical name of the user to return groups for. Specify this value on the SELECT statement to return only groups the specified User is in. |