SSIS Components for Microsoft SharePoint

Build 24.0.9060

Groups

Creates, updates, deletes, and queries 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060