Excel Add-In for Microsoft SharePoint

Build 24.0.8963

Users

Query the available users on your sharepoint site.

Table Specific Information

Select


SELECT * FROM Users // Fetch all the Users
SELECT * FROM Users WHERE GroupId = 5 // Fetch a user for a particular Group

Columns

Name Type References Description
AadObjectId_NameId String
AadObjectId_NameIdIssuer String
Email String
Expiration String
IsEmailAuthenticationGuestUser Bool
IsShareByEmailGuestUser Bool
IsSiteAdmin Bool
UserId_NameId String
UserId_NameIdIssuer String
UserPrincipalName String
LinkedAlerts String
LinkedGroups String
LoginName String The login name of the user.
Title String The Title of the user.
IsHiddenInUI Boolean A boolean indicating if the user is hidden in UI.
GroupId Int The group id the user is added to.

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