Excel Add-In for Microsoft SharePoint

Build 24.0.8963

Roles

Creates, updates, deletes, and queries Roles from SharePoint.

Table Specific Information

Select

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.

Insert

To insert a Role, at a minimum the Name is required:

INSERT INTO Roles (Name) VALUES ('My Role')

Columns

Name Type ReadOnly Description
Name# [KEY] String False

The name of the role.

Description# String False

A description of the role.

Permissions# Long False

A long representing the permissions for the role.

RoleType String True

The type of role.

IsHidden Boolean True

A boolean indicating if the role is hidden.

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 login name of the user to return roles for. Specify this value on a SELECT statement to return only roles assigned to the specified user.

GroupName String

The name of the group to return roles for. Specify this value on a SELECT statement to return only roles assigned to the specified group.

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