Users
The Users resource provides methods that allow you to manage users for the account.
Table Specific Information
Select
The component will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE Id = '9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
Name | Type | Description |
aboutMe | String | |
accountEnabled | Bool | |
ageGroup | String | |
assignedLicenses | String | |
assignedPlans | String | |
birthday | Datetime | |
businessPhones | String | |
city | String | |
companyName | String | |
consentProvidedForMinor | String | |
country | String | |
department | String | |
deviceEnrollmentLimit | Int | |
displayName | String | |
employeeId | String | |
faxNumber | String | |
givenName | String | |
hireDate | Datetime | |
imAddresses | String | |
interests | String | |
isResourceAccount | Bool | |
jobTitle | String | |
legalAgeGroupClassification | String | |
licenseAssignmentStates | String | |
String | ||
mailboxSettings_automaticRepliesSetting_status | String | |
mailboxSettings_automaticRepliesSetting_externalAudience | String | |
mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_dateTime | String | |
mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_timeZone | String | |
mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | |
mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | |
mailboxSettings_archiveFolder | String | |
mailboxSettings_timeZone | String | |
mailboxSettings_language_locale | String | |
mailboxSettings_language_displayName | String | |
mailboxSettings_workingHours_daysOfWeek | String | |
mailboxSettings_workingHours_startTime | Time | |
mailboxSettings_workingHours_endTime | Time | |
mailboxSettings_workingHours_timeZone_name | String | |
mailNickname | String | |
mobilePhone | String | |
mySite | String | |
officeLocation | String | |
onPremisesDistinguishedName | String | |
onPremisesDomainName | String | |
onPremisesExtensionAttributes_extensionAttribute1 | String | |
onPremisesExtensionAttributes_extensionAttribute2 | String | |
onPremisesExtensionAttributes_extensionAttribute3 | String | |
onPremisesExtensionAttributes_extensionAttribute4 | String | |
onPremisesExtensionAttributes_extensionAttribute5 | String | |
onPremisesExtensionAttributes_extensionAttribute6 | String | |
onPremisesExtensionAttributes_extensionAttribute7 | String | |
onPremisesExtensionAttributes_extensionAttribute8 | String | |
onPremisesExtensionAttributes_extensionAttribute9 | String | |
onPremisesExtensionAttributes_extensionAttribute10 | String | |
onPremisesExtensionAttributes_extensionAttribute11 | String | |
onPremisesExtensionAttributes_extensionAttribute12 | String | |
onPremisesExtensionAttributes_extensionAttribute13 | String | |
onPremisesExtensionAttributes_extensionAttribute14 | String | |
onPremisesExtensionAttributes_extensionAttribute15 | String | |
onPremisesImmutableId | String | |
onPremisesLastSyncDateTime | Datetime | |
onPremisesProvisioningErrors | String | |
onPremisesSamAccountName | String | |
onPremisesSecurityIdentifier | String | |
onPremisesSyncEnabled | Bool | |
onPremisesUserPrincipalName | String | |
otherMails | String | |
passwordPolicies | String | |
passwordProfile_password | String | |
passwordProfile_forceChangePasswordNextSignIn | Bool | |
passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | |
pastProjects | String | |
postalCode | String | |
preferredLanguage | String | |
preferredName | String | |
provisionedPlans | String | |
proxyAddresses | String | |
responsibilities | String | |
schools | String | |
showInAddressList | Bool | |
signInSessionsValidFromDateTime | Datetime | |
skills | String | |
state | String | |
streetAddress | String | |
surname | String | |
usageLocation | String | |
userPrincipalName | String | |
userType | String | |
Id [KEY] | String |